Steve Jones - SSC Editor (9/21/2012)

---

If you central server is down, where is the data on backups? If your package has a bug, or can't connect to an instance, what...

Hi Chris,

Here is my attempt doing this with a rCTE

;WITH retained AS (

SELECT t.retained, dropped

FROM testing t

WHERE NOT EXISTS (SELECT 1 FROM testing i WHERE i.dropped = t.retained)

UNION ALL

SELECT b.retained,...

Thanks Chris,

I'm looking at recursive CTEs but I don't think it will work. Well I've been trying for the last couple of hours and it's still not giving the same...

True... Based on the original sample data it does look like it would work based on maximum id.

See my previous reply to ChrisM.

As I said, I have a working solution...

Hi Chris, not quite! It's a looong story lol .......

Lynne's solution works if we assume that the retained ID is always the maximum.

But tthe solution doesn't work with the following record set:

drop table dbo.testing

create table dbo.testing (retained int,...

Nicely done Lynn,

I started doing the CTE but you beat me to it.....

Much appreciated!

Here is a quick example of how moving the filter from the join to the WHERE clause can have an effect on the result of your queries (if you're using...

as I said, this one question could last an entire interview.... it all depends on how nasty the interviewer wants to be!

I'm sure some expert will come along now and...

Thanks for the advice Steve. Please see my comments below:

The way I've done this is I have every server monitor itself. Make a small db (worst case, stick some tables...

Well I might get shot down for this but here goes nothing.

I'm no expert.. but if someone tells me a database is slow, I would want to check the machine...

Grant Fritchey (9/21/2012)

---

Abu Dina (9/21/2012)

---

You get a phone call from one the users. They tell you the database is slow. What do you do?

You answer that reasonably well, you're hired....

You get a phone call from one the users. They tell you the database is slow. What do you do?

You answer that reasonably well, you're hired. You start talking junk,...

Google DBCC SHRINKFILE

Yvan Bouchard (9/19/2012)

---

You have many ways:

Initiallly, you can run the Import Data wizard in SQL which will build and run an SSIS package to import the Access data into SQL,...