Sean Lange (12/28/2012)

---

Joe I certainly understand your position but I do have a question. You continually refer to Cindy Lou Who as employee #42. In a Joe Celko database what...

Agreed....

SQLRNNR (12/26/2012)

---

stakes (2/28/2011)

---

Hi all,

I have a 1T, high I/O database in a SAN environment on which I have planned the database files this way:

L: logfile (8k)

M: mdf file (64k)

N: ndf...

Btw, the column data types are not stored in my documentation tables -- I retrieve them at gen time from system views. This adds a little overhead, but insures...

Again, if you've got unlimited funds, definitely go RAID10 (or SSD) throughout, but because of the better resiliency, even if pure reads are somewhat slower.

Presumably all of us have done...

Used .rtf instead.

The hyperlinks don't work, but it still gives you the flavor.

The underlying html is generated from a table that contains the text documentation.

I'm still working to fully extended...

Sean Lange (12/26/2012)

---

ScottPletcher (12/26/2012)

---

Sean Lange (12/26/2012)

---

ScottPletcher (12/26/2012)

---

Sean Lange (12/26/2012)

---

SQL_Kills (12/26/2012)

---

Hi,

First of all I hope everyone has had a good Christmas!

Just wanted to know if anyone documents there table using...

Sean Lange (12/26/2012)

---

ScottPletcher (12/26/2012)

---

Sean Lange (12/26/2012)

---

SQL_Kills (12/26/2012)

---

Hi,

First of all I hope everyone has had a good Christmas!

Just wanted to know if anyone documents there table using MS_Description? I'm struggling...

It really looks like the column is "char(11)" and not "varchar(11)".

Can you verify the column's data type?

Sean Lange (12/26/2012)

---

SQL_Kills (12/26/2012)

---

Hi,

First of all I hope everyone has had a good Christmas!

Just wanted to know if anyone documents there table using MS_Description? I'm struggling to think how...

Lynn Pettis (12/25/2012)

---

ScottPletcher (12/25/2012)

---

Lynn Pettis (12/24/2012)

---

ScottPletcher (12/24/2012)

---

You also need to verify that the log LUNs are RAID10 and the data LUNs are RAID5 (typically that is the best performance).

If you're...

Lynn Pettis (12/24/2012)

---

ScottPletcher (12/24/2012)

---

You also need to verify that the log LUNs are RAID10 and the data LUNs are RAID5 (typically that is the best performance).

If you're going to put...

SSRS will automatically properly expand an "IN (@multi_valued_report_parameter)" if it's in an SSRS dataset and follows some basic rules. You may want to verify that you have a proper...

SELECT

CAST(DATEDIFF(SECOND, Start.WorkQueueStartWorkDate, Finish.WorkQueueEndWorkDate) / 3600 AS varchar(3)) +

RIGHT(CONVERT(char(8), Finish.WorkQueueEndWorkDate - Start.WorkQueueStartWorkDate, 8), 6)

from (

select CAST('20121216 20:57:01.293' AS...

Let's assume you can get all that information.

You have conflicting needs: you don't want to slow down the login process, but you also don't want to store full string descriptions...