| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I don't expect a right or wrong answer to this, but I'm interested to hear
what other people do.
In a large database, that is developing over time,...
Charles
|
09-07-2009 09:16 AM
Charles  | 2 | 31 |
| | | I have a very big table with a big BLOB column (Text) in it (SQL 2000)
I moved many BLOB columns to an archive db and deleted them from the sourc...
Gal
|
09-07-2009 02:34 AM
Uri Dimant | 5 | 46 |
| | | When I turn "set statistics io on" I get a report on the number of
read-ahead pages that were fetched during the statement run.
However, I didn't...
Neo
|
09-07-2009 01:59 AM
Neo | 0 | 30 |
| | | Hi everyone,
I a m new to Database structure and design, In my internals i have a
question for designing and querying the database, i have attend the...
rockyrules
|
09-06-2009 03:30 PM
Hugo Kornelis | 3 | 51 |
| | | If I have a query with multiple joins. How should I contract it for
the best performance: Start joining on the large table first and then
go down to...
tolcis
|
09-06-2009 04:15 AM
Erland Sommarskog | 5 | 72 |
| | | I have a SQL Job that keeps locking.
After further investigation using sp_lock and master.dbo.sysLockinfo, it
seems to be waiting to get a
Exclusive...
pablosteward
|
09-06-2009 03:09 AM
mary grace quisay | 3 | 101 |
| | | I have a normal "insert . . . Select from" statement (I did not write it).
The source table is 4 gig. The db's log grows to 45 gig during...
Snake
|
09-05-2009 12:17 PM
Linchi Shea | 3 | 48 |
| | | Hi group,
I am using sql server 2005 replication.The subscription is built to be
on-demand.
when i want to connect to the publisher using a...
Ali
|
09-05-2009 12:05 PM
Linchi Shea | 2 | 42 |
| | | having 64 bit sql 2005 running on win 2003 on computer with 24
gb of ram . sql server is the only task running on this
computer.
when in perfmon...
sali
|
09-04-2009 09:47 PM
Andrew J. Kelly | 8 | 26 |
| | | http://sanssql.blogspot.com/2009_09_01_archive.html
Regards
Sandesh Segu
http://sanssql.blogspot.com
Sandy
|
09-04-2009 02:15 PM
Eric Isaacs | 1 | 38 |
| | | I have several new SQL Server 2005 and 2008 databases that we are going to
create in the new several months.
Please let me with a document that...
Joe K.
|
09-04-2009 01:09 PM
TheSQLGuru | 1 | 35 |
| | | I get the following error when i run a job which runs DTS package in 2008
imported from 2000:
Delete from Table .. Step, Error =
-2147467259...
Sang
|
09-04-2009 09:25 AM
Sang | 0 | 47 |
| | | I want to learn store procedure but I still do not know how to use output
parameters in a store procedure.
For example, there is one store procedure...
aspfun
|
09-04-2009 07:27 AM
Dan Guzman | 2 | 52 |
 | | I have a database with a lot of stored procedures, and over time the schema
