Viewing 15 posts - 1 through 15 (of 17 total)
We migrated our SQL 7 to SQL 2008R2 earlier this year, and have just migrated most of the staging server from SQL 2000 to SQL 2008R2. The staging instance is...
October 25, 2011 at 9:42 pm
Hi,
In demonstrating their new monitoring app that runs on ... almost anything, RedGate are showing the state of Schrödinger's cat prior to openning the box.
October 12, 2011 at 4:49 pm
Hi Folks,
I've been thinking about this question, and looked through a fair bunch of Paul Randal's stuff around this issue and figure that the correct answer is actually missing: For...
February 24, 2011 at 1:17 pm
Steve Jones - Editor (8/31/2010)
September 2, 2010 at 7:15 pm
My vote is for more regularity for SQL Service Packs.
Of course I don't want the quality to drop. But as been previously noted there is a discrepancy in how far...
April 29, 2010 at 9:30 pm
Hi,
On my list
SSMS
Winmerge for comparing/merging text files
Context editor
Notepad++ editor
A bunch of query templates
Cheers
David
April 11, 2010 at 8:27 pm
Hi,
Interesting question.
But this code - based on the question - fails with Error converting data type varchar to float.
[font="Courier New"]if( select isnumeric( @PrincipalAmount )) = 1
select convert( float, @PrincipalAmount...
February 21, 2010 at 4:15 pm
Two quick points
The question should have had an answer option that referenced the model database
The obvious lesson is: If you care about the database size, specify it!
Cheers
David
January 21, 2010 at 1:54 pm
Hi,
Great news that you got it sorted.
If you look up bol for sp_attach_db and sp_detach_db, it recommends instead using the alter database set offline. That way SQL keeps history and...
December 20, 2009 at 1:30 pm
Hi,
If using alter database modify file to specify the new path/filename, you can use
alter database myDatabase set offline
then after the physical move
alter database myDatabase set online
HTH
David
December 17, 2009 at 6:04 pm
Hi,
I accept that others have tested and found that everything is created on FG1.
>> from SQL 2008 BOL
If CLUSTERED is specified or the constraint otherwise creates a clustered index, and...
December 10, 2009 at 7:21 pm
Viewing 15 posts - 1 through 15 (of 17 total)