I like SQLBits talks, because they are more conversational and don't use live demos. That works well for me, because I rip a lot of SQL Server related audio tracks...

GSquared (4/11/2016)

---

No...

First, to prevent this from happening again, take steps to insure that you are not restoring good data on top of faulty hardware, so run a disk subsystem diagnostic.

Going forward,...

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...