Gazareth has it right. The space available does NOT include the LDF / Log file space. If you add up the space available + space used results for...

Brandie,

I've always divided by 1024 when going from KB to MB.

I just tried your query against one of my DBs, replacing:

(FILEPROPERTY(a.name,'SpaceUsed') * 8) / 128.0000 AS MBSpaceUsed,

with

(FILEPROPERTY(a.name,'SpaceUsed') * 8) /...

7474 pages currently, according to sys.dm_db_index_physical_stats. The...

GilaMonster (2/10/2014)

---

How big is the table?

If I select the PK column only, then select again with an order by the PK column, both selects will return the same values in...

WELCOME BACK!

:w00t:

Luis Cazares (2/7/2014)

---

jasona.work (2/7/2014)

---

Knut Boehnert (2/7/2014)

---

"How would you fill a coffee cup in T-SQL?" There is no straight right answer, more of a way of showing how the interviewee thinks...

Grant Fritchey (2/7/2014)

---

SQLRNNR (2/7/2014)

---

jasona.work (2/7/2014)

---

SQLRNNR (2/7/2014)

---

Kinky??

Um no. Just got back from SQLCruise with...

SQLRNNR (2/7/2014)

---

Kinky??

Um no. Just got back from SQLCruise with Grant and nobody wants...

GilaMonster (2/7/2014)

---

jasona.work (2/7/2014)

---

Is it in any way, shape, or form, possible to have a functional SQL database, with its log file in an offline state. Could you somehow read...

So, I have to ask a really, really, really dumb question, that I'm 99.99999% sure I know the answer too...

Is it in any way, shape, or form, possible to have...

/Using my best George Takei imitation

Ooh My...

😉

Koen Verbeeck (2/7/2014)

---

Jeff Moden (2/7/2014)

---

Koen Verbeeck (2/6/2014)

---

Steve Jones - SSC Editor (2/6/2014)

---

However, this way they can give feedback that something worked. We are talking about how to best get other...

Knut Boehnert (2/7/2014)

---

"How would you fill a coffee cup in T-SQL?" There is no straight right answer, more of a way of showing how the interviewee thinks and tackles a...

Steve - Yes, that would be sufficient for what I'm looking for...

And Sean - THANK YOU! I'll tweak what you gave me to return the columns I need /...

Jeff Moden (1/25/2014)

---

Shifting gears a bit, I've seen a trend starting to develop that will define the next wave of performance and memory problems. Even some people that I...