Viewing 15 posts - 271 through 285 (of 832 total)
I'm another who answered "None of the above" because the disk IO in sp_who2 is both reads and writes, not just reads--it's the sort of trick answer that a lot...
September 21, 2012 at 1:46 am
Is that query in the OP transcribed correctly? Because you don't seem to have enclosed the BX-00006767 value in quotes, which means SQL server isn't going to interpret it as...
September 18, 2012 at 4:14 am
Are you using SQL Management Studio to issue these commands? It has an annoying tendency of opening multiple connections to the database, so you'd be better off using SQLCMD to...
September 18, 2012 at 3:42 am
Steve Jones - SSC Editor (9/7/2012)
Luis Cazares (9/7/2012)
Four is overkill, but it's nice and symmetric for me.
Terry Pratchett would disagree--I saw a TV program which showed his main work station,...
September 7, 2012 at 8:58 am
Sqlism (9/6/2012)
EXEC xp_cmdshell 'net use v: \\ServerName\foldername'Here we are assigning V as drive letter to the \\ServerName\foldername'
-----------------------------------
BACKUP DATABASE [XYZ] TO
DISK = N'v\xyz.bak'
WITH stats = 10, format
What's...
September 7, 2012 at 3:32 am
Dream machine would have a super-fast hard disk subsystem (maybe SSDs in RAID), at least 16Gb of RAM, super-powerful CPU and a single, very large monitor. (I dislike using multiple...
September 7, 2012 at 3:11 am
Adam Machanic (9/4/2012)
The code that follows is my crack at a more memory efficient solution. It works only for a single delimiter (I never did see the point of multi-character...
September 5, 2012 at 2:30 am
I'm with Mark on that one. The client may be telling you that the requirement is always for two-person teams and that this will never change, but if you believe...
September 4, 2012 at 1:58 am
I'd never heard of a bitmap index, but I knew which four answers were right and so did OK. If it hadn't specified there were four right answers I'd have...
August 30, 2012 at 7:34 am
The first company I worked at was *all* Shadow IT. It was a small company which employed a large proportion of IT-savvy people (programmers, mostly), so they just relied upon...
August 28, 2012 at 7:27 am
Steve Jones, 2012:
"The more I think about my career, the more I think that I've spent more time fixing things than actually working on new code."
Maurice Wilkes, 1949:
"As soon as...
August 24, 2012 at 3:17 am
Steve Jones - SSC Editor (8/23/2012)
I suppose it could have been 1..1001 and tested the same thing.
1001 is an odd (literally :-P) upper value, though--it would immediately make people suspect...
August 23, 2012 at 9:00 am
I didn't overlook the zero on the first one, but that's maybe because I've programmed in both C and BASIC and you soon learn to notice things like that after...
August 23, 2012 at 1:46 am
Miles Neale (8/22/2012)
Just takes a little creativity and a good memory, and a handy password safe.
:-):-)
The problem there is that these questions are usually intended to allow you to...
August 23, 2012 at 1:30 am
Why would taking a backup potentially cause problems? If there's an existing backup plan in place then taking a manual full backup shouldn't be an issue, and if there IS...
August 22, 2012 at 6:02 am
Viewing 15 posts - 271 through 285 (of 832 total)