Viewing 15 posts - 10,861 through 10,875 (of 22,213 total)
That's very abnormal. Were you able to capture the execution plans for the queries so we can try to compare them to each other? This is not something I'm used...
May 23, 2012 at 5:00 am
The necessary permissions are documented right here on the Red Gate web site.
May 22, 2012 at 6:20 am
Ditto. Or, it might be accessed by looking at the default ANSI settings for the server.
May 22, 2012 at 6:17 am
MadTester (5/22/2012)
Currently I'm thinking of changing the job to do a reorganise daily based on fragmentation and an...
May 22, 2012 at 6:16 am
The ANSI settings change how the optimizer creates execution plans. So one connection with "concat null yields null" turned on can create a different execution plan from one that has...
May 22, 2012 at 4:46 am
The only way to be 100% sure is to restore the database. I wrote this short article [/url]laying out the various things you can do and what they do for...
May 22, 2012 at 4:18 am
In theory, the same stored proc called from any connection should run roughly the same speed, regardless of who called it. But... there are connection settings that will cause different...
May 22, 2012 at 4:12 am
By the way, if you're getting RID lookups it means that you're dealing with hash tables, tables without a clustered index. Unless you have a very thorough set of tests...
May 22, 2012 at 4:09 am
From the sounds of things, you could just leave stuff as is. It doesn't sound like the data is so volatile that your stats are getting updated.
I don't think doing...
May 22, 2012 at 4:07 am
Nope. I've done multiple installs with no issues like this. It sounds like you had a problem during the installation or you found a bug.
May 21, 2012 at 8:49 am
Gullimeel (5/21/2012)
May 21, 2012 at 6:30 am
SQLRNNR (5/18/2012)
In Boston now getting ready for SQL Sat 142.If you are close by, come check us out.
How did it go? I had a great, if tiring, weekend with the...
May 21, 2012 at 5:30 am
Gullimeel (5/19/2012)
I know who these guys are (I am reading one of Grant's book) and they are in this area much longer than I am but thats not the point...
May 21, 2012 at 5:19 am
You can have SSMS installed on a different machine within the same network and connect to the machine you're interested in. Most of the servers I used to administer did...
May 18, 2012 at 11:34 am
Gullimeel (5/18/2012)
Do not worry I will not create my own sort.
However, the people who queries dm_exec_query_stats to find the costly queries misses this sort cost. Like if you see this...
May 18, 2012 at 8:04 am
Viewing 15 posts - 10,861 through 10,875 (of 22,213 total)