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...

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.

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...

Steve Jones - Editor (8/31/2010)

---

2 years in college. Started in the UK, played a bit of 2nd row and then dropped to the "B" team so I could get out...

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...

Hi,

On my list

SSMS

Winmerge for comparing/merging text files

Context editor

Notepad++ editor

A bunch of query templates

Cheers

David

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...

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

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...

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

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...

bitbucket-25253 (11/19/2009)

---

Now now ... the answer to you is that...

Lynn,

I read the comments quite...

Lynn,

>>

Forget the question for a bit. If the columns or variables are properly named and/or documented to allow the developer to know what data is stored in them (local or...

Dear Bit-bucket,

The question was badly worded/phrased/whatever.

How about:

What does this query output?

select datediff( second, getdate(), getutcdate())

Answers

a -46800

b -41000

... etc

z difference in seconds between my time and utc time.

Although...