Viewing 15 posts - 12,421 through 12,435 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2013 at 9:15 am
wolfkillj (7/9/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2013 at 7:53 am
Please note: 6 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2013 at 7:34 am
Please note: 3 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2013 at 5:04 am
DBANewbie (7/9/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2013 at 4:36 am
btw, same things apply to nonclustered indexes, this isn't something special to a clustered index.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2013 at 3:50 am
Please note: 5 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2013 at 3:22 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2013 at 3:21 am
Viewing 15 posts - 12,421 through 12,435 (of 49,552 total)