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

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 isn't necessarily a...

D'OH, sorry, quite right, here's a

CORRECTED script:

EXEC sp_MSforeachtable '

IF EXISTS ( SELECT * FROM sys.columns

WHERE object_id = OBJECT_ID(''?'') AND name = ''SSMA_TimeStamp'' )

BEGIN

PRINT ''Altering table...