I'm with Jeff. Just because you have change control and auditing in place doesn't mean you can't do your job. In fact, you can do your job better under that...

If you just take away the timestamp, as Jeff says, you can overwrite the backup. I'd suggest though, you should be nervous about doing that. If your backup fails during...

You could take a look at the sys.dm_exec_query_stats information. You can see the total_logical_reads for all executions of the query. Compare the output of the two, possibly using the number...

Evil Kraig F (11/14/2012)

---

Oh... EAV model... HOW I HATE YOU...

We're currently upgrading between versions on a piece of vendor software. Short version is they allow for end users to...

L' Eomot Inversé (10/29/2012)

---

WayneS (10/29/2012)

---

Geez Tom, that's quite a bit of stuff you went through - hope I never have to do something like this. Sure am glad that you...

SQLSACT (10/25/2012)

---

Grant Fritchey (10/23/2012)

---

There is a setting called 'Optimize for Ad Hoc Workload' that could help you out. Instead of storing a plan each time a query is run, the...

Yeah, I've seen that approach before too. It's supposed to make the code self-documenting or something. Any column can only ever be from one table. What a pain.

The basic design is quite simple. You have to create an interim table that has the primary key from patient and the primary key from pharmacy. That creates the many...

If you're truncating the entire database, how about setting it to restricted user prior to running the process? If you need to you can even rollback outstanding connections immediately (with...

Artoo22 (10/24/2012)

---

While attempting to reproduce this in another database I discovered the issue. My user table was created with ANSI PADDING off while the temp table I'm loading was created...

Scott D. Jacobson (10/24/2012)

---

Requirement 19 confirmed my suspicions. This is a team lead position. You need to understand and be able to do all these things b/c they...

The database size is allocated size, not data size. SQL Server, by design, maintains empty space within the data and log files in order to allow for growth of your...

Seriously, how many people on the planet have DTS experience with databases greater than 100tb? I mean, how many DBAs have experience at greater than 100tb, period, full stop? They...

<insert curse words here>

Do I also have to sweep the floors, clean the toilet and maintain the stock portfolio?

That's a rather insane list of requirements. They better be paying well...

Not sure. I'd need to see the query and XML execution plan.