Viewing 15 posts - 17,626 through 17,640 (of 22,219 total)
It could be two things causing the slow down, since your views are calling views, the resolution of all those database objects is going to slow things down, as you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 23, 2009 at 6:22 am
Since the code is unusable, I don't see the point of keeping it intact. Comment it out. That will leave it in place if you really must.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 23, 2009 at 6:17 am
Yeah, a pretty standard solution for avoiding NULL values.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 23, 2009 at 6:16 am
The thing is, the query window in SSMS is for manual entry, not automation. It's unlikely they'll automate it when MS is already providing sqlcmd.exe and PowerShell scripts (another option)....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 23, 2009 at 5:52 am
Actually you can register on the last day of the conference if you want to. I don't know why you would, but it's possible.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 23, 2009 at 5:17 am
If the data is being pulled from a covering non-clustered index, absolutely. I'm not so sure it would happen during a key lookup.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 23, 2009 at 5:14 am
Glad I could be at all useful. I'll post anything I find and I'm running up a blog post about this too.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2009 at 9:52 am
...and that's when the fight started...
😀
Yeah, that alone is going to cause you performance issues. SQL Server is going to have a hard time resolving everything and optimizing the queries...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2009 at 9:23 am
Whoops. Hold on a second. These are all views. We're dealing with nested views right? Ah, that adds a pretty severe level of complexity. It's resolving all the objects on...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2009 at 8:47 am
Well, the optimizer is going through a binding process on the query. It has to resolve everything involved before it begins the process of optimization. I suspect that's the step...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2009 at 8:44 am
Using sqlcmd would be the 2005ie way to do it. Same for 2008.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2009 at 7:43 am
I'm sorry, "first paper"? Do you mean what do you read to get started? Personally I'd suggest you read Craig Mullin's "Database Administration" for a thorough overview of the job....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2009 at 4:45 am
I'm not aware of a calculation for determining this. Not only is it dependent on the IO of the system, but it's also going to depend on how much activity...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2009 at 4:31 am
If you're creating a table, there should be a toolbar visible at the top of the screen that includes a button called "Manage Indexes and Keys." It shows a little...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2009 at 4:29 am
In addition to the suggestions above, it's worth noting that SQL Server 2008 offers Change Data Capture, another way to monitor what was changed in the data.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2009 at 4:21 am
Viewing 15 posts - 17,626 through 17,640 (of 22,219 total)