Lynn Pettis (4/30/2010)

---

Steve Jones - Editor (4/30/2010)

---

Lynn,

I think it was OK. From a technical standpoint, it makes sense. The issue seems that some people don't understand log chaining, so things...

Steven James Gray (4/30/2010)

---

Fairly straightfoward - use mated ROW_NUMBER() rankings, one flowing forward and one flowing backward over the data. By taking the first record where the orders cross over,...

Here is a useful article on several different methods to calculate the median.

http://www.simple-talk.com/sql/t-sql-programming/median-workbench/

MANU-J. (4/30/2010)

---

But, when I run script posted by "Kenneth Langner Jr." On adventureworks database I get index_space_mb as [0.0781250] for [Sales].[Individual] table

whereas sp_spaceused returns index_size of [49928...

In reference to your blog. I was curious to find more info...

Lynn Pettis (4/30/2010)

---

Not like I threw a loop in though, like saying we truncate the t-log just before running the full backup. That would have changed the answer. ...

I was hoping to come up with a squeamish color, but this was the closest match I could...

Good to hear.

It seems appropriate to me (your method for changing the connection).

jcrawf02 (4/30/2010)

---

I knew you were, but you were being so conscientious about just posting real Threadliness, so figured I'd take...

To follow up what Grant said, do you have a way you can limit the results to be deleted? Add a range to the query or something that can...

Try this article.

Look at the tail log section.

Kenneth Langner Jr. (4/30/2010)

---

Here is one that I believe I got off of SSC

-- Create the temp table for further querying

CREATE TABLE #temp(

rec_idint IDENTITY (1, 1),

table_namevarchar(128),

nbr_of_rowsint,

data_spacedecimal(15,2),

index_spacedecimal(15,2),

total_sizedecimal(15,2),

percent_of_dbdecimal(15,12),

db_sizedecimal(15,2))

-- Get all tables, names,...

And I was so tempted to do that myself.

I suggest to find what is causing it to be that big. Gianluca proposed a solution. I'll propose another option - read this article[/url] and try it's suggestions

What is the status of the database?

In Recovery, Offline, Online?