Viewing 15 posts - 9,736 through 9,750 (of 22,213 total)
SQLRNNR (6/17/2013)
SQLRNNR (6/13/2013)
You guys have a "widget" on your blog that allows the display of certain icons or badges (e.g....
June 18, 2013 at 1:16 am
Brandie Tarvin (6/17/2013)
Steve Jones - SSC Editor (6/17/2013)
This week is the first SQL in the City of 2013. Anyone coming?
In Denver, I take it?
No. Can't travel that far on this...
June 17, 2013 at 9:17 am
Lynn Pettis (6/14/2013)
I am officially going to Afghanistan!
I leave for IRDO at Camp Atterbury in Indiana on Sunday, June 23rd. All should go well there with me leaving there...
June 17, 2013 at 2:07 am
It still a linked server in both cases? You should always get the remote scan if it's a linked server, so I'm a little confused by what you're telling me.
June 14, 2013 at 9:10 am
Off the top of my head, no.
It sounds like the optimizer, because the function, assumed it needed to bring back all the data in order to filter it down. But...
June 14, 2013 at 5:42 am
Still pretty much back to where I was. You'll note that one is moving all the data and the other is not. I suspect that the functions on the data...
June 14, 2013 at 4:23 am
Remote scan is pretty much what it says, a scan against a remote machine through linked servers. I didn't talk about that in the book. Maybe something I should add.
So,...
June 14, 2013 at 3:26 am
I'd suggest going to the moment in time when that occurred and look at the top 10 queries. You may have to bounce around the time a little bit to...
June 14, 2013 at 2:50 am
I'm with Ed. The Client Statistics are really only useful if you want to measure round-trip time, from the client to the server and back to the client. They're just...
June 14, 2013 at 2:46 am
Short answer, yeah, the files will be available. Longer answer, go here to get Microsoft's word on how this works.
June 14, 2013 at 2:43 am
Yeah, I'm with everyone else. Really sounds like query tuning needs to happen immediately. Sometimes throwing hardware at a problem doesn't make it better. In addition to Gail's articles, check...
June 14, 2013 at 2:41 am
You don't need to see the actual plan to see if it's doing a parallel execution. You can pull the plan out of cache for the query, while it's running....
June 14, 2013 at 2:39 am
Since you're on SQL Server 2008, you don't actually have to rely on the traceflags any more. The system_health extended event session will record deadlock graphs that will allow you...
June 14, 2013 at 2:34 am
You might try using a derived table and getting TOP 1 with an ORDER BY to get the latest version instead of the > operator. Something like the code I...
June 14, 2013 at 2:32 am
SQLRNNR (6/13/2013)
You guys have a "widget" on your blog that allows the display of certain icons or badges (e.g. MVP...
June 14, 2013 at 1:13 am
Viewing 15 posts - 9,736 through 9,750 (of 22,213 total)