GilaMonster (9/28/2012)

It was Paul Randal, not Kimberly, and he did not say they were random numbers, he said they were rough guidelines that he made up based on his knowledge...

Gail can correct me if I'm wrong.

But unless your Index is static and insertions happens at the end, altering FILL factor will do little or nothing in performance gain or...

There is no "magic number" for fill factor, as it depends of your Index and table's activity. If the Index is static, I would recommend leaving default fill factor. If...

You're right!

I'll take a look this morning and fix ...

What I got so far ...

SELECT request_session_id,

DB_NAME(resource_database_id) AS DatabaseName,

COUNT(*) AS TotalLocksPerType,

request_mode,

...

Thanks!

That's clarifies the db lock or zero there.

I am almost there. Once done, I will post it, maybe it can help someone else ...

Thanks for reply.

Yeah, I've spent almost the whole morning trying to write it for "rows".

Got this so far ...

CASE

WHEN...

Perry Whittle (9/19/2012)

---

How do you know? Unless you force reindex you could end up reorging some indexes and this...

This database has been running without jobs for years. And before you ask ... no, I was not the DBA before ... 🙂

-I am using smart ReIndex (Ola Hallengren solution)

-The...

Hi Paul,

1st, thanks for reply.

I'm afraid I...

It took 4hrs to complete ... but no errors ...

CHECKDB found 0 allocation errors and 0 consistency errors in database xxxxxx

I guess that next (and last step) is creating a...

Well,

I restored the database on a different server and same MS-SOL flavor (or almost) but it's the best I can do, I have no more available servers and space for...

MysteryJimbo (9/11/2012)

---

Mirroring has an processing overhead on the principle server which can, and does, have a performance impact on high TPS servers. I've seen it and discounted this technology...

wb.spiekerdoyle (9/11/2012)

---

Thanks everyone for the replys, I am looking at all these options!

In regards to recreating logins and resetting SIDs:

All the logins and service accounts are using domain accounts. I...

MysteryJimbo (9/11/2012)

---

This is why logshipping is a better method of migrating/update database server as there are no restrictions. Logshipping is also guaranteed not to have an impact on the...