Viewing 15 posts - 5,911 through 5,925 (of 22,219 total)
Brandie Tarvin (6/26/2015)
In regards to Game of Thrones, aside from the food issue, what are the tangents that bug you the most? (The subplots that some disagree are actual subplots).
SPOILERS....
"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
June 26, 2015 at 11:26 am
Alvin Ramard (6/26/2015)
Grant Fritchey (6/26/2015)
Alvin Ramard (6/26/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
June 26, 2015 at 7:44 am
Alvin Ramard (6/26/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
June 26, 2015 at 7:22 am
Any plans or data in cache would be removed. But, if they're not being accessed, then the standard processes within SQL Server would also remove them over time, so... it's...
"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
June 26, 2015 at 5:49 am
Nope. Nor should you want to. Gathering the extra bits of data that separate an actual plan from an estimated plan can be costly. You can quickly pull the 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
June 26, 2015 at 5:46 am
For those who do read on the Kindle, if you're ever desperate for a new book, in trouble with the significant other over money spent, or are just interested in...
"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
June 26, 2015 at 4:19 am
Glad to hear it worked out. Sorry I couldn't be specific. To help troubleshoot this in the future, capture the execution plan now while the query is running fast. Then,...
"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
June 26, 2015 at 4:16 am
yb751 (6/25/2015)
SQLBill (6/25/2015)
Brandie Tarvin (6/25/2015)
Why did you hate his books (aside from him killing off favorite characters)?
Was...
"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
June 25, 2015 at 3:32 pm
Love all the B5 books on your shelves. I've been bad about picking those up. I only have about 4 of them.
The real problem, if you want to call 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
June 25, 2015 at 3:28 pm
Brandie Tarvin (6/25/2015)
Why did you hate his books (aside from him killing off favorite characters)?
Was it 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
June 25, 2015 at 12:58 pm
antonio.collins (6/25/2015)
The dba referenced the cited MSDN blog and correctly points out that ALTER INDEX ALL REBUILD does not update column stats. My counterpoint...
"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
June 25, 2015 at 11:28 am
aido-1116077 (6/25/2015)
Thanks for your help folks.
Thanks Grant - I will take the stats out
I tested that command this afternoon on a TLog 65 GB 95% Log usage. Took 5 mins...
"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
June 25, 2015 at 11:24 am
The log won't shrink on it's own. If you ran a log backup, then the committed transactions have been removed. But, you'll need to shrink the log manually to get...
"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
June 25, 2015 at 9:24 am
Ed Wagner (6/25/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
June 25, 2015 at 9:14 am
SQLBill (6/25/2015)
Grant Fritchey (6/25/2015)
SQLBill (6/25/2015)
GilaMonster (6/25/2015)
I found a photo of my Siamese.*sniff*
Okay, so how many looked at the cat and then looked at the books and thought "I have 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
June 25, 2015 at 9:11 am
Viewing 15 posts - 5,911 through 5,925 (of 22,219 total)