has changed such that some sprocs won't run. It would be a headache to...
Charles
|
09-04-2009 07:24 AM
Charles | 19 | 48 |
| | | Hello,
Does anyone know how to translate the following SQL statement:
SELECT MIN(TableName) as TableName, Idx, Updated
FROM
(
SELECT 'CHIPS' as...
Unperceptual Solenopsis
|
09-03-2009 04:43 PM
Erland Sommarskog | 4 | 29 |
| | | Hi,
I have a stored proc (proc 1) that returns 2 result sets. How can I
capture them with another stored procedure (proc2).
I need to be able to...
tolcis
|
09-03-2009 02:34 PM
Daniel Jameson | 1 | 43 |
| | | Hi Everybody,
I don't expect any definitive answers, but was hoping to get some
advice on what to check or try next.
From linkedserver01, the...
Eric Bragas
|
09-03-2009 01:41 PM
Freedom Nut | 4 | 30 |
| | | I am using Windows backup utilities and setting an incremental backup to sun
at night. It runs the 1st night but never runs again. Can run one...
GenRev
|
09-03-2009 10:38 AM
Steen Schlüter Persson | 1 | 25 |
| | | Hi,
In order to mirror a database, you first need to create a backup of the
principal database, copy it to the partner, then restore it. There's a...
Gerry Hickman
|
09-03-2009 10:34 AM
Gerry Hickman | 6 | 32 |
| | | Hi,
I have seen that SQL2005 SP3 or SQL2008 SP1
http://blogs.msdn.com/petersad/archive/2009/08/11/sql-server-on-windows-7.aspx
are the versions...
Chris Wood
|
09-03-2009 09:52 AM
Chris Wood | 3 | 33 |
| | | All,
I posted this message to a thread dated 11/25/2004... I guess I should have
started a new thread.
Anyway, I am having a problem with database...
JimmyV
|
09-03-2009 09:46 AM
Russell Fields | 6 | 95 |
| | | We are upgrading from sql 2000 to sql2008 and leaving the compatebility level
of 8.
The developers asked me for a list of changes that they should be...
Gal
|
09-03-2009 12:42 AM
John Bell | 11 | 50 |
| | | I was using WireShark recently to find a problem on our network when I
noticed a constant stream of NetBIOS queries coming from our SQL
Server.
This...
Ray Greene
|
09-02-2009 10:03 PM
Ray Greene | 0 | 27 |
| | | I have a SQL Server 2008 database server that was installed as the
Enterprise Edition. I set up several SQL Server logins with db_datareader
access...
Joe K.
|
09-02-2009 07:28 PM
Daniel Jameson | 4 | 36 |
| | | Thanks in Advance.
I have a need to provide a user who has read-only access the ability
to create and alter views.
We are on MS SQL Server 2005 and...
Mark
|
09-02-2009 02:22 PM
TheSQLGuru | 5 | 42 |
| | | Hi all,
using sql 2008 sp1 32-bit
Here is strange one maybe someone could shed some light.
In studio when runing the same query in two different...
gv
|
09-02-2009 08:16 AM
gv | 1 | 21 |
| | | If I want to catch any error the client sees, How do I do it?
Gal
|
09-02-2009 07:28 AM
Uri Dimant | 1 | 24 |
| | | I am assigned to update one Access program to ASP.NET.
In Access program, there are a few queries to make a final result table to be
used in a...
aspfun via SQLMonster.com
|
09-02-2009 05:53 AM
sqlcatz@hotmail.com | 5 | 35 |
| | | Hi,
Our web server (IIS) and Sql servers were down this morning. I am a
bit new here but curious to know what might have happened. I heard
that all...
Learner
|
09-01-2009 06:07 PM
Geoff Schaller | 10 | 86 |
| | | declare @test table
(prodid int, serialno int)
insert into @test
select 1, 2220 union all
SELECT 1, 2221 UNION ALL
SELECT 1, 2222 UNION ALL
SELECT...
VJ
|
09-01-2009 10:54 AM
Plamen Ratchev | 6 | 31 |
| | | declare @test table
(month int, serialno int, statusID int)
insert into @test
select 1, 2220,1 union all
SELECT 2, 2220,1 UNION ALL
SELECT 3,...
VJ
|
09-01-2009 10:15 AM
Scott Morris | 1 | 24 |
| | | Can anyone confrim that NULL values when used for fixed lengh column like
datetime, CHAR etc. used that same amount of disk space as there are...
Chirag Shah
|
09-01-2009 09:58 AM
Tibor Karaszi | 4 | 41 |
| | | I have written a vb.net app that builds a URL string to a SQL report and
passes some params. The report is based off a stored proc with the...
user
|
09-01-2009 09:11 AM
user | 2 | 21 |
| | | Windows Server 2008 Standard SP2, x64
SQL 2005 (9.00.4035.00) SP3 Standard Edition
I am using a Maintenance Plan to perform a full backup of WSS on...
Kevin
|
09-01-2009 07:54 AM
Kevin | 6 | 27 |
| | | Hello,
---DDL start ---
CREATE TABLE #test
(
Tid TINYINT PRIMARY KEY,
Team VARCHAR(10),
CHAR(1) CHECK ( in('P','B')),
Abba
|
09-01-2009 04:32 AM
Abba | 9 | 39 |
| | | I am trying to backup a production database that is 30gb in size but I am
getting this error 25 minutes into the backup:
"Nonrecoverable I/O error...
Yankari
|
09-01-2009 03:28 AM
Tibor Karaszi | 4 | 27 |
| | | I am running SQL 2005 Standard, runtime license. I purchased SQL 2005
Standard because the runtime license no longer meets requirements.
I now want...
JP
|
08-31-2009 04:40 PM
Erland Sommarskog | 5 | 28 |
| | | Friends,
Our licensing terms require customers to use our C API to
insert/update/delete in our products DB. There is some business logic in
the C...
James Hunter Ross
|
08-31-2009 03:46 PM
James Hunter Ross | 2 | 23 |
| | | I need a query to give me all the results modified in a table, filtered by
date.
The date is as: "2009-08-30 18:00 "
Need
Select * from table
where...
Salvador
|
08-31-2009 03:18 PM
John Bell | 3 | 20 |
| | | can i use differential back up to initialize my transactional subscription?
my full back is too large to setup the replication for every maintenance...
sacgar
|
08-31-2009 03:12 PM
John Bell | 5 | 26 |
| | | Hi, how can I do a insert on more than 1 table?
if I've the table: Product(Id Integer PK)
I need to a insert on 3 tables inserting this ID. Can the...
Paulo
|
08-31-2009 02:45 PM
Russell Fields | 2 | 22 |
| | | Hi all,
Running SQL 2008 sp1 32-bit
My PC
Microsoft SQL Server Management Studio 10.0.2531.0
Microsoft Analysis Services Client Tools ...
gv
|
08-31-2009 02:21 PM
TheSQLGuru | 3 | 28 |
| | | I've read a few places that the mssqlsystemresource files contain all system
objects and each instance of SQL uses it own unique copy. From what I...
Matt Williamson
|
08-31-2009 01:32 PM
Tibor Karaszi | 1 | 22 |
| | | First off, I apologize if I am posting to the wrong group. Also, I am not
very familiar with work with different file source encoding, so...
Rubens
|
08-31-2009 07:33 AM
Rubens | 2 | 68 |
| | | I am using SQL2000 enterprise manager.
I have linked a text file to the sql server.
Text file always contain 19 digit numaricals.
When I open the...
Madiya
|
08-31-2009 02:56 AM
Madiya | 0 | 24 |
| | | I usually use the logic below to separate out a 3 letter course prefix
and match it to another table. So for example MP.Course_Prefix might
be ENG...
Janet
|
08-30-2009 01:32 PM
John Bell | 1 | 41 |
| | | Is there away to determine the last time the guest account was used on a SQL
Server 2005 database server?
Thanks,
Joe K.
|
08-30-2009 10:10 AM
Erland Sommarskog | 3 | 29 |
| | | I have a SQL Server 2008 database server that was set up by another
individual several months. My windows user account that I log into the
server is...
Joe K.
|
08-30-2009 02:29 AM
Uri Dimant | 2 | 49 |
| | | Hi Folks,
I've just posted up SQL Down Under show 44 with Simon Sabin discussing SQL
Server full text indexing along with some thoughts on learning...
Greg Low \(MVP\)
|
08-30-2009 01:53 AM
Greg Low \(MVP\) | 0 | 25 |
| | | Hello all,
I'm banging my head against a brick wall again.
How would I do the following. If my data is
From To
1 2
2 3
3 4
Jon
|
08-29-2009 09:39 PM
Plamen Ratchev | 5 | 31 |
