john.arnott (7/20/2012)

---

Re: Myth that @Table variables are only in memory.

It never made sense to me that people would think that MS would develop an open-ended methodology to manage data in...

I suspect the MERGE time could be reduced by clustering on the ProductID, but with it being nvarchar(60), that's not particularly appealing.

If you can go to just varchar(60), and the...

>> ON (t.ProductID = s.ProductID) <<

So is ProductID...

hisakimatama (7/19/2012)

---

First, I could have a table with a row for each item, and columns for each month. ...

Alternatively, I could create a table for each month, and track sales...

You have to use DBCC SHRINKFILE to reduce a file below its initial allocation.

USE <your_db_name>

-- get the file#s / names of all the db's files

EXEC sp_helpfile

Then choose the file# or...

It provides continuous availability of the data, with no...

SELECT

[Database Name],

[Compression Ratio]

FROM (

SELECT

b.database_name 'Database Name',

...

Sounds like RCS (Read-Committed Snapshot) is what you need here.

takilroy (7/17/2012)

My intent is to see if anyone has been able to or knows of a way to create a global constant variable or use a sql function to determine...

I really think you're going to drive people crazy trying to follow this because no one else does it.

Almost universal is to use NULL to mean "no value was passed...

takilroy (7/17/2012)

---

Unfortunately, I can't use look up tables because a default value for a parameter MUST be a constant, meaning either a literal value or a @@ constant. So,...

Again, in theory yes.

But in the real world that's often difficult to do and takes a lot of time. And often a change later to the code by someone...

You can use a lookup table to store default/control values.

Or, less overhead but more obscure, you can store the default/control values in specific byte positions of CONTEXT_INFO.

I'm not familiar with MONTHS_BETWEEN, but IF it does always use 31 days as a "month" in that function, then you can get the same result from SQL Server using:

SELECT...

Michael Valentine Jones (7/16/2012)

---

ScottPletcher (7/16/2012)

---

SQLKnowItAll (7/16/2012)

---

ScottPletcher (7/16/2012)

---

CREATE...