Viewing 15 posts - 17,521 through 17,535 (of 22,219 total)
To heck with google. Open up Books Online. A lot of, most, of the information you need is in there. You don't need to go googling until or unless 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
May 7, 2009 at 6:05 am
Nice job Sylvia,
When you kick up this much mud, you did well.
I do need to disagree with you though. Picking and choosing when to alias or when not to leads...
"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
May 7, 2009 at 5:50 am
RBarryYoung (5/6/2009)
Grant Fritchey (5/6/2009)
Lynn Pettis (5/6/2009)
sorry, crushed you will be.
I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly...
"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
May 6, 2009 at 2:59 pm
Lynn Pettis (5/6/2009)
sorry, crushed you will be.
I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly Darth, but Darth...
"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
May 6, 2009 at 12:53 pm
Can you run a query against sys.dm_tran_locks? That will give better information. Specifically we need to see the entity_id, the object getting locked.
"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
May 6, 2009 at 12:50 pm
Triggers? Foreign Keys? Rules? Constraints?
There has to be something. You won't get a block... a block, which has a very specific meaning and refers to one process waiting on 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
May 6, 2009 at 12:43 pm
Based on the name, vWorkflowTransition is a view. That means it's probably hitting both tables and maybe more.
"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
May 6, 2009 at 12:34 pm
Alvin Ramard (5/6/2009)
"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
May 6, 2009 at 8:24 am
If your users just need to read data then maybe all you need are some reports written through SQL Server Reporting Services. These can be fed through the web and...
"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
May 6, 2009 at 7:45 am
It really depends on the business requirements. But if you're dealing with hard numbers, I'd use decimal instead of float. Float is an approximate number. This is from the BOL:
Approximate-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
May 6, 2009 at 7:41 am
pushpa.kumari (5/6/2009)
Hi,text datatype can have maximum length of 8000.
I think you should break your dynamic query into 2-3 parts.
Text doesn't actually have a limit that low. Large Objects, LOB...
"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
May 6, 2009 at 7:11 am
I agree with the use of the information_schema instead of the system tables. There've been quite a few changes in how those system tables behave, what you can, etc., between...
"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
May 6, 2009 at 7:08 am
Dugi (5/6/2009)
Grant Fritchey (5/6/2009)
You can call it from the command line. If you had to do it through TSQL, you could use xp_cmdshell, but I wouldn't recommend it.
Yep, my friend...
"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
May 6, 2009 at 7:06 am
You can call it from the command line. If you had to do it through TSQL, you could use xp_cmdshell, but I wouldn't recommend 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
May 6, 2009 at 5:40 am
Yeah, I was wondering the same thing. Can you post the two execution plans, the good one and the bad one?
"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
May 5, 2009 at 3:33 pm
Viewing 15 posts - 17,521 through 17,535 (of 22,219 total)