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

todd 87764 (4/4/2014)

---

The table will continue to grow as there are no plans for archiving, which is why I am thinking about partitioning. There COULD be as many as...

EXEC sp_MSforeachtable '

IF EXISTS ( SELECT TOP (1) * FROM sys.columns

WHERE object_id(''?'') IS NOT NULL AND

name = ''SSMA_TimeStamp'')

BEGIN

PRINT ''Altering table "?" to remove column...