Viewing 15 posts - 6,196 through 6,210 (of 22,226 total)
Please don't post any more answers to this thread. A more complete conversation is taking place here.
"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
May 3, 2015 at 5:43 am
Just so you know, posting in multiple forums leads to very disjointed conversations. You asked the same question over here.
"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
May 3, 2015 at 5:42 am
You might be better off if you at least require the users to separate the words with commas. Then you can use a tally table to split the strings easily....
"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
May 3, 2015 at 5:40 am
And it really has to match 100% exactly in order for this to work successfully. It's somewhat fragile in that regard.
"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
May 3, 2015 at 5:35 am
Eirikur Eiriksson (5/1/2015)
Grant Fritchey (5/1/2015)
.... I'll shut up.Didn't know that was possible:-P
😎
😛
"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
May 1, 2015 at 11:34 am
ZZartin (5/1/2015)
WhiteLotus (5/1/2015)
Grant Fritchey (5/1/2015)
WhiteLotus (5/1/2015)
Grant Fritchey (5/1/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
May 1, 2015 at 8:31 am
Eirikur Eiriksson (5/1/2015)
Grant Fritchey (5/1/2015)
Eirikur Eiriksson (5/1/2015)
Grant Fritchey (5/1/2015)
If you're only doing a SELECT operation, there's no reason to do a TRY/CATCH.
TRY / CATCH is as valid / useful 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
May 1, 2015 at 8:30 am
WhiteLotus (5/1/2015)
Grant Fritchey (5/1/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
May 1, 2015 at 7:39 am
Eirikur Eiriksson (5/1/2015)
Grant Fritchey (5/1/2015)
If you're only doing a SELECT operation, there's no reason to do a TRY/CATCH.
TRY / CATCH is as valid / useful in SELECT as in other...
"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
May 1, 2015 at 6:25 am
Yes, it will roll forward or rollback the transaction depending on if the transaction is complete within the log. If complete, it rolls it forward. If incomplete it rolls 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
May 1, 2015 at 4:12 am
If you've automated any restore operations to test your backups or move data around for development or QA, that would be the one place. But, as you say, applications and...
"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
May 1, 2015 at 4:09 am
3gb is teeny tiny as databases go. Since you're at 99% usage on the data, I'd suggest moving this to a larger drive so you can have it be 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
May 1, 2015 at 4:08 am
Is the data the same? If the distribution is different, that could lead to radical differences in the fragmentation.
"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
May 1, 2015 at 4:05 am
If you're only doing a SELECT operation, there's no reason to do a TRY/CATCH.
"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
May 1, 2015 at 4:03 am
Steve Vassallo (4/30/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
April 30, 2015 at 8:09 am
Viewing 15 posts - 6,196 through 6,210 (of 22,226 total)