Yep, there's loads of extra counters that get added to Windows Perfmon when you install SQL Server, all you have to do it work out which counters to look at...

you could always look at horizontally partitioning the table if the size becomes too much to handle.

Hi there,

You can have a look in books online for the correct syntax, or failing that here's something that should do it for you using SQLDMO inside a script file. ...

Hi,

There shouldn't be too much of a problem, just go ahead and re-attach, SQL will see that the transaction log file is missing and should recreate it for you.

Can you confirm that the table that the bookmark lookup is being performed upon is using the correct index? ie the one that you created to cover it.

From the sounds...

Without knowing the setup i'd probably start with asking about indexes, do you have any and how often are they being updated.  I'd take a look at profiler to identify...

This is the standard way to move database files to different disks (or it is here).

It sounds like you have some orphaned logins in the new databases, you should be...

Same here, we occasionally get some software that can't be installed if TS is enabled but even then there are ways around it.

Just about everything we do (admin wise) it...

Our apps all live in a middle tier between the web and the DB servers, we did that because of problems encountered getting 32-bit code to run properly on 64-bit...

From the looks of things you're not specifying the table that you want to select from

select * into #mytemp from <mytable>;

Basically you have missed off the second bit...

We wen't 64-bit server for our main production DB cluster november last year, the advantages just outweighed the few disadvantages we've identified (and there are always workarounds to be found...

help with the select query, http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=219329

i can see that being useful in the future

You mean I forgot that bit .

Nice script in the newbies section by the way Remi

I'd agree with jo on the inner join; looking at your clustered index creation i take it that the temp table is going to contain quite a few rows?

If it's...

They've just decided that one of my main reasons for upgrading (database mirroring) isn't quite ready and has been put off till next year.

it's a shame that it's not in...