Viewing 15 posts - 2,881 through 2,895 (of 8,416 total)
CirquedeSQLeil (7/20/2010)
July 20, 2010 at 10:49 am
Can't be done as part of a restore operation I'm afraid.
You would be able to cut the log file size down to 1MB or so if you were doing an...
July 20, 2010 at 10:39 am
CirquedeSQLeil (7/20/2010)
A.R.K.
Double Precision (aka FLOAT(53))
July 20, 2010 at 10:04 am
Bradley B (7/20/2010)
I was waiting for it after I re-read and saw it was unique and not clustered.
I knew what I meant 😛 but yes, I should have said "non-clustered"...
July 20, 2010 at 9:58 am
Jeff Moden (7/20/2010)
Please see the following "how to" article for a T-SQL only solution...
Yes, that's one of the top articles on the whole site. For some reason, I can...
July 20, 2010 at 9:40 am
Eralper (7/20/2010)
I remember we have a discussion on splitting function, do you remember too 🙂In fact I could not measure how fast my split functions are.
I can't say I do...
July 20, 2010 at 9:39 am
Eralper (7/20/2010)
...Split String using XML - How to Convert or Split a Delimited String Values to Rows using T-SQL XML Commands...
You have the right basic idea there, but using XML...
July 20, 2010 at 6:51 am
Jim McLeod (7/15/2010)
Here's another fun question - what's the difference between a primary key and any other unique key, regardless of whether it's clustered or not?
A primary key cannot contain...
July 20, 2010 at 6:37 am
If the column name contains a space, use square brackets around it: [Version Number]
July 20, 2010 at 2:24 am
Joe Celko (7/19/2010)
Watch out forSET @strVariable = 'J:\SQL 2008 Database Backups\High School Baseball\HighSchoolBaseball_Full.bak\'
The final slash messes up things.
True - though I wonder if that example represents a truly valid...
July 19, 2010 at 10:06 pm
Good point, Jeff; although places that do a point-in-time restore to test and/or development platforms from production backups would include log verification implicitly. I'm also a big fan of...
July 19, 2010 at 10:03 pm
baby_cheeses (7/19/2010)
Sorry I work with lots of mexicans ... I just mean thanks man. 😉
Sweet as, bro 😀
July 19, 2010 at 9:15 am
Hmm, yes I did rather forget the explanation there, didn't I?
It's pretty straight-forward: every connection takes a special Shared lock at the database level, regardless of whether a query is...
July 19, 2010 at 9:04 am
Chris Morris-439714 (7/19/2010)
Ok - you Sue, me Chris.
I've got to tighten up on defence: I was wide open to that!
July 19, 2010 at 9:01 am
Viewing 15 posts - 2,881 through 2,895 (of 8,416 total)