Are you putting partitions in their own filegroup? If so, wouldn't you query the data size in the filegroup v filegroup size?

Jeff Moden (10/7/2015)

---

My problem with "new and improved" software is that the software vendor frequently decides to no longer support features that are actually incredibly useful. To wit, it...

Alex Gay (10/7/2015)

---

I used to work for a hospital that had a clinical letters system written in Clipper, for an XBase file based database, that was 15-20 years old when...

BrainDonor (10/5/2015)

---

At SQL Pass there's usually an SSC night. I'm certain I saw mention of it somewhere but can't find it again.

Could somebody tell me which night it is?...

I'm not sure what you want with a feature like this. You don't have this now. You have to build it, and ensure it works, and debug it. There are...

Depends on SQL version. In earlier versions, you couldn't compress and encrypt...

Grrrr, tried to swap out me TE who was ruled out in the am, but all players were set to waivers. Annoying I can't pick up an open player on...

billp 37934 (10/5/2015)

---

I'm with Jeff on the header saying what the SQL is supposed to do. When debugging if a header says what it's supposed to do and the...

SQLRNNR (10/2/2015)

---

Brandie Tarvin (10/2/2015)

---

I found this StackOverflow article. Does it help?

DBCC SQLPERF('sys.dmv_name_here',CLEAR);

--EDIT: And then this if clearing plan cache too

DBCC...

WayneS (10/2/2015)

---

It seems that this would be a good time to explore locking down the production environment. Ideally, developers have no need to access production. They might need periodic access...

brad_bowzer (10/2/2015)

---

I wrote a system in MS access in 1993 and upsized it to SQL Server in 1996. Its been updated constantly but the core is much the same...

Iwas Bornready (9/30/2015)

---

I develop code in a fashion similar to what you have stated. I also find that expectations change as we develop, especially when we start showing the results...

Iwas Bornready (10/1/2015)

---

It sounds good, and may be good. It certainly must be for you. But I have a set amount of work that needs to get done. How do...

Brad Allison (10/1/2015)

---

This is great advice that I will share with my small team of SQL Server developers I work with. I usually give them some daily technical inspiration...

Tepluken (10/1/2015)

---

Terrific advice. I always take a walk at the end of the day. Usually I will listen to a podcast as I walk to pass the time; however once...