Viewing 15 posts - 721 through 735 (of 1,162 total)
R2 was released well prior to SQL 2008 SP2, so it's actually behind in terms of core RDBMS bug fixes. I suspect the bug will be in a cumulative update...
June 13, 2011 at 5:46 am
You could rename the old column to something else using sp_rename, then create the computed column. Either way you're going to want to drop the existing column at some point
June 8, 2011 at 1:51 am
You'd need to drop the existing column then create the computed one.
Computed columns can't be created/modified through an alter column statement (the same goes for if you change the definition...
June 7, 2011 at 9:17 am
Firstly, SQL Server is not converting your dates to a different format. A datetime is a datetime regardless of your regional settings. What's different is how SSMS and other client...
June 1, 2011 at 6:16 am
Haven't played around with SQL Server -> mySQL too much, but firstly, I'm not sure there's a need for the cursor - couldn't you just do the following:
INSERT INTO MYSQLDB.test.clientinfo...
June 1, 2011 at 5:56 am
paul.knibbs (5/31/2011)
Jeff Moden (5/29/2011)
Now that's cool. Didn't know that. I may have to look into that... you're getting better gas mileage than my 1300 cc motorcycle.
I average 57mpg...
May 31, 2011 at 6:14 am
Full Text Search is very different to using LIKE and if you need pattern matching within a string, you're using the wrong tool - it's based around language and full...
May 24, 2011 at 8:51 am
The encryption offered for Stored Procedures is incredibly trivial to reverse and can barely be called obfuscation.
Even if you could truly encrypt the stored procedure, you can never hide the...
May 23, 2011 at 2:11 am
SQLRO (5/20/2011)
You could possibly manage it with the SERIALIZABLE isolation level and the READPAST hint, selecting 10 records from each thread and holding the transaction open while you processed them
I...
May 20, 2011 at 4:35 am
This sounds like a high contention work queue scenario.
You could possibly manage it with the SERIALIZABLE isolation level and the READPAST hint, selecting 10 records from each thread and holding...
May 20, 2011 at 4:00 am
Gaurang-Patel (5/19/2011)
Select into: 2 sec.
insert into: 9 sec (without Tablock).
insert into: 3 sec (with...
May 19, 2011 at 7:09 am
Gaurang-Patel (5/19/2011)
i know that select into is much quicker than insert into.and i had doubt that
it is unlikely that i am going to get all records inserted in...
May 19, 2011 at 6:48 am
Gaurang-Patel (5/19/2011)
there was typo ,actually we have ldf on SAS, we don't have any ndf.i created ndf on SAS
drive and Test i got 11 seconds,that most of time...
May 19, 2011 at 6:30 am
colin.Leversuch-Roberts (5/19/2011)
select into is much quicker than insert into.
Not necessarily true - in SQL 2008 minimal logging applies to more insert statements than just SELECT...INTO, especially into heaps:
Also with Trace...
May 19, 2011 at 6:27 am
Viewing 15 posts - 721 through 735 (of 1,162 total)