Viewing 15 posts - 9,436 through 9,450 (of 9,725 total)
I don't recommend a snapshot, actually. If the Developers are going to be constantly developing against a DB, a better practice would be to do a nightly restore of production...
September 17, 2007 at 10:38 am
Ariadne,
Remember also, that if you automate your backups via the Litespeed Enterprise console, it can self verify without you having to "wait until it's done" and running that extended sproc.
September 17, 2007 at 10:33 am
Actually, there's sound reason to move your SQL Server install to another drive. If you have multiple drives, put your OS on the C: drive and then the SQL Server...
September 17, 2007 at 10:31 am
DateTime collation issues shouldn't affect a character field, so it's a little strange to me...
What's the code you're using for the Bulk Insert? What delimiters are being used in the...
September 17, 2007 at 10:14 am
Paul,
What size is the character field you're using in your staging table? You don't mention that.
Also, if it's importing as a character field, but syntax erroring on the Convert, you...
September 17, 2007 at 8:06 am
Andras,
Thanks for clarifying my link issues. I thought you were talking TechNet, not BOL. @=)
You know, I already knew all this extended property stuff. I guess I just didn't realize...
September 14, 2007 at 10:55 am
So, basically I'm correct in thinking that if I don't need to return results as one row XML (FOR XML RAW without the Elements keyword), that there's really no reason...
September 14, 2007 at 10:11 am
I've never actually had a bully boss myself. I had a paranoid micro-managing boss once, and a strict / insensitive boss another time, but never one that was an actual bully. ...
September 14, 2007 at 9:38 am
Paul, check the collation on your server OS and on your SQL Server. The column itself might be collated differently than the other collations or your database / server collation...
September 14, 2007 at 6:31 am
I can't reach that URL. IE keeps complaining about a bad gateway.
Is there a KB # or a search term I could use to find it?
September 14, 2007 at 5:50 am
FYI: The Query menu option only works for the window you're currently working in. If you want a more permanent solution that sticks with every window, go to Tools ->...
September 14, 2007 at 5:32 am
You shouldn't need all the fancy substring stuff to convert properly, assuming you have good data in your fields. Try:
Convert
(datetime, <mydate>, 103)
September 14, 2007 at 5:05 am
That's what I'm hoping. @=) My test is scheduled in a week & 1/2, so we'll see.
My main problem is the technologies that 2k5 has but that we aren't using...
September 13, 2007 at 3:58 am
I honestly don't know that the Bully Boss laws are necessary. Why? Well, because there is such a thing as "Hostile Workplace Environment" which a lot of people overlook. Usually it's...
September 12, 2007 at 12:28 pm
I can't find the specific report on CNN.com (searched on "Bully Boss" and "Bully Boss Legislation"). I got a lot of hits, but not the specific report that I happened...
September 10, 2007 at 7:05 am
Viewing 15 posts - 9,436 through 9,450 (of 9,725 total)