Viewing 15 posts - 14,656 through 14,670 (of 49,552 total)
Marius.D (1/23/2013)
For some reason, I thought you need the full space of the table only with ONLINE=ON. It didn't use that much on the test system.
Smaller table on the test...
January 23, 2013 at 11:32 pm
sqldba_newbie (1/23/2013)
January 23, 2013 at 4:07 pm
Creating an index requires at least the size of the index as free space. Plus there's the sort space if you don't have sort in tempDB on. So to create...
January 23, 2013 at 4:03 pm
sqldba_newbie (1/23/2013)
Richard Warr (1/23/2013)
Something like
SELECT CONVERT(VARCHAR(4), R.FCde) AS Flty
FROM Rtns R
WHERE NOT EXISTS ( ...
January 23, 2013 at 1:00 pm
None by default, traceflags are something I evaluate on a case-by-case scenario.
I'm interested to see where MS recommends 1224, since that can be a little risky in terms of lock...
January 23, 2013 at 12:54 pm
sqlfriends (1/23/2013)
if transaction log backup is full for model, either do a transaction log backup or shrink it.
Why do people want to shrink a full log?
If I have a 5...
January 23, 2013 at 11:21 am
Single column nonclustered indexes. Great for when all your queries filter on a single column only. Not great otherwise.
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
Don't have time to look at the deadlock graph right now.
January 23, 2013 at 9:22 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1410624-391-1.aspx
January 23, 2013 at 9:04 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1410624-391-1.aspx
January 23, 2013 at 9:04 am
Interview question? Exam question?
So, how would you start?
January 23, 2013 at 9:03 am
Do not create then drop a clustered index. If you want a heap, live with the extent fragmentation. It's far less damaging than logical fragmentation. If you want to put...
January 23, 2013 at 9:00 am
Viewing 15 posts - 14,656 through 14,670 (of 49,552 total)