Sounds like you're trying to make it smaller than you have data in it. You can't do that.

That's for executing prepared statements. Different than sp_executesql because the prepared statements...

I wasn't aware there was one. Someone offered an opinion. You disagreed. Others disagreed with you. Etc.

Where was anyone shutting you...

Or, assuming you can get it in a delimited fashion, using Jeff's Tally Table methods [/url]to turn that into a derived table that you can then JOIN on.

The choice for an ad hoc query, a parameterized query, stored procedure, or sp_executesql are not made internally by SQL Server. They're all made by the application. There's nothing in...

patrickmcginnis59 10839 (7/30/2014)

---

Grant Fritchey (7/30/2014)

---

patrickmcginnis59 10839 (7/30/2014)

---

Its sort of a free market thing, if people decide that SO/SE isn't useful, it could go away. I'm hoping it sticks around because...

patrickmcginnis59 10839 (7/30/2014)

---

Its sort of a free market thing, if people decide that SO/SE isn't useful, it could go away. I'm hoping it sticks around because it is really useful...

Sean Lange (7/30/2014)

---

Grant Fritchey (7/30/2014)

---

Oh how I regret not making my original comment less absolute. :w00t:

I would never suggest we denormalize our structures in most normal situations for many...

Koen Verbeeck (7/30/2014)

---

Grant Fritchey (7/30/2014)

---

Koen Verbeeck (7/29/2014)

---

Grant Fritchey (7/29/2014)

---

As long as we're talking about straight T-SQL commands, you should be fine. If you start trying to access objects directly through...

SQLRNNR (7/30/2014)

---

I'm going to throw one more datatype thing out there.

The use of GUIDs as your Clustered Index will COST you plenty of space. Changing the clustered index...

I want to let this go, but I just can't.

No. Not true.

Everything, everything, within a structured storage engine comes with trade-offs...

Pretty sure the key word there is VIEW, but we could also add STATE. Same thing with VIEW DATABASE STATE.

Koen's excellent recommendations on compression are really the only way to reduce the size of data stored other than deleting the data.

Your other options are to try to tweak...

It could just be that your statistics were out of date on the old tables and the new tables, with more up to date statistics, are generating new execution plans....

While I'm sure some of the people here on SSC can help, I would strongly recommend that all licensing questions go directly to Microsoft. Regardless of what some person on...