I've seen fact tables in a star schema model with 20+ foreign keys. By default, foreign keys are not indexed, and nor should they generally speaking. Actually, there are cases...

Monthly SQL Server user group meetings are a good place for leads on permanent hire positions or contracts. If you're currently in the market for a new job and there...

When it comes to leveraging a new feature or adopting a new technique, whether that happens tomorrow or months down the road also depends on if I'm currently working on...

A database restore performs mass write operations to data and log files, so should we really expect dm_io_virtual_file_stats to be near zero after a restore?

Sean Lange (5/19/2014)

---

Eric M Russell (5/19/2014)

---

Maxer (5/18/2014)

---

A company I work with stores all HR data for all past and present employees in a table that has SSN, DOB, address, and...

Doctor Who 2 (5/19/2014)

---

This is the second time, in this thread, that the idea of hiring a recruiter has come up. (It may have been you, Eric, that brought it...

Maxer (5/18/2014)

---

A company I work with stores all HR data for all past and present employees in a table that has SSN, DOB, address, and full name.

This sort of sets...

Is is possible that an SSIS package or some other ETL process can be disabling the check constraints prior to loading tables?

Doctor Who 2 (5/19/2014)

---

OK, I'll drop the "accidental DBA" moniker from my public speaking; I'll just use it here on these forums.

What recruiters have people had the best experience with?...

Doctor Who 2 (5/19/2014)

---

Very relevant to me, now that I'm being downsized. I've got a fairly good idea what I'm worth, as a senior programmer analyst. But I've got no...

One reason why developers write cursor based SQL is because they're attempting to literally re-create the step by step looping and decision based logic of a workflow diagram. Often times...

Database engines don't execute T-SQL or PL/SQL; they compile to an execution plan and execute that. For example, in SQL Server two very different looking sql selects, one that references...

Sometimes a minor failure, more like a temporary set back, results in a re-evaluation of our career, and it is actually becomes the impetus for moving to the next level...

Most organizational employers expect data analysts to be subject matter experts with some background in SQL, and they expect DBAs to be database/network/ETL/Windows/Linux experts. An exception would be startups, who...

robert.diley (5/14/2014)

---

I do have a text in front of me: Fritchey, Grant (2012) SQL Server Execution Plans, 2nd ed.

From p. 88:

"we can discuss the Hash Match join operator.

It occurs when...