LutzM (9/3/2014)

---

ScottPletcher (9/3/2014)

---

...

There are 3rd party solutions that do that, but they are rather expensive. At least one we investigated uses its own "black box" to hold the data...

If you want to verify the current setting, run this statement:

EXEC sp_configure 'max server memory'

CELKO (9/3/2014)

---

You doing everything wrong. Where is the DDL? That is minimal Netiquette in SQL forums. Is this all INTEGER math? I hope not! But that is what your coalesce...

SQL Server has a feature called computed columns that could be very useful here. Basically you can create a virtual column based on a computation, and it becomes effectively...

LutzM (9/3/2014)

---

One of the issues when using triggers to audit changes is the ability to disable the trigger, apply the change and re-enable the trigger.

Without any audit for DDL changes...

Triggers can capture the originating user as well if you provide that info to the trigger. This can be passed in several ways, including CONTEXT_INFO, APP_NAME or even a...

Agreed, there's no easy way to tell if an index has extra columns. You can use the missing index stats to get a feel for missing column(s) though. ...

Eirikur Eiriksson (8/29/2014)

---

Thank you Scott, Tom and Lynn, this was the discussion I wanted to get going in this context. The subject is far to dependent on the environment and...

Lynn Pettis (8/29/2014)

---

ScottPletcher (8/29/2014)

---

The page split / fragmentation concern is often overblown. Remember, one INSERT, but you may read the row 1000, 10K, 100K+(?) or more times. Particularly...

The page split / fragmentation concern is often overblown. Remember, one INSERT, but you may read the row 1000, 10K, 100K+(?) or more times. Particularly given the availability...

Eirikur Eiriksson (8/29/2014)

---

ScottPletcher (8/29/2014)

---

patrickmcginnis59 10839 (8/29/2014)

---

CELKO (8/22/2014)

---

I use the encoding that is being used. The IDENTITY property (not a column!)...

patrickmcginnis59 10839 (8/29/2014)

---

CELKO (8/22/2014)

---

I use the encoding that is being used. The IDENTITY property (not a column!) is the count...

amns (8/29/2014)

Instead of a datetime, if I cast a string with format 'yyyy-MM-dd',

will this cast always result in the correct date regardless the collation or other server parameters? (considering this...

j_depp_99 (8/29/2014)

---

thanks much for your response. Testing it now but not sure about the variable. What does this represent? ?

Msg 207, Level 16, State 1, Line 8

Invalid column name...

Something like below. I don't have test data, so haven't tested it yet.

Edit: The WHERE conditions on your original query caused the LEFT JOIN to become a de factor...