CirquedeSQLeil (10/5/2010)

---

select

database_name = DB.name

,sum( MF. /131072.) as 'Gig'

...

Double post, sorry.

See the link in my sig for help with optimizations. We need a lot of your DDL to help you here.

At first glance, I can imagine those count structures...

ricardo_chicas (10/5/2010)

---

Hello all,

I was dealing with some blocked sessions and I wonder if there is a way to know exactly what object is being blocked, I know how to get...

GilaMonster (10/5/2010)

---

Craig Farrell (10/5/2010)

---

GilaMonster (10/5/2010)

---

Alvin Ramard (10/5/2010)

---

That's the opposite of:

Q: How do you put an elephant in...

:w00t: Seconded! Alright, someone get in there and do a...

GilaMonster (10/5/2010)

---

Alvin Ramard (10/5/2010)

---

That's the opposite of:

Q: How do you put an elephant in a refrigerator?

A: Open...

The reason for the highly variable results is the industry your in can, and will, change the auditing level and specific controls you might run into.

Example: One place I...

SuzDBA (10/5/2010)

---

Thanks so much. One thing I didn't think about was memory and it should have been my first thought. This server has rebooted on it's own with...

Direct script, no, but this will help with the across the server bit:

sp_MSforeachDB

http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm

You can run the same script across all db's...

GilaMonster (10/5/2010)

---

Craig Farrell (10/5/2010)

---

I got it right, but a question regarding dedicated extents. I know page splits will happen, etc etc, but does an extent stay compact for a...

Hrm. So, dedicated box, dedicated drives, no failures and all RAID 10. You've reindexed, defragged, and anything else that be causing physical churn.

You're getting spotty results between the...

I got it right, but a question regarding dedicated extents. I know page splits will happen, etc etc, but does an extent stay compact for a range of data,...

I'd still be leaning towards a drive problem. What kind of arrays are they, and do you have a drive failure if they're RAID 5?

loki1049 (10/5/2010)

---

WayneS (10/4/2010)

---

SELECT EmployeeID,

DataYear,

YearlyWage,

FiveYearWage = (SELECT SUM(YearlyWage)...