Viewing 15 posts - 8,836 through 8,850 (of 22,214 total)
And for the sake of clarity, comparing a "query" to a view is something of a misnomer. They're both queries. A view is nothing but a packaged query. When you...
February 25, 2014 at 8:09 am
And if you don't want to or can't run sp_whoisactive, I would suggest getting familiar with the Dynamic Management Objects and run queries against them rather than using sp_who2. That's...
February 25, 2014 at 8:07 am
Yeah, but it'll hit CPU and memory, not IO.
The question is, are all the queries the same, but varying by some parameter value? If so, then optimize for ad hoc...
February 25, 2014 at 8:06 am
In general, you're going to have a hard time quantifying this precisely. The issue is that you're relying on one of two pieces of information, the login and the application...
February 25, 2014 at 8:02 am
Ow!
Dry? Now way! I love it. Can't get enough. If you want a quick hit on what to look for in plans, I've got a short list here.[/url]
February 25, 2014 at 7:12 am
OldCursor (2/25/2014)
February 25, 2014 at 6:41 am
Nice article.
A couple of notes. You state that the plan is read from right to left. That's not completely true. The logical processing order of the plan is from left...
February 25, 2014 at 6:39 am
That vendor needs to be burned at the stake.
And then we'll scatter the ashes at a cross-roads.
And then sow the ground with salt.
Although, I've seen scarier stuff generated by ORM...
February 25, 2014 at 4:58 am
You have to restore with RECOVERY at the end of the log process too.
Looking at that, are they running a single log backup? Normally you'll see lots of log backups...
February 25, 2014 at 4:55 am
Then you're stuck. You're trying to compare two different data types. SQL Server has to convert them in order to compare them. No choice there. To get index use assured,...
February 25, 2014 at 4:52 am
The one suggestion I can offer to cut the time is to just do a statistics update, not an index rebuild. You actually don't even have to do that. The...
February 25, 2014 at 4:51 am
Those type of questions are intentionally asked by good interviewers to test the depths of your knowledge. The first question is one of my favorites. I want to know what...
February 25, 2014 at 4:47 am
To move only a sub-set of the data you'll have to build a manual process. SSIS is the obvious choice, but you could use straight T-SQL, PowerShell or any other...
February 25, 2014 at 4:43 am
Lynn Pettis (2/25/2014)
Last night home. Start my journey back to Afghanistan Tuesday morning.
Best of luck!
February 25, 2014 at 4:34 am
Just remember that those are suggestions. Don't blindly implement them. Always test them and validate them.
February 25, 2014 at 4:34 am
Viewing 15 posts - 8,836 through 8,850 (of 22,214 total)