Viewing 15 posts - 466 through 480 (of 832 total)
I may be wrong on this, but I'm pretty sure that SQL Server full-text search uses the full stop as one of its word delimiters--in other words, if you have...
August 31, 2011 at 1:02 am
I think it would depend how long the DC is down for. I can see the machine using cached credentials for a while, but eventually it's going to have to...
August 26, 2011 at 8:42 am
Of course, all this lockdown presumably only applies to Windows machines...can't you set up Linux on an old PC and put Eventum or something on it? 😛
August 25, 2011 at 9:10 am
I believe that a 32-bit process running on a 64-bit OS actually has access to a full 4Gb of virtual address space, because there aren't any hardware or drivers taking...
August 19, 2011 at 7:47 am
Speaking personally, I would rather have a slightly longer commute than move deeper into the city to get to work--I like being able to see the occasional piece of greenery...
August 11, 2011 at 1:27 am
I pretty much always eat alone, and use the opportunity to do non-work-related web browsing whenever possible!
August 3, 2011 at 2:27 am
No, I typed NULL because I started life as a C programmer and some habits die *really* hard...
August 2, 2011 at 6:31 am
Well, yes, but the Windows collation that works is a binary collation--you'd expect that to be able to take NULLs in its stride, since it wouldn't be much use if...
August 2, 2011 at 6:20 am
Having done an upgrade from 2000 to 2005 with a similar procedure, I can say that leaving the database in compatibility mode for an older version does NOT ensure everything...
August 2, 2011 at 4:06 am
Dhruvesh Shah (8/1/2011)
August 1, 2011 at 6:08 am
SQLkiwi (8/1/2011)
That explains it nicely - and Peter Larsson (SwePeso) added pretty much the exact same example as this QotD in the comments.
It's still realistically a bug, though--even if CHAR(0)...
August 1, 2011 at 3:42 am
Elliott Whitlow (7/28/2011)Model is only needed for new databases
tempdb is created anew every time SQL Server is started, so you need the model database to be there or else SQL...
July 29, 2011 at 4:56 am
Why not take all the backups to the internal hard drive of the server and then have a scheduled task to copy them to the external USB drive in the...
July 27, 2011 at 1:52 am
I'm not sure increasing the row length in SQL would help much--after all, the largest data types are stored in off-row data pages anyway, and a properly normalised database surely...
July 27, 2011 at 1:25 am
If your CPUs are, indeed, "chilling and not doing anything", why are you assuming it's them that's at fault? Sounds more likely to be an I/O issue if you're not...
July 25, 2011 at 2:20 am
Viewing 15 posts - 466 through 480 (of 832 total)