Viewing 15 posts - 35,296 through 35,310 (of 49,552 total)
amoericke (12/14/2009)
December 15, 2009 at 2:29 am
Partially. Pre-SQL 2008 a heap can't be rebuilt except by creating a cluster on it. A heap can still have the 10% avg usage of pages if the rows deleted...
December 15, 2009 at 2:13 am
I don't think this is a stats problem. If it was, the proc would have run slow everywhere. Slow from some places and fast from others is not a symptom...
December 15, 2009 at 2:08 am
Eswin (12/14/2009)
The server didn't go offline also was not restarted i checked the logs.
Then there was some kind of network glitch between the client and server. The error is a...
December 15, 2009 at 2:04 am
Why the subquery at all?
UPDATE SomeTable SET Column = TextColumn
FROM SomeTable INNER JOIN OtherTable ON <join condition here>
WHERE OtherID = @ID
AND WHERE SomeID = 1 --...
December 14, 2009 at 2:54 pm
myplace2sell (12/14/2009)
Now getting to the hash join in this query...is it avoidable?
Should you be trying to avoid it with the row counts that you mentioned?
http://sqlinthewild.co.za/index.php/2009/11/24/the-most-optimal-join-type/
If the row counts were...
December 14, 2009 at 2:51 pm
Don't understand your question. It's a scalar function that takes 3 parameters and returns a value.
December 14, 2009 at 1:08 pm
Paste it into a management studio query window and do a syntax check. That should give you a message saying what's wrong and on what line.
December 14, 2009 at 12:11 pm
bkeahl (12/14/2009)
December 14, 2009 at 11:54 am
Consequences of turning auto-shrink off - improved performance. Read the following, and then read the two blog posts that it links to (at the bottom)
http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
December 14, 2009 at 11:52 am
homebrew01 (12/14/2009)
Would rebuilding actually increase space in the data files ?
It may well do. Say those deletes have been spread out over the table. You may have large portions of...
December 14, 2009 at 11:51 am
Firstly you shouldn't be using select *, no matter the number of columns. You're risking the app possibly breaking if a column is added in the future. Just specify...
December 14, 2009 at 9:42 am
Have you rebuilt all the indexes on the tables that rows were deleted from?
December 14, 2009 at 9:32 am
one-1016367 (12/14/2009)
December 14, 2009 at 9:31 am
sql_lock (12/14/2009)
Also make sure that your stats job is after the index job.. Had company that ran the stats before..
Doesn't matter if it's before or after, unless it's doing a...
December 14, 2009 at 9:27 am
Viewing 15 posts - 35,296 through 35,310 (of 49,552 total)