Viewing 15 posts - 211 through 225 (of 832 total)
Hugo Kornelis (5/9/2013)
Actually, it does make more sense than you may think. It is the result of a combination of features that, in and of themselves, are rather innocent.
Thanks for...
May 9, 2013 at 3:19 am
Have to admit, I'm puzzled by this behaviour. It doesn't make logical sense for SQL to make a substitution like this when the table you're selecting from is explicitly named...
May 9, 2013 at 2:05 am
It's clearly a Monday morning--I guessed that FORCESEEK and FORCESCAN would do something different, since they're new in SQL 2012, but I then ticked those two rather than the other...
April 29, 2013 at 4:14 am
pdanes (4/23/2013)
I assume then, that the reading of log records is a one-time event? That is, after doing the primary read, it catches up with the log records once, and...
April 24, 2013 at 1:13 am
Depends what CHECKDB is telling you. If it's saying that the minimum requirement to fix the problems is REPAIR_ALLOW_DATA_LOSS then, with no backups, you can't (or are very unlikely, at...
April 23, 2013 at 4:34 am
Seems to me that when this guy is accusing you of making stuff up he's basically saying "I don't understand what you just said". I agree with you and Gail...
April 22, 2013 at 6:56 am
GilaMonster (3/25/2013)
You won't be able to drop or restore the database, just restart SQL. Shouldn't take any recovery time at all.
I think that's the first time I've ever seen you...
March 26, 2013 at 7:04 am
LoosinMaMind (3/25/2013)
There must be some way of splicing up the date so you can check to see if "dd" is between 1-31 and the "mm" is between 1 and...
March 26, 2013 at 6:33 am
There's no problem with installing the actual SQL server binaries on a different drive, no...we have a test server here that has SQL installations on both drives D: and Q:,...
March 26, 2013 at 5:44 am
This seemed so simple I went and ran the code, sure there must be a catch of some kind--turns out there wasn't, it was as simple as is seemed at...
March 26, 2013 at 5:04 am
1991? Sheesh. I didn't even own a PC until 1994, and that was a 40MHz 386SX with 100Mb of disc space and 1Mb of RAM...the most powerful machine in the...
March 19, 2013 at 10:45 am
It's rarely a good idea to just blindly implement every missing index recommendation, in my experience. If you look carefully at the queries you might find you can construct a...
March 14, 2013 at 10:42 am
I think I got it right because I misread the third answer--apparently just like the author of the question. 🙂
March 8, 2013 at 9:04 am
I think there's another possible reason to not want to work from home. Speaking personally, I like to keep home and work in their own separate compartments--I'll work from home...
March 7, 2013 at 2:11 am
SQLCharger (3/6/2013)
Guys,Would this also work with Windows hashes as well?
That would be even more scary (if someone manages to get your Windows hash from a server). :unsure:
There's no reason why...
March 6, 2013 at 1:22 am
Viewing 15 posts - 211 through 225 (of 832 total)