Viewing 15 posts - 13,621 through 13,635 (of 22,227 total)
SQLkiwi (1/13/2011)
Grant Fritchey (1/13/2011)
"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
January 13, 2011 at 7:18 am
Koen (da-zero) (1/13/2011)
Grant Fritchey (1/13/2011)
Koen (da-zero) (1/12/2011)
TheSQLGuru (1/12/2011)
I am curious what you mean by "advisor" here. Hopefully you do NOT mean Database Tuning Advisor!! Avoid that like the...
"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
January 13, 2011 at 6:16 am
Koen (da-zero) (1/12/2011)
TheSQLGuru (1/12/2011)
farax_x (1/12/2011)
"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
January 13, 2011 at 6:00 am
Koen (da-zero) (1/12/2011)
siamak.s16 (1/12/2011)
Lets not forget Intellisense 😀I'm not always convinced it is an improvement 🙂
Not when you compare it to Red Gate's SQL Prompt it isn't.
Same thing in Denali,...
"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
January 13, 2011 at 5:58 am
sql_butterfly (1/13/2011)
Any alternative ways to...
"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
January 13, 2011 at 5:57 am
SQLkiwi (1/12/2011)
Grant Fritchey (1/12/2011)
"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
January 13, 2011 at 5:51 am
WayneS (1/12/2011)
Stefan Krzywicki (1/12/2011)
I'm just outside Boston, we're certainly snowed in here.How much did you get?
Grant / Adam - how much did you'll get?
I don't know what the official number...
"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
January 13, 2011 at 5:49 am
I would not push Advisor as a choice for improving performance.
"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
January 12, 2011 at 2:41 pm
berg.ec (1/12/2011)
Grant Fritchey (1/12/2011)
"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
January 12, 2011 at 1:13 pm
WayneS (1/12/2011)
Grant Fritchey (1/12/2011)
"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
January 12, 2011 at 10:50 am
If you go into configuration manager for the instance in question and open the properties for that instance, you can't enable FILESTREAM on the appropriate tab? It sounds like it...
"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
January 12, 2011 at 10:47 am
It kind of depends on what you're doing with the view because the optimizer is pretty smart about their use. But when you start talking about JOINs with a view......
"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
January 12, 2011 at 9:54 am
Anyone interested in reading a short blog post? I'm a little nervous about putting this one up. I'm talking about how heaps are stored and I've made mistakes there in...
"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
January 12, 2011 at 9:49 am
TheSQLGuru (1/12/2011)
I advise my clients to avoid ALL UDFs of ALL flavors simply because there are WAY too many ways to get in trouble with them.
Proof positive that you're a...
"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
January 12, 2011 at 9:29 am
We need a lot more information to help you out here. Do you have traceflags enabled? Traceflag 1222 will output deadlock information into the error log. With that you can...
"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
January 12, 2011 at 7:00 am
Viewing 15 posts - 13,621 through 13,635 (of 22,227 total)