I suppose that you already have gone through design tuning, SQL tuning and index tuning before deciding to investigate hardware upgrades.

Are you sure there is no place for finding the...

Service packs are cumulative, so I suppose you will have the same issues as upgrading to SP3 and then SP4.

Take what's in release notes of both SPs and that's your...

Use a maintenance plan, a custom backup script or Ola Hallengren's backup solution and schedule the backup with SQL Server Agent.

You will also have to schedule a file transfer task...

Here's an interesting set of articles from Erland Sommarskog's site:

http://www.sommarskog.se/arrays-in-sql.html

You're on SQL2008: why don't you use table valued parameters?

Maybe this can help you:

-- SETUP

IF OBJECT_ID('tempdb..#TMPTABLE') IS NOT NULL

DROP TABLE #TMPTABLE;

CREATE TABLE #TMPTABLE (

entity_item_id int PRIMARY KEY CLUSTERED,

...

I think you could start from Brad's Sure DBA checklist[/url].

It's impossible to suggest optimizations without seeing the code.

The part you have to rewrite without triggers is the one you left out and replace with comments:

/* lot of concatenation's and...

I think the old admin has that list.

Did you check this with him?

Duplicate post.

Replies here please.

Not sure. With...

cheshirefox (3/12/2012)

---

My apology for being unclear.

Technically - we have two data drives.

X: all database files (except TempDB) on a large drive residing on 4 FusionIO cards.

Y: TempDB residing on 2...

BTW, I found this interesting blog that describes how to move tempdb to a ram disk: http://sqlblog.com/blogs/paul_nielsen/archive/2010/02/15/tempdb-in-ram.aspx

Weird. Tempd would have been my first candidate for moving to FusionIO.

Is there any particular reason why you didn't put tempdb on FusionIO?

As per your question, theoretically you could create...

It is.

In fact, the first time you call it it's slightly slower than subsequent calls,...