Viewing 15 posts - 8,491 through 8,505 (of 22,226 total)
Not sure what you're referring to.
"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:52 am
Not questioning Gail at all, because I'm sure she's right, but, you did you try compiling those queries natively? That's where some of the bigger performance results are achieved. Gail...
"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:51 am
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
Viewing 15 posts - 8,491 through 8,505 (of 22,226 total)