Viewing 15 posts - 5,881 through 5,895 (of 22,219 total)
The AdventureWorks databases are almost never released before the product. I know this because every time I'm working on a book prior to the release I have to use 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 2, 2015 at 11:31 am
Cost threshold for paralellism is a value based on the estimated cost of the execution plan created by the query optimizer. The cost values, once upon a time (we're talking...
"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 2, 2015 at 11:28 am
I stopped maintaining the home lab and moved it all to Azure. So much easier to get everything I need fast, no upgrades necessary, nothing to maintain. The only pain...
"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 2, 2015 at 11:20 am
There is absolutely no hard and fast rule on this at all. It just depends on your data, how fast it comes in, and how much the data changes are...
"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 2, 2015 at 10:23 am
Don't run Profiler on a production server. Profiler is for consuming the data, not doing the monitoring.
To capture the information with the least possible hit on your server, use extended...
"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 2, 2015 at 10:19 am
ramana3327 (7/2/2015)
Capturing the transactions 1-2 hrs from production 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
July 2, 2015 at 10:03 am
Since I am usually the harbinger of ill tidings on the thread, you guys should know, Skynet seems to be going live.
"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 2, 2015 at 8:25 am
When I taught classes like this where all we were doing was querying, instead of setting up Express (not a bad idea, just not what I needed), I created 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
July 2, 2015 at 7:25 am
And if you don't have a plan that will go parallel on its own, just use TRACEFLAG 8649. That will drop the query cost to zero so you'll see 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
July 2, 2015 at 7:20 am
It really depends on your transaction load, but you have a couple of options. Use Extended Events and capture all the RPC Completed and SQL Batch Completed events for 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
July 2, 2015 at 3:33 am
rodjkidd (7/2/2015)
I liked Belgium when I visited. The beer does help of course 😀 Must go back again soon.
Grant when and where will you be in the UK?
Don't stand 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
July 2, 2015 at 3:09 am
Koen Verbeeck (7/2/2015)
When are you coming to Belgium? We are currently in a heat wave, so bring sunscreen 🙂
Week after next. Next week is in the UK.
"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 2, 2015 at 3:07 am
Lynn Pettis (7/1/2015)
"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 1, 2015 at 3:44 pm
Sean Lange (7/1/2015)
Grant Fritchey (7/1/2015)
Sean Lange (7/1/2015)
jasona.work (7/1/2015)
Half the people (the smart ones?) take the other 4 days...
"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 1, 2015 at 3:42 pm
Koen Verbeeck (7/1/2015)
Grant Fritchey (7/1/2015)
Sean Lange (7/1/2015)
jasona.work (7/1/2015)
Half the people (the smart ones?) take the other 4 days...
"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 1, 2015 at 3:38 pm
Viewing 15 posts - 5,881 through 5,895 (of 22,219 total)