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

It's nice that we have cloud computing and database providers that are guaranteeing 99.9% uptime, but who has an internet service provider that can guarantee the same?

Soon the morning news...

patrickmcginnis59 10839 (5/13/2014)

---

I know next to nothing about the technical implementation or bitcoin or even how it work conceptually, but relational databases typically use unique key constraints to prevent events...

patrickmcginnis59 10839 (5/13/2014)

---

Gary Varga (5/13/2014)

---

Steve Jones - SSC Editor (5/12/2014)

---

Gary Varga (5/12/2014)

---

There are but have been deemed too expensive and unnecessary for what NOSQL was originally intended for. Basically, it...