Viewing 15 posts - 8,491 through 8,505 (of 22,219 total)
Nothing was available until 9AM West Coast time. I understand most of it's online now. I just used Azure to spin up a VM. A lot quicker than downloading if...
"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 1, 2014 at 10:46 am
Jeff Moden (4/1/2014)
jasona.work (4/1/2014)
Grant Fritchey (4/1/2014)
jasona.work (4/1/2014)
"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 1, 2014 at 7:41 am
Ed Wagner (4/1/2014)
Lynn Pettis (4/1/2014)
jasona.work (4/1/2014)
...OK, old man rant off (crap, 44 is just 3.5 weeks away!)
You're not old!
Personally, I really hope you're not old at 44. 😉
Ditto. I'm 51.
"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 1, 2014 at 6:57 am
The one recommendation I can make is that the defaults don't really work well as your databases get bigger. Growing by percentages gets worse as the databases get larger ...
"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 1, 2014 at 6:27 am
jasona.work (4/1/2014)
"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 1, 2014 at 5:27 am
A UNION statement is an aggregation, so, unless you're doing UNION ALL, it's not the sum of the three queries, but the aggregation of the three. Check the execution plan...
"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 1, 2014 at 4:41 am
You can specify a stop time for a trace. So you just need the job to start it and then it will run until the @stoptime property. You can read...
"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 1, 2014 at 4:37 am
Those are waits related primarily to disk. Are you backing up across the network? Otherwise, I'd focus right on the disk to see what issues there might be 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
April 1, 2014 at 4:34 am
WHOOP! Can't wait to use the robot for presentations.
"ASK A QUESTION! YOU HAVE 10 SECONDS TO COMPLY. 3.... 2.... 1...."
"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 1, 2014 at 4:27 am
GilaMonster (4/1/2014)
Ok..."The language is expressive, easily readable and values explicitness. Abbreviations and corrupted spelling should be avoided in variable names"
and the string data type is 'str'
<snicker>
"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 1, 2014 at 4:22 am
I've never seen SSMS by itself cause any issues and I've left it open for days at a time.
"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
March 31, 2014 at 4:14 pm
Ummm... You might not want to move to working as a DBA if network admin was stressful. DBA work becomes hyper-stressful. Think about it, one of the single most important...
"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
March 31, 2014 at 4:13 pm
New Born DBA (3/31/2014)
Thanks everybody for replying. Can I use import export utility? Just asking.
This will put more load on the production system than using the backup and restore process.
"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
March 31, 2014 at 11:58 am
Even if you do tests to determine an approximate run time, you can still hit resource contention or blocking issues that cause that time to change. This is a tough...
"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
March 31, 2014 at 5:45 am
Partitioning is not primarily a performance tuning mechanism. It is primarily a data management mechanism. There are cases where you can get performance improvements, but you need to remember that...
"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
March 31, 2014 at 5:33 am
Viewing 15 posts - 8,491 through 8,505 (of 22,219 total)