Viewing 15 posts - 27,766 through 27,780 (of 49,552 total)
Please post query, index definitions and execution plan.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
February 15, 2011 at 2:04 am
Indexes can be very useful on columns that have lots of repeated values. The trick is, nonclustered covering indexes.
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
February 15, 2011 at 2:02 am
Table and index definitions please.
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
February 14, 2011 at 10:53 pm
Two points I'm going to disagree with
Avoid the creation of an index on a column in a table when the data stored in that column has a large number 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
February 14, 2011 at 10:50 pm
tew (2/14/2011)
There must be a glitch with SQL Server Central's notification system... I submitted this post 4 years ago.
Apologies, I didn't check the date. It bubbled to the top because...
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
February 14, 2011 at 2:47 pm
tew (4/17/2007)
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
February 14, 2011 at 1:56 pm
Stefan Krzywicki (2/14/2011)
GilaMonster (2/14/2011)
Grant Fritchey (2/14/2011)
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
February 14, 2011 at 1:21 pm
Grant Fritchey (2/14/2011)
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
February 14, 2011 at 12:57 pm
Ninja's_RGR'us (2/14/2011)
But I'd still run checkdb TODAY on your latest backup.
If that was the only error that the integrity check maintenance task picked up, then there's no need. That task...
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
February 14, 2011 at 11:30 am
Craig Farrell (2/14/2011)
GilaMonster (2/14/2011)
Another promising looking contract cancelled due to lack of @#$$#@$%$ budget!
I'm almost at the point of walking away and going to work in a book store...
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
February 14, 2011 at 11:28 am
Rather run it during a maintenance window. That error's not critical, it doesn't have to be fixed immediately.
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
February 14, 2011 at 11:22 am
$#%$$#%#@#!!!!!!!
Another promising looking contract cancelled due to lack of @#$$#@$%$ budget!
I'm almost at the point of walking away and going to work in a book store for a few...
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
February 14, 2011 at 11:16 am
Evaluation is Enterprise edition.
You could always spend around $60 and get a copy of developer. Full enterprise features, no expiry, licensed only for development.
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
February 14, 2011 at 11:02 am
There's no system table for that. You'll need an undocumented function.
Described here: http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Using-DBCC-PAGE-and-DBCC-IND-to-find-out-if-page-splits-ever-roll-back.aspx
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
February 14, 2011 at 11:00 am
If three times a day backup is adequate and there is no need for point in time recovery, set the database to simple recovery and leave the logs alone.
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
February 14, 2011 at 10:54 am
Viewing 15 posts - 27,766 through 27,780 (of 49,552 total)