Viewing 15 posts - 40,261 through 40,275 (of 49,552 total)
Make sure you read this one too. http://www.sqlskills.com/BLOGS/KIMBERLY/post/Database-Maintenance-Best-Practices-Part-I-e28093-clarifying-ambiguous-recommendations-for-Sharepoint.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
March 19, 2009 at 10:20 am
Jack Corbett (3/19/2009)
If you mean something like this:
Update table
Set columnA = Sum(columnB)
Group By
columnC
Then No.
However, if you use the UPDATE.....
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
March 19, 2009 at 10:15 am
Krishna (3/19/2009)
GilaMonster (3/19/2009)
My criteria for clustered indexes - narrow, unchanging, unique, ever-increasing.That's a good one Gail. Explains everything just in 4 words.:-D
I can't take credit. Kimberly Tripp[/url]'s been preaching...
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
March 19, 2009 at 10:13 am
shnex (3/19/2009)
So, my question was: puting the clustered index on column2(bigint) is beter than on column1(guid)?
Maybe. Can you give us the table's actual schema and some of the more common...
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
March 19, 2009 at 9:58 am
Tim Walker (3/19/2009)
Gail, Grant, can I ask you why you think a GUID is automatically a bad choice.
Experience.
I've had a table with a guid cluster that could go from...
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
March 19, 2009 at 9:55 am
shnex (3/19/2009)
only this way I will have acces to the log information.
Why do you want to access the log information?
I said that shrinking seems better because the information from 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
March 19, 2009 at 9:54 am
I'd recommend the self-paced training kits, you should be able to buy from Amazon.
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
March 19, 2009 at 1:18 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic679161-391-1.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
March 19, 2009 at 1:08 am
Give this a try (no promises)
SELECT memberID
FROM memberResponses
WHERE responseID IN (1,3,4,6,8,15)
GROUP BY memberID
ORDER BY COUNT(*) DESC
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
March 18, 2009 at 2:56 pm
Ouch. The old 'One True Table' design. I'm surprised you can get anything out of that in a reasonable time, even with nolock.
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
March 18, 2009 at 2:38 pm
Florian Reischl (3/18/2009)
It's not nice, but I see no other possibility.
a
Optimise queries, tune indexes?
Seriously, in most cases doing those two removed the 'need' for nolock. Or are you running...
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
March 18, 2009 at 2:12 pm
dallas13 (3/18/2009)
i have created a policy on sql 2008 now i need to apply thatpolicy on sql 2005 server. is that possible?
No. Policies are a 2008 feature.
You can evaluate...
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
March 18, 2009 at 2:12 pm
JMSM (3/18/2009)
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
March 18, 2009 at 2:03 pm
jfoster (3/18/2009)
For those using pre-SQL 2008 servers, this would still be in the toolbox if needed and should be used with their scope in mind.
I'd say no, even pre-2008, either...
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
March 18, 2009 at 1:51 pm
Matt (3/18/2009)
I've found the perfect tool to use on the server to help me out, it's called a sledge hammer
😀 There's a reason I have a hammer in my computer...
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
March 18, 2009 at 1:46 pm
Viewing 15 posts - 40,261 through 40,275 (of 49,552 total)