Viewing 15 posts - 40,276 through 40,290 (of 49,571 total)
umar iqbal (3/19/2009)
if you want to clean up tempdb u can schedule this script. it will remove temp tables that are older than 12 hrs.
Did you test out that...
March 19, 2009 at 2:47 pm
All monitoring tools have some impact. You can't check a server's behaviour without using some resources on it.
For what it's worth, I've never had a noticeable performance degradation from using...
March 19, 2009 at 1:57 pm
SQL Trace. Much lighter weight than the Profiler GUI. There's a recent article at Simple Talk that talks about using SQL Trace to find badly-performing queries.
March 19, 2009 at 12:59 pm
kevin77 (3/19/2009)
March 19, 2009 at 12:53 pm
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
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.....
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...
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...
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...
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...
March 19, 2009 at 9:54 am
I'd recommend the self-paced training kits, you should be able to buy from Amazon.
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
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
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.
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...
March 18, 2009 at 2:12 pm
Viewing 15 posts - 40,276 through 40,290 (of 49,571 total)