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 ? 😛

This appears to be functionally equilavent to how identity based identifiers work, only what you're doing is a lot more complicated and requires coding in every stored procedure that inserts....

Oracle, eat your heart out!

All you resellers on eBay can eat your little hearts out too. Ha!

http://www.bing.com/search?q=site%3Aebay.com+%22sql+server+2014%22+%22developer+edition

I'm not understanding the following. Is [GDML.eResults.UserStore] a database with an odd 3 part name containing periods, or is this a reference to a remotely linked database/table?

[GDML.eResults.UserStore].[dbo].[vw_aspnet_UserProfiles]