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

If you're 100% sure that no group_id will ever be more than one type, then that looks OK.

You probably want to consider using an IDENTITY column to automatically assign one...

Interesting too is that an empty string does not work for decimal values:

SELECT 1.1+''

But it again does work for dates:

SELECT CAST('' as datetime)

Ah the wonders of SQL -- "wonder why...

44 out of 48 is definitely too high. Keep in mind that the OS needs some RAM to manage the RAM itself.

Assuming no other software using significant RAM is...

PiMané (12/18/2012)

---

ScottPletcher (12/17/2012)

---

Since you have to ALTER columns only one at a time (why, MS, why??), I'd create a new table and INSERT every row into it, converting every column...

Since you have to ALTER columns only one at a time (why, MS, why??), I'd create a new table and INSERT every row into it, converting every column at one...

sp_MSforeachdb is convenient, but it has huge overhead and is probably overkill for what you need.

You can use sp_executesql to return a value from dynamic SQL, albeit that it's not...

TheSQLGuru (12/16/2012)

---

My statement about making "queries" faster is about the ENTIRE process. The act of populating a temp table with an index already on the temp table before data...

If I understand correctly, maybe something like below.

[Btw, as a general performance guideline, make sure the datatype of the time in the table exactly matches your list of times. ...