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...

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 both tempdb mdf...

The first query does a JOIN;...

Don't see anything magical to let you get rid of any of the lookup joins :-).

There typically won't be, so all you can do is tune the lookups as much...

If you do need a prefix (and/or suffix), you can do this:

CREATE TABLE dbo.tablename (

prefix char(3) DEFAULT 'ABC',

ident int IDENTITY(1, 1) NOT...

I would still like further info on the indexes. Please post the results of this query run from that db (a subset of what I use to analyze index...

string_column LIKE '%''%'

or:

CHARINDEX('''', string_column) > 0

Yes.

Typically a LEFT OUTER JOIN is used for that.

Say you're inserting names and want to avoid inserting one that's already in the table:

INSERT INTO dbo.names_table ( name )

SELECT wt.name

FROM dbo.work_table...