You can do that .... The question is WHY would you !!!

If you have 64-bit available, use as much 64-bit software as you can !

(btw with x64 sql2005 with...

I think that is a valid reason to install your test server with SP2.

The migration project is the factor that calls for this decision. !

When testing your migration, try to...

Just my 2ct...

In my prereq sheet, our window installers are using, I always request the disks to be formatted using the largest possible block size available.

I personally don't think...

So you should start with a "timeslot" table.

Did you read these wonderful articles ?

- The "Numbers" or "Tally" Table: What it is and how it replaces a loop. By...

I haven't encountered that behaviour.

We recently went the other way around.;-)

Maybe setting sqlservers "max server memory (MB)" config can help out.

Or the simple version:

Select distinct DATEADD(day, 0, DATEDIFF(day, 0, dt)) as DateOnly, AT, sysuser

from #T1

order by DateOnly, AT, sysuser

Did you use SQL2005 upgrade advisor to prepare your action ?

I prefer option A, but I would set the end date to a default value of '9999-12-31' and document it.

Point is to avoid the NULL.

Having the actual datetime data will...

I prefer option A, but I would set the end date to a default value of '9999-12-31' and document it.

Point is to avoid the NULL.

Having the actual datetime data will...

I only noticed this on my laptop, which is becomming slow, so I'm not surprised this may occur because of timeouts.

The instances on my laptop (sql2000 / sql2005 / sql2008)...

did you receive messages about databases that couldn't be opened due to insufficient resources or disk space ?

I have this occasionally on my laptop, and then I don't trust what...

It is good to take tempdb in your control.

you should find traces of your operation in the default trace of your instance.

- can you provide @@version info of your instance...

BOL has all info I have 😉

http://msdn.microsoft.com/en-us/library/ms188755.aspx

Keep in mind a stop/restart of your sqlserver instance will reset these data !!

If you want this info long term, you'll have to...

Have fun !

I hope I'll get a new occasion next year.

-- list most used tables

-- SQLServermagazine instantDoc 53878

--

SELECT

t.name AS 'Table',

SUM(i.user_seeks + i.user_scans + i.user_lookups) AS 'Total_accesses',

SUM(i.user_seeks) AS 'Seeks',

SUM(i.user_scans) AS 'Scans',

SUM(i.user_lookups) AS 'Lookups'

, min(s.login_time) as StartUp_DateTime

, min(s.Years) as ServerUp_Years

,...