Fraggle (12/16/2008)

---

Now, my questions:

1) why is it the trace caused the timeout issues on both the 32 and 64 bit servers. I know that a profiler trace can cause...

I don't pay...

SELECT SUM(SomeColumn) FROM (

SELECT SomeColumn FROM TableA

UNION ALL

SELECT SomeColumn FROM TableB

UNION ALL

SELECT SomeColumn FROM TableC) sub

Don't do that. Logs are not optional components of the DB and that's a really fast way to...

These days around here that mostly seems to be BI and ScarePoint. Did I mention I'm...

I'm a consultant these days, so I have to know whatever the client wants.

Right now I'm trying to get by BI skills up to a level where I can...

May I suggest you start by reading the section on clusters and clustering in SQL 2008's Books Online?

extremenovice (12/16/2008)

---

OK i understand you, but can you answer this for me please. If when you do a restore like in my situation are the mdf & ldf files overwritten...

extremenovice (12/16/2008)

---

The last backup of the server was last night so if the mdf & ldf files were backed up for that db, then i would want to use those....

Well, if...

And if you want advice for performance, as you well know by now, we need the table definitions, the index definitions and, if on 2005 or higher, the execution plan...

Of the current DB, or of one of the backed up...

Depends on the disaster. If the log drive is accessible and SQL is running, you can.

HOW...

Did you restore over the existing database, or alongside?

Did you make copies of the old mdf and ldf before the restore?

To demonstrate:

Create table #Errors (id int primary key)

set nocount on

go

-- testing pk violation

insert into #Errors values(1)

insert into #Errors values(1)

print 'pk error thrown'

go

-- testing conversion

insert into #Errors values ('abc')

print 'conversion error...