Viewing 15 posts - 5,911 through 5,925 (of 22,226 total)
DBA From The Cold (6/30/2015)
I've had 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
June 30, 2015 at 3:56 am
Congrats Alan. That's awesome.
"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 29, 2015 at 12:39 pm
jellybean (6/29/2015)
Hi,Yes SQL Search is free, indexes fast and is easy to use but does not detects string in the synonyms 🙁
Put in a feature request.
"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 29, 2015 at 5:51 am
Unfortunately, there isn't an alternative to CHARINDEX and LTRIM. You need to not use functions, at all, of any kind, on your columns. If your data requires you to pull...
"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 29, 2015 at 5:48 am
What Kevin is referring to is this:
LTRIM(P.partnerSqlId) + '-' + LTRIM(P.partnerIncId) = @PartnerKey
That is going to destroy your performance and there's no way around it. You need to remove 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 27, 2015 at 8:00 am
Please don't cross post into multiple forums. Most of the people answering questions here read across many of the forums. Cross posting just leads to confusion as different people answer...
"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 27, 2015 at 7:54 am
better than what? I've reformatted it so that it's more readable and use the IFCode Shortcuts in the post screen of this website to highlight it as SQL.
SELECT a.emp_id,
...
"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 27, 2015 at 7:52 am
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
Viewing 15 posts - 5,911 through 5,925 (of 22,226 total)