Viewing 15 posts - 12,946 through 12,960 (of 22,214 total)
It really depends on the query, the structure of the table, the indexes on the table, the number of users on the system and the queries they're running, memory and...
March 23, 2011 at 11:14 am
Depending on the query, the optimizer is blazingly fast. But, it's still not zero, I get it. Usually when you hit a limit based on how a tool behaves you...
March 23, 2011 at 10:26 am
No, you can't really avoid the compile process. If you try plan forcing you're at least guaranteed which plan you get.
March 23, 2011 at 9:44 am
Not without execution plans to compare. It's just too hard to know what's going on since we're not sitting there.
March 23, 2011 at 9:24 am
Jack Corbett (3/23/2011)
Grant Fritchey (3/23/2011)
SQLkiwi (3/23/2011)
Grant Fritchey (3/23/2011)
March 23, 2011 at 8:36 am
I still think something occurred during the restore. It looks like litespeed was functioning and the server had access, but something happened. Get to the full error log and I...
March 23, 2011 at 8:35 am
Yeah, I'd say it sounds fairly reasonable. As long as the Posh script isn't adding to the overhead on your systems. You can just use perfmon to spit out the...
March 23, 2011 at 8:10 am
That doesn't look like a complete error message. Since the error is from LiteSpeed, I'd check the log there and see what you have.
March 23, 2011 at 8:07 am
Jeff Moden (3/23/2011)
Grant Fritchey (3/23/2011)
...duck tour should be a blast.Heh... not sure duck hunting season is open right now. 😛
The last time I spelled it properly, DUKW, people were confused.
March 23, 2011 at 7:35 am
SQLkiwi (3/23/2011)
Grant Fritchey (3/23/2011)
March 23, 2011 at 7:13 am
And if you toss in something like multi-statement table valued functions the cost can be shown as zero when it is in fact extremely high.
Costs are indicators, but they are...
March 23, 2011 at 5:55 am
Well, you can try plan forcing. that allows you to take a valid plan and make the engine use it when you run the query. It's not executing the plan,...
March 23, 2011 at 5:53 am
As someone who had to look at tons and tons of resumes for hiring DBAs, I look for experience, not certification or formal education. I care about what you know...
March 23, 2011 at 5:48 am
There's always the old-fashioned way. Create the database uncompressed and compressed side-by-side and compare. That's what I did when I was first checking it out. But you know, the storage...
March 23, 2011 at 5:45 am
SQLkiwi (3/22/2011)
David Benoit (3/22/2011)
Um - but now the event is full.
Just checked with the organizers and SQLSat71 is not full per se - at least the registration cap hasn't been...
March 23, 2011 at 5:41 am
Viewing 15 posts - 12,946 through 12,960 (of 22,214 total)