Viewing 15 posts - 37,666 through 37,680 (of 49,566 total)
I thought that anyway.
July 14, 2009 at 12:34 pm
Don't use the remove unused space option. Go into the maintenance plan designer and remove that task.
July 14, 2009 at 12:34 pm
Grant Fritchey (7/14/2009)
No kaboom.
No boom today. Boom tomorrow. There's always a boom tomorrow.
July 14, 2009 at 12:25 pm
Sherri Barkley (7/14/2009)
When I run 'select * from sysobjects where id in (540225842, 540357684)' it returns no records. The same is true if I 'select object_name(540357684)' and 'select object_name(540225842)'.
In...
July 14, 2009 at 11:57 am
Don't run the 'remove unused space' task. If you run that after rebuilding indexes, it'll result in worse fragmentation than before the rebuild. No reason to shrink a database.
July 14, 2009 at 11:52 am
Jeff Moden (7/14/2009)
Jack Corbett (7/14/2009)
Was Jeff referring to the Order By in the ROW_NUMBER() function?Yes.
Ok, misunderstood you earlier. Are you suggesting adding a second temp table, one to store the...
July 14, 2009 at 11:38 am
Jeff Moden (7/14/2009)
Building the clustered index afterwards does cut down on page splits if the inserts are in no particular order.
But on a single statement insert the rows...
July 14, 2009 at 11:25 am
Krasavita (7/14/2009)
I didn't find any information about Torn Page Protection
http://msdn.microsoft.com/en-us/library/aa933082(SQL.80).aspx
I need to know why my db is set to true in status of sysdatabases and why my other db is...
July 14, 2009 at 11:17 am
If you're having this many performance problems with a procedure, I would suggest you consider getting a specialist in to help you, especially if you're not good at tuning. They...
July 14, 2009 at 10:54 am
That's only if a query is waiting for memory. Further quoting from Books Online.
In Microsoft SQL Server, memory-intensive queries (such as those involving sorting and hashing) are queued when there...
July 14, 2009 at 10:51 am
Mel Harbour (7/14/2009)
Chris,When I tried both options, there wasn't actually much difference in the performance of the two.
Thing it, it may give us the option to tweak indexes better. With...
July 14, 2009 at 10:47 am
Christopher Stobbs (7/14/2009)
but creating the clustered Index on #TopScores after the actual insert?Would this help at all?
If the cluster goes on after the insert then first SQL has to insert...
July 14, 2009 at 10:23 am
I personally would not recommend a repair on MSDB.
http://www.sqlskills.com/BLOGS/PAUL/post/Is-running-repair-on-msdb-safe.aspx
If you've got a clean backup, restore from it. Before you do so, script out all your jobs and alerts. The...
July 14, 2009 at 10:17 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic752826-338-1.aspx
July 14, 2009 at 10:14 am
RBarryYoung (7/14/2009)
Paul White (7/14/2009)
Yep. Just couldn't be bothered...I'd gone to the trouble of wrapping it inand thought that would be good enough...seems notHmmm,
should work?
It works...
July 14, 2009 at 9:42 am
Viewing 15 posts - 37,666 through 37,680 (of 49,566 total)