I just lit a candle :w00t:

Brandie Tarvin (10/19/2010)

---

Stefan Krzywicki (10/18/2010)

---

Which is great and correct for light, but pigment is exactly the opposite. White is an absence of all pigment, black is a combination of all...

That timeline was indeed overwelming in "An Inconvenient Truth"

David Burrows (10/19/2010)

---

Wow! All these negative vibes :pinch:

I come in this morning and the thread has gone serious :angry:

Now I have to find a dark room to lay down and...

Alvin Ramard (10/18/2010)

---

I'd rather it be mauve. ...

This situation is already reality for 2 years and counting 😉

other options are:

- cope with it

- wait for an occasion

- accept you can only do as much as you can....

- Start with SQLServer upgrade advisor ( http://www.microsoft.com/downloads/en/details.aspx?FamilyId=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852&displaylang=en )

- prepare for security impact, try to optimize service account setup and implement best practises.

- 64-bit is only a other version of...

HowardW (10/15/2010)

---

ALZDBA (10/15/2010)

---

btw not so long ago, I had a bird strike whilest riding my bike. It hit me on top of my helmet, right above the vizor. It was...

WayneS (10/16/2010)

---

I just read through this thread, and what I found interesting was what was missing (or, I just failed to see it...)

The keys in a clustered index are used...

did you check your firewall is open for this port number ?

By default, sqlserver will fill pages to 100%.

You can change this default behaviour using sp_configure 'fill factor', ...

This is an advanced setting.

ref: http://msdn.microsoft.com/en-us/library/aa196711%28SQL.80%29.aspx

If you have the space available, and 85%...

ss-457805 (10/16/2010)

---

Correction: you're doing 4 PK clustered index scans (aka table scan) on the LEISTUNGSPREISE table, each time on a different column (KONTO_BUCH, KONTO_STEUER_PROV, KONTO_PROV and KONTO_STEUER_VK). It seems that...

Predictability can be an issue when using a uniqueidentifier for clustering key.

They (ms) provided the new "new sequential id" to help with that, so when you start inserting a bunch...

- Did you run the upgrade advisor ?

- do you run dbcc checkdb on a regular basis, so you know your dbs pages are in good shape.

- did you run...

It is a good thing you posted the sqlplan :w00t:

Did you notice you are hitting 31 objects with this simple delete statement ?

Table [LEISTUNGSPREISE] is accessed using a clustered...