Viewing 15 posts - 12,421 through 12,435 (of 49,557 total)
sql_sabis (7/9/2013)
Also, very strangely, I don't see a Tables folder under my master database, unlike other regular databases.
Right click the master database -> refresh. Object Explorer does not...
July 9, 2013 at 12:41 pm
sql_sabis (7/9/2013)
Also, why does SQL Server create everything in the master DB given my script? Please help. Thanks a lot!
Probably because you didn't have a USE MyApplicationDb between the...
July 9, 2013 at 12:18 pm
Deleted data is not recorded in the default trace.
You need triggers, change data capture, change tracking or SQL Audit set up before the deletes occurred to have any record of...
July 9, 2013 at 10:03 am
paul.knibbs (7/9/2013)
GilaMonster (7/8/2013)
It will use the first then the second then the first again then the second again, etc. The log files will only grow if both are full.
Just curious--will...
July 9, 2013 at 9:15 am
wolfkillj (7/9/2013)
July 9, 2013 at 9:03 am
dwain.c (7/8/2013)
In that case, without an ORDER BY shouldn't the rows be returned in the order established by the clustered INDEX?
No. Without an order by there is no guarantee of...
July 9, 2013 at 7:53 am
Please note: 6 year old thread.
July 9, 2013 at 7:34 am
Never said it would. Hopefully however it will prevent people wasting time trying to solve a problem that's been solved for 5 years (as I did this morning before I...
July 9, 2013 at 6:29 am
psingla (7/9/2013)
I think instead of clustered index he should have used clustered table to make it clear..
There's no such thing as a clustered table. There are heaps and tables with...
July 9, 2013 at 5:04 am
DBANewbie (7/9/2013)
July 9, 2013 at 4:36 am
btw, same things apply to nonclustered indexes, this isn't something special to a clustered index.
July 9, 2013 at 4:11 am
psingla (7/9/2013)
If this is special case of clustered index scan then that means clustered index scan and index order scan both should be the answer...
No.
It's asking for the specific name...
July 9, 2013 at 3:50 am
The key there is that the question is asking about a specific type of clustered index scan, specifically one that runs in the logical order of the index. Hence the...
July 9, 2013 at 3:21 am
Viewing 15 posts - 12,421 through 12,435 (of 49,557 total)