Viewing 15 posts - 1,231 through 1,245 (of 18,926 total)
GSquared (11/14/2011)
Tom Brown (11/14/2011)
Seems like SNAPSHOT Read committed is one way to go. However if I investigate this and find...
November 14, 2011 at 9:52 am
GSquared (11/14/2011)
Sean Lange (11/14/2011)
Ninja's_RGR'us (11/14/2011)
It's only been posted 3 times... not sure it's enough ;-).Yeah apparently we were all three typing at the same time. Kind of scary!!
Not as scary...
November 14, 2011 at 9:48 am
GilaMonster (11/14/2011)
To explain... I have a browser plugin that stores snippets of test. So common replies aren't typed, they're just auto-inserted.
Screenshot?
November 14, 2011 at 9:45 am
ben.brugman (11/14/2011)
Ninja's_RGR'us (11/14/2011)
Plan B => http://www.red-gate.com/products/dba/sql-virtual-restore/
Thanks for plan B.
Found a similar plan C:
Plan B => http://www.idera.com/Products/SQL-toolbox/SQL-virtual-database//
Ninja's_RGR'us (11/14/2011)
November 14, 2011 at 9:39 am
ERIC CRUDELI (11/14/2011)
I know but the only thing I need is if it's necessary to perform again a CHECKBD WITH PURITY after moving databases.
Only if you're coming from sql 2000.
Once...
November 14, 2011 at 9:38 am
petervdkerk (11/14/2011)
I made...
November 14, 2011 at 9:35 am
JakeSA (11/14/2011)
p.s. Nothing deletes inactive log records from the log. Ever.
Hmmm, then how are the spaces freed up in the log file? Or maybe you mean that inactive logs...
November 14, 2011 at 9:34 am
GilaMonster (11/14/2011)
Sean Lange (11/14/2011)
Funny how we all post the same link and type pretty much the same thing on this topic 2-3 every week.Type?
He doesn't have his mind reader yet....
November 14, 2011 at 9:33 am
What does this return?
/*
Cost threshold for parallelism (CXPACKET) http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/01/19/tuning-cost-threshold-of-parallelism-from-the-plan-cache.aspx
Paul White: Understanding parallelism http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
Microsoft White Paper on waits http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc
Next query by Paul Randal http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx
*/
WITH Waits AS
(SELECT
...
November 14, 2011 at 9:32 am
Sean Lange (11/14/2011)
Ninja's_RGR'us (11/14/2011)
Sean Lange (11/14/2011)
Ninja's_RGR'us (11/14/2011)
It's only been posted 3 times... not sure it's enough ;-).Yeah apparently we were all three typing at the same time. Kind of scary!!
I...
November 14, 2011 at 9:29 am
feersum_endjinn (11/14/2011)
Didn't realise 1 table and 2 views = 1 trillion tables. Looks like I'll just have to stick with what I have.
Just imaging what's happening.
You don't have 1 view...
November 14, 2011 at 9:27 am
Sean Lange (11/14/2011)
Ninja's_RGR'us (11/14/2011)
It's only been posted 3 times... not sure it's enough ;-).Yeah apparently we were all three typing at the same time. Kind of scary!!
I think I've seen...
November 14, 2011 at 9:25 am
Bouben (11/14/2011)
Ninja's_RGR'us (11/14/2011)
2011 - 1 - January
2011 - 2 - February
2011 - 3 - March
If you sort by column 1 & 2, the sequence will be correct in...
November 14, 2011 at 9:20 am
It's only been posted 3 times... not sure it's enough ;-).
November 14, 2011 at 9:19 am
GSquared (11/14/2011)
It is, indeed, a "conditional...
November 14, 2011 at 9:18 am
Viewing 15 posts - 1,231 through 1,245 (of 18,926 total)