Viewing 15 posts - 3,046 through 3,060 (of 14,953 total)
The question is simply "are they faster", not "are they better", so I went with just that in mind when I answered.
I'm looking at it from "all else being equal",...
October 27, 2011 at 12:19 pm
Can you copy msdb from one to the other? It's a bit tricky, and you'll want to look into other effects from it than just copying jobs, but you...
October 27, 2011 at 12:16 pm
You can do your original idea. It's a really bad idea, but it can be done. My first database worked that way, and it was a mess in...
October 27, 2011 at 7:24 am
Eric M Russell (10/27/2011)
October 27, 2011 at 7:21 am
The Windows license limits are the main problem, as already mentioned.
However, setting up a VM with *nix (I prefer FreeBSD for this), and using that for browsing unverified sites and...
October 27, 2011 at 6:55 am
Kiara (10/27/2011)
Stefan Krzywicki (10/26/2011)
Kiara (10/26/2011)
Droid Bionic here. I have an iPad2 - and I just don't like it all that much.
What dont you like about it? Everyone I know...
October 27, 2011 at 6:17 am
jcrawf02 (10/26/2011)
missed a couple user group meetings I meant to get to (online), would...
October 27, 2011 at 6:15 am
For nested XML, it's usual to use the Type operator at all levels. Otherwise, the subquery ends up as a string value, and it can do weird things if...
October 27, 2011 at 6:10 am
Ninja's_RGR'us (10/26/2011)
GSquared (10/26/2011)
The way you did is just fine.The T-SQL Pivot function is nearly useless, in my opinion. Don't bother with it.
How come?? Never bothered to learn it...
October 27, 2011 at 6:08 am
benlatham (10/26/2011)
October 27, 2011 at 6:02 am
kstjacques (10/26/2011)
GSquared (10/26/2011)
Have you tested point-in-time recovery with your...
October 26, 2011 at 3:13 pm
george sibbald (10/26/2011)
'In summary, turn off log truncation. You don't need it, don't want it, and it can (will) break your...
October 26, 2011 at 3:11 pm
GilaMonster (10/26/2011)
GSquared (10/26/2011)
October 26, 2011 at 3:10 pm
George: What you don't want is to just truncate the log file without a backup. If you do a backup, you don't need to truncate it, because the backup...
October 26, 2011 at 1:19 pm
Lookup table will definitely be faster and more efficient.
October 26, 2011 at 12:14 pm
Viewing 15 posts - 3,046 through 3,060 (of 14,953 total)