Viewing 15 posts - 256 through 270 (of 832 total)
Can someone explain in what way SNAPSHOT doesn't meet the stated requirements? That's the answer I selected and I always like to know exactly how I've been a helpless newb......
November 21, 2012 at 7:06 am
crmitchell (11/19/2012)
You mean the rule you were taught at school to round halves to even numbers?
That's "banker's rounding", and it certainly isn't routinely taught in schools in the UK; and...
November 19, 2012 at 6:24 am
It's difficult to think of a situation where this would arise...is it actually possible to get an untyped NULL via any means other than just typing NULL into the function?
November 9, 2012 at 9:43 am
I'm sure I've said this before, but I don't think the advantages of using BULK LOGGED mode are worth the potential risks. If the data is critical enough that the...
November 7, 2012 at 2:18 am
No problem.
November 2, 2012 at 10:34 am
That's only showing the client tools--there should be a section in there for the database engine as well. Are you sure this isn't just the Management Studio Express installer you're...
November 2, 2012 at 5:40 am
The instance name of the installed software may give a clue as to what installed it--the aforementioned Backup Exec instance is called BKUPEXEC, for example.
November 2, 2012 at 5:33 am
mtassin (11/1/2012)
Oh and of course I got it wrong... because I just went with
SELECT ASCII('Z')-ASCII('0')
That's pretty much what I did, but I did it in my head rather than using...
November 1, 2012 at 8:41 am
I thought the answers were a trifle ambiguous--I think it would have been a lot clearer if the 3rd column was aliased as "Sales Goal" rather than "Sales". As it...
October 30, 2012 at 2:43 am
OK, OK, I admit it: there are probably situations where this would be useful. I suppose I was thinking more about the "delete without WHERE" option, which to me would...
October 25, 2012 at 1:36 am
Rod at work (10/23/2012)Now I'm really curious to know how this will effect things during deployment?
The only thing I can think of that might cause issues during deployment is that...
October 24, 2012 at 6:45 am
Surely, for the faulty transaction to still be in the log file, the database must be in full (or bulk-logged) recovery, so you ought to be able to do a...
October 24, 2012 at 2:21 am
There's something wrong with my brain this week--I did the research and then somehow ended up clicking that you could have multiple ROWGUIDs on a table variable, even though you...
October 19, 2012 at 8:08 am
Been trying to figure out what blind alley my brain went down to get this *wrong*--I correctly got the entire thing down to ISNULL('NULL', 'Pass') + 'Fail', but then somehow...
October 17, 2012 at 8:11 am
No, you can't. SQL server permissions are entirely independent of Windows server permissions, and you need to be a local admin to restart a service--there are no exceptions to this.
October 1, 2012 at 4:18 am
Viewing 15 posts - 256 through 270 (of 832 total)