Not that I am aware of, don't think that is possible.

Jeff Moden (8/30/2012)

---

Then you actually have a potentially serious problem. What do you want to do when adding the seconds takes you over 24...

Charles Hearn (8/30/2012)

---

I think dm_db_partition_stats is what you want. Change the index_id depending on if the table is clustered or a heap.

SELECT so.name,

ps.used_page_count * 8 AS UsedKB,

ps.reserved_page_count * 8...

Brandie Tarvin (8/30/2012)

---

The code I gave you should give you sizes that you can add together without having to add each of the columns, Lynn. It grabs all the info...

Brandie Tarvin (8/30/2012)

---

EDIT: Lynn, I see index and session and task related DMVs, but none actually related to seeing the size of a row. I assume you don't have access...

Brandie Tarvin (8/30/2012)

---

Information_schema.Columns has the datatypes and sizes. The code I use is below, but it won't give you sizes for bits, ints, etc. You have to remember the whole...

jcrawf02 (8/30/2012)

---

related unrelated issue, heard on the radio this morning that Chipotle and several other restaurants have been rounding bills to the nearest nickel (some up, some down) to avoid...

Brain dead, looking forward to a Labor Day Weekend trip to Prescott, AZ. Any help here is welcome.

Not a problem, just making it easier for others (and myself later, once...

Let's make this easier for others:

This...

CELKO (8/29/2012)

---

>> When running the script below I noticed that the two result fields [sic: columns are not fields] are of data type INTEGER. I would like to convert the...

GilaMonster (8/29/2012)

---

You have to take full backups regularly. Without a full backup, the log backups are useless and that database can't be restored if necesary (and no, mirroring doesn't make...

Some of us are just too old for the bar scene.

Not that much in there really and the following is the only error I see:

DBCC results for 'EXAMPLEUsers'.

Msg 2576, Level 16, State 1, Line 1

The Index Allocation Map (IAM) page...

Yes, you should take regularly scheduled full backups along with t-log backups. If no full backups have been taken since the mirror was established and t-log backups have been...