Both UserID and NTAccount should have a unique index. If UserID is clustered, then that should be the fastest access path.

Is MyColumn of type VarChar? Perhaps what they intended to do was convert NULL values to the string 'NULL'.

For example:

ISNULL(MyTable.MyColumn, 'NULL') AS MyColumn

This is how IT management sees it. 😛

'Cat Herders'

https://www.youtube.com/watch?v=m_MaJDK3VNE&feature=player_detailpage

Rent, home prices, property taxes, local sales tax, daily commute time: any large metropolitan city offers it all. Averaging and ranking a city based on it's aggregate whole may be...

I think what we're really talking about here is a Data Dictionary, which isn't a new concept. A good dictionary isn't an auto generated report of tables, columns, and objects;...

Eric M Russell (4/5/2016)

---

The following practices are almost always wrong.

1....

Depending on the context of how it's used, seeing how often it's diced and fudged with T-SQL functions, even the common DateTime type could be seen as non-atomic.

They're asking the wrong quesions.

Here are examples of questions that matter:

- How can you confirm that a query is using an index?

- What is the purpose of FILL FACTOR when...

Here is an example of an 'unrestricted' left outer join.

select *

from TableA

left outer join TableB on 1 = 1;

Rod at work (4/8/2016)

---

Eric M Russell (4/7/2016)

---

Lynn Pettis (4/7/2016)

---

Rod at work (4/7/2016)

---

Peter Schott (4/6/2016)

---

Rod, I did that very early on when I was just starting out. I ended up moving...

Hi, Phil, I believe the scenario you're referring to can best be summarized as CXPACKET blocking for teams.

Hugo Kornelis (4/7/2016)

---

Agreed with the advice on how to set permission, but the view definition needs to be improved:

...

(Changes made: Added column list, added schema to all object names to...

I always insert the parent row first, get @@IDENTITY into a variable or output parameter, and then use that ID to insert child rows. Getting ETL processing in that order...

Lynn Pettis (4/7/2016)

---

Rod at work (4/7/2016)

---

Peter Schott (4/6/2016)

---

Rod, I did that very early on when I was just starting out. I ended up moving without any idea if I'd find...

Why are folks still listing SSDE licenses for sale on eBay, when it can be downloaded for free ? 😛