Viewing 15 posts - 9,706 through 9,720 (of 22,232 total)
Welcome!
Keep your hands and feet inside the vehicle at all times and enjoy the ride.
"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
July 30, 2013 at 8:19 am
Bhaskar.Shetty (7/30/2013)
I am facing a weird problem since couple of days, When we tried to execute the any SP (Randomly) sometimes throws the error "The definition of...
"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
July 30, 2013 at 8:18 am
No, you'd need to script it. But, if you have a fairly consistent naming or storage mechanism you should be able to script the scripting, write dynamic T-SQL to build...
"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
July 30, 2013 at 8:14 am
I would not assume they're identical in all respects. You need to identify specifically why the query is running slowly. I'd start with sys.dm_exec_requests. That will show you if 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
July 30, 2013 at 8:05 am
A pretty common use of unique keys is when you have an artificial primary key for a table, the single most common example is the identity field, but you still...
"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
July 30, 2013 at 8:04 am
Spools are a way for the query engine to store data, either for reusing it, or for rollbacks (other situations too, imagine where it might need to keep stuff for...
"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
July 30, 2013 at 8:01 am
I'm cool with anyone handling backups. As long as they get done and (the kicker) as long as we can successfully restore them in a timely manner. If it takes...
"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
July 30, 2013 at 7:58 am
WayneS (7/29/2013)
Just curious - how many like that new tile look on the home page?FWIW: I prefer the older images over these tiles.
It's all http://www.youtube.com/watch?v=0pRUGsB1qGY all the time, everywhere.
"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
July 29, 2013 at 12:23 pm
HowardW (7/29/2013)
Grant Fritchey (7/23/2013)
"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
July 29, 2013 at 9:14 am
No worries. Which user group was 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
July 24, 2013 at 1:20 pm
They have relaunched the project and something should be coming out ... soon? I don't have any dates or date estimates for you. Sorry. But, I think, possibly, this fall....
"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
July 24, 2013 at 1:11 pm
In general, partitioning is not a great mechanism for improving query performance.
Without seeing the query or the execution plan, I'm only guessing.
It sounds like the order in which 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
July 24, 2013 at 1:08 pm
Be careful with the UDF. An in-line UDF is fine, but a multi-statement table valued UDF could lead to serious performance bottlenecks.
"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
July 24, 2013 at 5:06 am
Pretty much all of what you're looking for is available in sys.dm_exec_requests dynamic management view. Take a look there.
"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
July 24, 2013 at 5:03 am
Are they inserting data into the regular tables and then updating it in place as part of a single operation?
If so, your approach could possibly work. But what about just...
"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
July 24, 2013 at 5:02 am
Viewing 15 posts - 9,706 through 9,720 (of 22,232 total)