ChrisM@Work (8/9/2013)

---

One of the items (table sources) in your FROM list has two rows per single row in table Podrobnosti. Since there's no aggregation and all of the other tables...

One thing I didn't see anyone mention is size. An index is likely (not necessarily, of course) smaller than the table, so even in the worst case of a full...

I'm getting a little tired of all the jerkoffs who immediately jump in with comments like "You shouldn't be writing SQL code." Do you suppose anyone believes you were born...

GilaMonster (4/24/2013)

---

You can pretty much say it's the time that the backup completed, because unless you have some odd case where half the database changes during the backup, the data...

GilaMonster (4/23/2013)

---

No, I said 'close to the...

Lynn Pettis (4/23/2013)

---

pdanes (4/23/2013)

---

GilaMonster (4/23/2013)

---

pdanes (4/23/2013)

---

So a backup is a 'snapshot' from the moment in time that the backup process was initiated? And operations performed during the backup process do...

GilaMonster (4/23/2013)

---

No,...

GilaMonster (4/23/2013)

---

The same state they would be in if they were taken without a full/diff running

What does a transaction log...

opc.three (4/23/2013)

---

I agree with SQLBob in that I would never want to work for that person. Maybe someone can get this thread under their nose...maybe they'll listen to a chorus.

If...

Smart-assery aside,...

Doesn't matter what software you use - if you don't understand your data, or if you ask the wrong questions, you're going to get worthless results. Over and over I...

GilaMonster (4/18/2013)

---

Eric M Russell (4/18/2013)

---

Also, tell the candidate up front that all new hires are required to sign an "employment at-will" contract. If they don't measure up, then they'll just...

If some interviewer asked me to make him a PB&J, I'd tell him to throw my application in the trash, because I wasn't interested in working for such a clown...

Currently in the paleontology department's photo-laboratory, which is also the access path to the microscope lab. I'm the only permanent occupant, but almost everyone in the department wanders through here...

Slight hitch in the analogy - insurance payments cost something. Running DBCC checks costs nothing. What did this clown think he was saving by avoiding DBCC checks? A couple seconds...