Viewing 15 posts - 17,056 through 17,070 (of 22,214 total)
5 recompiles for 1000 batches is pretty good. 50% compile rate on your batches suggests that you've got lots of ad hoc queries. If it's a reporting system, that ratio...
June 30, 2009 at 9:37 am
For only 5, I'd say roll your own. You get most of what you need from Perfmon & server-side traces. Spending money on a tool for so few servers seems...
June 30, 2009 at 9:34 am
mjarsaniya (6/30/2009)
you are beginner or expert , first do best try to get answer from BOL and...
June 30, 2009 at 8:14 am
There really is no way to accurately assess how long a query will take to run. You can have a single row update that should run in about 5ms that...
June 30, 2009 at 8:07 am
Pretty sure that's from an encrypted database Roy. I posted on it.
June 30, 2009 at 7:52 am
Sounds like the database was encrypted. It wants the location of the key files and you'll need the passwords that unlock them.
June 30, 2009 at 7:52 am
All those functions on the columns in the JOINS are going to kill performance. They should have in 2000 as well. Can you post the execution plan?
June 30, 2009 at 7:39 am
Two options, identify indexes that are not used or that are too big and eliminate them, as per the previous post. Another option is to upgrade to 2008 and use...
June 30, 2009 at 7:34 am
There is also a lite version of AdventureWorks that includes simpler structures and less data, so that's another alternative (not better, just different) to Northwind. There's also an AdventureWorksDW that...
June 30, 2009 at 7:32 am
GilaMonster (6/30/2009)
Ok, those worked properly.This is seriously weird
It's a secret admirer.
June 30, 2009 at 6:28 am
mazzz (6/30/2009)
I remember reading about the cost figures being estimates, even in the *actual* execution plan - what would one look at instead, to figure out which bit of...
June 30, 2009 at 6:08 am
smsam1 (6/29/2009)
actually what i meant is this, you go through set of values to find a particular value inside that set is comparison,
That would be a WHERE clause within a...
June 30, 2009 at 6:02 am
Yes, it was taken down pending an investigation of violation of the DMCA. Here's more detail [/url]for those that are interested.
June 29, 2009 at 12:13 pm
Passthrough or not, when you send a query up to SQL Server, it gets converted into TSQL syntax because that's the only syntax that SQL Server understands. Although I thought...
June 29, 2009 at 12:03 pm
The question is, how much money do you want to spend. The two tools that I use to do this are System Center Operations Manager from Microsoft and SQL Diagnostic...
June 29, 2009 at 11:59 am
Viewing 15 posts - 17,056 through 17,070 (of 22,214 total)