Viewing 15 posts - 8,491 through 8,505 (of 22,224 total)
Koen Verbeeck (4/2/2014)
Jeff Moden (4/2/2014)
Heh... waiting for SP1. 😉Good grief, there may be 25 CUs released before they even think about an SP 😉
If they even do an SP. I've...
"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 2, 2014 at 3:42 am
hans.pret (4/2/2014)
I reviewed the sql logs again and saw that a checkpoint is created in the master database every time the server is restarted. 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 2, 2014 at 3:41 am
You have to change your code to use the full text index. It's not like a regular index where the optimizer just picks it up. You need to read up...
"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 2, 2014 at 3:38 am
GilaMonster (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 4:55 pm
Take a look at the execution plan. It's possible that you're seeing scans across all those other tables. Maybe some indexes are in order.
"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:47 am
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
Viewing 15 posts - 8,491 through 8,505 (of 22,224 total)