Viewing 15 posts - 10,096 through 10,110 (of 39,769 total)
Second vote for a table.
January 17, 2015 at 11:07 am
Strange. Just one database?
Have you tried something as simple as
backup database x to disk = 'test.bak'
and see if that works? Rebooted the Windows host?
I've never heard of this. I...
January 17, 2015 at 11:07 am
I actually think the CLR has worked well. MS used it internally to add things like HierarchyID to the native product (along with Spatial and other items). It gives them...
January 17, 2015 at 11:04 am
New laptop, and new labs for me. Toshiba Z30 arrived yesterday, so setup begins today. Then I have to make the switch from Hyper-V back to VMWare (corp decision), so...
January 17, 2015 at 11:02 am
I looked at this awhile ago, so this from memory. I don't have time to test, but I'd be sure if I were you, I put up a VM and...
January 16, 2015 at 4:56 pm
Michael.Beeby (1/16/2015)
11.00.5556 has appeared.
Thanks, updated
January 16, 2015 at 4:44 pm
I like that you're keeping a surrogate key. Good idea.
I like Lowell's thoughts on computed columns. While not specifically doing this, I have done similar things in the past and...
January 16, 2015 at 10:39 am
Thanks, I'll see if we can't clean up some of this.
January 16, 2015 at 10:37 am
isaacchk (1/15/2015)
January 15, 2015 at 12:07 pm
Eric M Russell (1/15/2015)
January 15, 2015 at 8:56 am
JimAtWork (2/3/2014)
January 15, 2015 at 8:37 am
spaghettidba (1/15/2015)
I would buy the X5. BMWs are great cars and even old ones (mine is 6 year old) look like new. The engine...
January 15, 2015 at 8:31 am
Ah, sorry, didn't realize this was a SQL 2000 instance.
You could use something like prasenjit221's code. I don't have a SQL 2000 instance handy to test, but that looks compatible....
January 15, 2015 at 8:11 am
Licensing isn't an issue, except that often we as the geeks do make recommendations. While it can be cheaper to spin things up, it isn't always cheaper. We've done analysis...
January 15, 2015 at 8:08 am
John Mitchell-245523 (1/15/2015)
SQLvis (1/15/2015)
Is there a list of standard object nomenclature for indexes, procedures, functions, and views (etc) that most teams should follow?
Not really. It's more important to have...
January 15, 2015 at 8:02 am
Viewing 15 posts - 10,096 through 10,110 (of 39,769 total)