Viewing 15 posts - 6,181 through 6,195 (of 22,211 total)
Please don't post any more answers to this thread. A more complete conversation is taking place here.
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.
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....
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.
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
😎
😛
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)
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...
May 1, 2015 at 8:30 am
WhiteLotus (5/1/2015)
Grant Fritchey (5/1/2015)
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...
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...
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...
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...
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.
May 1, 2015 at 4:05 am
If you're only doing a SELECT operation, there's no reason to do a TRY/CATCH.
May 1, 2015 at 4:03 am
Steve Vassallo (4/30/2015)
April 30, 2015 at 8:09 am
Viewing 15 posts - 6,181 through 6,195 (of 22,211 total)