Viewing 15 posts - 35,791 through 35,805 (of 49,558 total)
Rookee DBA (11/17/2009)
Gentlemen, thanks alot for your comments.
Only one gentleman here, and that's Steve.
Do you mind sharing the circumstances in which both the index will be required?
Don't worry about...
November 17, 2009 at 8:24 am
Processors can only be 'affinitised' per instance. What I would suggest is that you 'encourage' the developer to optimise his queries. Large table does not automatically mean high processor usage....
November 17, 2009 at 8:23 am
DBCC SQLPERF(LogSpace)?
Checkpoints don't run on a schedule, frequency depends on activity.
November 17, 2009 at 8:06 am
Run DBCC OPENTRAN, post the results
November 17, 2009 at 7:41 am
Elliott W (11/17/2009)
I got the parameter sniffing vibe off that article..
It's not so much parameter sniffing. It's that there's no single optimal execution plan for that kind of...
November 17, 2009 at 7:17 am
kwiggans (11/17/2009)
Then it gives a scenario of a large table with a covering clustered index vs a 4 byte clustered index to compare the space savings.
Clustered indexes are always...
November 17, 2009 at 6:28 am
Generally it has to do with the size and data type of the pk and whether or not the cluster would be better elsewhere. This may help: http://www.sqlservercentral.com/articles/Indexing/68563/
November 17, 2009 at 6:26 am
These may help.
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
Part 3 will be published tomorrow
November 17, 2009 at 6:25 am
It's not the fact that the column is an identity that makes the second index a 'mistake', it's the fact that there's both a clustered index and a nonclustered index...
November 17, 2009 at 6:25 am
That can happen if a previous snapshot wasn't dropped successfully. Don't know why, just have heard about it. Can you schedule a restart of SQL soon?
November 17, 2009 at 4:19 am
Separate databases for the 3 devs, or a single database with just the A, B, C schemas (and be careful not to mess up the other's work)
November 17, 2009 at 4:18 am
mjarsaniya (11/17/2009)
November 17, 2009 at 4:16 am
You shouldn't be testing on live anyway. That's what a test server is there for.
Run the queries against the DB. Time them. Create one of the indexes. Run the...
November 17, 2009 at 4:14 am
No. How can it?
sp_updatestats, if run without parameters, runs UPDATE STATISTICS Schema.Table StatsName if the stats set is set to auto update and UPDATE STATISTICS Schema.Table StatsName NORECOMPUTE if it's...
November 17, 2009 at 4:09 am
tarunsoodrnd (11/17/2009)
November 17, 2009 at 3:59 am
Viewing 15 posts - 35,791 through 35,805 (of 49,558 total)