Viewing 15 posts - 48,721 through 48,735 (of 49,563 total)
a) recompiles (MANY more than you might suspect, since IIRC for every 6 rows you insert/modify, the code referencing the temp table will be recompiled). This gets expensive.
Plus every time...
May 3, 2007 at 7:13 am
It's still getting updated with each insert and you could be see a lot of thrash on the system from it reorganizing to ensure that it's at 100%.
Fill factor...
May 3, 2007 at 2:20 am
Processes blocking themselves is not a problem. It happens when a process parallels and then has to wait for one of the spawned threads to merge the threads.
Regarding the deadlock,...
May 2, 2007 at 8:07 am
Try this
SELECT ...
From ScoutingReport as sr
Join Person as p on p.Id = sr.ScoutedPersonID
April 25, 2007 at 2:12 am
SELECT * FROM tbl WHERE col not like 'ABC%' and COL not like 'DEF%'
April 24, 2007 at 2:19 am
Restore a backup, restore the tran logs and stop just before the 'drop'
Then you can find whoever wrote that code and give then a good wack upside the head for...
April 24, 2007 at 12:17 am
It's highly unlikely to see much of a change in speed for a data type change.
If you haven't rebuilt the clustered index, then the data will still occupy the...
April 23, 2007 at 12:50 am
Yes, but will either need a cursor or a hard-coded limit on how deep the hierarchy will go.
Which is your preference?
April 19, 2007 at 11:08 pm
Got connection pooling in place? That would account for the remaining connections. Reusing an open connection is faster than opening a new.
As for the slow down, there could be hundreds...
April 19, 2007 at 10:55 pm
A connection will stay open until it's explicitly closed. SQL doesn't close them automatically. If they're awaiting command, then they are idle.
There's a column in sysprocesses waittime and another lastwaittype....
April 19, 2007 at 8:36 am
Are you using SQL 2000 or 2005? It's very easy on 2005 but on 2000 it can be quite tricky.
How deep can the hierarchy go?
April 19, 2007 at 7:03 am
Could you post your table structure and some sample data please? It's a little difficult to write a working query without them.
April 19, 2007 at 5:26 am
What's the wait time on those writelog waits?
Is the log on a dedicated drive?
April 19, 2007 at 2:51 am
A million rows is very small. Nonclustered indexes should complete in under 5 min.
While the index is being built, the table will be read-only, but there's no need to...
April 19, 2007 at 2:31 am
The disappearing essages is related to session timeout. I've had similar issues on other forums too. I normally just Ctrl-A, Ctrl-C before hitting post.
April 18, 2007 at 3:09 am
Viewing 15 posts - 48,721 through 48,735 (of 49,563 total)