GilaMonster (8/9/2014)

---

Remember the optimiser is NEVER looking for the best plan, it's looking for a good plan fast. In one case if found a good plan that was actually crap,...

GilaMonster (8/9/2014)

---

Reordering of joins won't do a thing,...

Wait, when you say proxy, what exactly do you mean? Do you mean they setup a proxy on the server like in the node below?

If so, you set that...

It depends on your security expectations. Typically, a login from an application doesn't have read/write, they ONLY have execute permissions to procedures, and inherit what they need from the...

Regarding the Article, a thought provoking editorial, thanks for writing it.

Omission is always allowed (and legal) on a...

Nice article Perry. Simple and effective techniques. Thank you.

TheSQLGuru (8/8/2014)

---

Evil Kraig F (8/8/2014)

---

TheSQLGuru (8/7/2014)

---

I think this is slightly mis-stated Jeff. While you may not get fragmentation from end-of-index inserts, you certainly can get page LATCH contention, which...

TheSQLGuru (8/7/2014)

---

I think this is slightly mis-stated Jeff. While you may not get fragmentation from end-of-index inserts, you certainly can get page LATCH contention, which can be a significant...

I would recommend you start with something like this:

http://www.brianshowalter.com/calendar_tables

Just the first one that came up on google, and it looks reasonable.

Using a table like this you can filter, control, and...

Now now, not exactly a flame. 😛 Certainly not aimed at any one of the...

autoexcrement (8/8/2014)

---

If IT has set up a "Proxy Account" for me, how can I set up my SSIS package to use Windows Authentication but use that Proxy Account, instead of...

Currently working in finance, there's additional days you need to kick out, which are the holidays for the different markets. Assuming you're only working against NYSE, NASDAQ, and OTC,...

Does this help your concern?

SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL))

Phil Parkin (8/8/2014)

---

This behaviour (selecting from temp tables) changed in SSIS 2012. Rather than declaring dummy metadata in your proc, you should use the WITH RESULT SETS option when you...

bpowers (8/7/2014)

---

Attached is an image of our table. The LINE_CHANGE_DOC_NO is an identity column and the PO number is the primary key on the table we are tracking.

Here I...