you could read "SUM(CRAMNT) AS CRAMNT FROM myTbl" into a variable and then just select the variable instead of running sum for each row.

have you tried running it through DTA?

http://msdn.microsoft.com/en-us/library/ms162812.aspx

FYI, don't implement everything it recommends look on the reports for new indexes that have the most bang.

I actually didn't the systems admins / AD admins came back with an "oops sorry about that".

I know it's an old topic, but you can try and do it the other way. Use JDBC from what you were linking to, and query SQL from the...

Adam Machanic (12/19/2012)

That's a rather specific pronouncement, especially when you don't know anything about the workload in question. What's your...

It looks like you have got a lot of things going on performance wise. CXPACKET waits (parallelism) should be addressed if > 5%. The IO waiting more that...

I hear what you're saying, but I use this script on a regular basis to identify the issue. I do this by reviewing the output and if I see...

That was actually the intent of the original script. You should try that one again.

GL,

Jon

I wonder if something like this would work for you:

Use [Database]

BEGIN

DECLARE @count int

SET @count = 1000

while exists (SELECT top 1 [col] FROM [Table] where [whatever...]

BEGIN TRANSACTION

DELETE FROM [Table]

WHERE [col]...

Just setting up Vendor software that has the requirement. SharePoint uses a non-default collation as well.

http://msdn.microsoft.com/en-us/library/ms188046.aspx

http://www.sqlservercentral.com/Forums/Topic647177-146-1.aspx#bm647387

Did you ever figure this out? I'm looking at the same thing and it looks like you need to select the Windows collation designator and sort order radio button,...

I suppose I should add System Center Operations Manager with System Center Monitoring pack for SQL Server to the list.

Bouncing the box worked for me. I believe it had something to do with SPN registration.

Sorry for spamming your post. I've upgraded all db's to compatibility level 100, enabled optimize for ad hoc workloads, restarted SQL Services and I still have a ton of...

Looks like the compatibility level is 90, so that's my problem...