Viewing 15 posts - 41,116 through 41,130 (of 49,571 total)
What's the exact error that you're getting?
Turn traceflag 1204 on and the deadlock detector will write a deadlock graph into the error logwhenever it finds the deadlock. That graph will...
February 11, 2009 at 6:56 am
The MERGE statement is used to merge two tables together so that the destination looks like the source.
Are these inserts, updates and deletes coming from a different table? If not,...
February 11, 2009 at 6:45 am
Krishna (2/11/2009)
Partition could be benefited if the table is queried heavily for performance reasons
If can, but the partition function must be chosen very carefully, considering how the table will...
February 11, 2009 at 6:43 am
karthikeyan (2/11/2009)
I want to know the lock count held by a procedure.
Why?
February 11, 2009 at 5:05 am
Krishna (2/11/2009)
Set the DB on single user mode :alter database msdb set multi_user with rollback immediate
Don't you mean set single_user with rollback immediate
February 11, 2009 at 5:00 am
How many rows are those deletes going to affect?
You're running that in a transaction, but there's no error handling at all. The commit is always going to fire, regardless of...
February 11, 2009 at 4:57 am
I think you may have to contact Customer support on this one.
February 11, 2009 at 4:53 am
Eswin (2/11/2009)
can you please tell me more on statistics and how to use it for improving performance.
http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/
February 11, 2009 at 4:11 am
If you're really feeling brave, open the mdf in a hex editor and look for the version stamp in the database header page. You're on your own for figuring out...
February 11, 2009 at 4:09 am
Andrew Reilly (2/11/2009)
Is it me or are these posts getting random ?
I've been noticing the same kinda thing. There's really weird stuff getting asked at the moment.
February 11, 2009 at 4:05 am
tendayit (2/10/2009)
What is the limit on the number of records sql 2005 table accommodate?
How many rows can you fit in 500 000 terabytes?
February 11, 2009 at 4:02 am
Can you post the full error message please. Also check the SQL errorlog and the SQL Agent errorlog and see if there's anything more?
February 11, 2009 at 4:01 am
What showed 4 logical reads?
set statistics io on
go
select * from t where id<='00001'
Results:
Table 't'. Scan count 1, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0,...
February 11, 2009 at 4:00 am
jabba (2/11/2009)
This was run at 2 in the morning where database activity should be minimal and no other jobs are being run.
Was SQL Agent running? If so, that's what had...
February 11, 2009 at 3:36 am
Viewing 15 posts - 41,116 through 41,130 (of 49,571 total)