No. Don't do that.

bwhiteside (9/3/2015)

---

Grant, I think you called it. It looks like the new cardinality estimator appears to be causing our queries to run much slower. We changed the compatibility mode to...

Eric M Russell (9/3/2015)

---

bwhiteside (9/3/2015)

---

Grant, I think you called it. It looks like the new cardinality estimator appears to be causing our queries to run much slower. We changed the...

You're saying that the SQL Server executable is using more memory than you...

RonKyle (9/3/2015)

---

I have done real, complex database development, both in...

There currently is no good way to handle this within SQL Server. Copy & paste is how most people do it. Now, you can make this work better, especially if...

Another vote for using Jeff's tally table method. It's going to work so much better.

I'm with Luis. The money data type seems attractive, but it just leads to headaches. Use decimals and keep going.

The only issue around that from a data standpoint is...

It's going to generate an error, but you can use sys.dm_sql_referenced_entities to look at the objects referenced by a given stored procedure. It will at least allow you the ability...

SQL Server will take every single gb of memory that you assign it. It won't release that memory unless forced. It's very normal for servers to run with high memory...

sqlfriends (9/2/2015)

---

Just notice this, you said transaction backup is fully independent even not on full backup? (except that one case you mention).

I thought we will always need a full...

Jeff Moden (9/2/2015)

---

Grant Fritchey (9/2/2015)

---

Lord Lucan. The Charge of the Light Brigade. The battle of...

Eric M Russell (9/2/2015)

---

We all just need to come to terms with the fact that application programmers have a need to locally persist things like shopping carts, messaging, or just...

Yeah, that a was kind of badly worded statement. Apologies.

What I meant was, treat every query as a separate entity rather than try to use what looks like, from a...

souLTower (9/2/2015)

---

To follow up, I ran some tests in SQL2008R2. The execution plan is cached. I performed similar test as those in the article by running queries against...