Please add an alias to columns in the SELECT:

select ?.Orderid, min(?.TypeID) , min(?.CTType) , MIN(?.Area)

Otherwise we can't really rewrite any of the code.

What specifically does the data in the "Verdate" look like?

For example, is it 'yyyymmdd hh:mm'?

First properly tune the indexes, in particular getting the correct clustering index (hint: very often this means not clustering on an identity column). That is usually the single biggest...

Easiest way with accuracy to me is to run the code for each table create without producing any data, then script out the CREATE TABLE statement to copy into the...

Another possibility:

It also provides documentation of the FK relationships.

I suspect they wanted their application to be able to run on many different dbs. Some don't (or didn't) directly support...

Excellent! The other thing you need to include in your analysis is the "missing index" info from SQL (DMVs sys.dm_db_missing_index*).

sys.databases contains the owner of the db. That view is stored in the master db. ...

If you disable the clustered index, you've disabled the table, since the...

4 / 1172.0 is less than 1%, ~0.34%.

To show less than 1%, change your code to this:

CONVERT(DECIMAL(5, 2), (CAST(ProductionCnt.Count AS FLOAT)

- CAST(avgcnt.Count AS FLOAT))

/ CAST(avgcnt.Count AS FLOAT) * 100) AS...

>> Do I need to disable Index while loading data from Dev to staging ? <<

Can't say for sure without more details, but if it is a large % of...

Underlying code/logic:

SELECT

string,

--len(string), last_numeric_char, length_of_numeric,

SUBSTRING(string, last_numeric_char - length_of_numeric + 1, length_of_numeric)

FROM (

SELECT '123756zxfggr123456' AS string...

I believe the "EXECUTABLE FILE = " is supposed to be a file path to the executable, not the executable binary code itself.

You could create table(s) to hold info about changes that need done in the future.

Since these will be temporary/transition tables, you wouldn't need to spend a huge amount of time...

Lynn Pettis (4/8/2014)

---

ScottPletcher (4/8/2014)

---

Jeff Moden (4/7/2014)

---

ScottPletcher (4/7/2014)

---

If you really want to use a single table, you could use a single smallint or int column with a bit assigned to each...

Jeff Moden (4/7/2014)

---

ScottPletcher (4/7/2014)

---

If you really want to use a single table, you could use a single smallint or int column with a bit assigned to each newsletter. That...