Lynn Pettis (1/15/2013)

---

Okay, just curious. I had a phone interview a while back (about a year) and I am pretty sure I didn't get a call back because I...

No. I just expect them to know the DML verbs at least. The...

I'm mostly a production DBA. Keep 'em up, running and tuned. I'm also responsible for front line troubleshooting of our software, and database issues. I've done about 15 different DB...

The one thing I've done a lot is is created a scheduled task based off the sp_help_revlogin SP. It dumps the data to disk every 8 hours. Then...

I advertise myself as a production DBA. I can sit around and write T-SQL SP's...

I have found that once you get to a certain level, and you don't limit yourself to be strictly the DBA world, the unemployment worries drop off significantly.

I have a...

The nearest I could find to it is the blog item that was cited in the article.

But if you look at the dates on the blog it was probably in...

Do you have replication going?

This bug was also present...

Did you happen to note...

I know I'm late to the party -- I'm guessing that you have your database files on a netapp san unit.

I'm early on in this theory so take it with...

Well fortunately this is no longer my problem to solve. (No longer with the company.)

I went with a reprocess solution. I can't remember the exact, but I had it import...

There's no tool to either check which pages don't have checksums, or to put checksums on all pages - unfortunately.

I'm working on something that will do that - but it's...

I was able to install SQL Server 2005 Standard on my machine by using the cmd prompt.

runas /user:administrator "msiexec /i C:\MyPath\SQL_2005_Std_x64\DISC1\Setup\SqlRun_SQL.msi"

Sweet code.

On the

SELECT @a = (SELECT SUBSTRING(@a,1,LEN(@a)- 1))

--Trim off the final comma; I'm sure there is a better way to do this...

Why not just do a

SELECT...

I'm trying to use this in SQL 2005, and am running into an issue with the sp_MSforeach_worker. It is only setup to handle tables or databases.

if @worker_type=1

set @local_cursor = hCForEachDatabase

else

set...