Tested / Worked with = Yes

Wow...

Two things

1) Never use Cursors! Looping through a temp table takes less overhead than a Cursor; especially when you are working on a 24/7/365 server where you really need...

Also, when you say "Imagine scaling the cursor to tables with millions of rows". I'm imagining it! Are you sure that inserting the rows into a temporary table with no...

Lavish paychecks?! Man am I in the wrong company...

I think what makes a good programer is someone who is always willing to learn new processes and new technology. I'm a...

On the flip side, it will make the users more aware of the implications of hosing their laptops.

To most users that have a laptop given to them by my...

I have been rebuilding our HR database and I need a way to keep legacy information (i.e. Staff, Office Locations, etc...). I decided that a trigger was the best way...

Not only do I do database development but I also code applications as well. I usualy throw on a datatype for a quick mental reference when coding and also I...

I do use "_" in stored procedure names but I prefice the name with the database (I know another abvr coming up).

So my Stored Procedure for pulling information from the...

I don't have the time to read 101 posts and I'm sure someone else has mentioned some of the things I'm going to say.

I don't agree with the naming convention...

For those of you who do not understand the dog reference (I’m not going to read 58 posts to see if some one else explained it) it is an...

She wasn't canned for her beliefs; she was canned for putting her beliefs into company reports.

What if the reports were for Muslims, Jewish people, or atheist?

If...

Me too... (and I know a lot of them)

I normally don't post that often (being a one man show at work I don't always have time to read SqlServerCentral.com everyday, let alone post), but I think I need...

A variation of Sam's:

SELECT TOP 100 PERCENT [rowid]

FROM [tableA]

WHERE [rowid] NOT IN (

SELECT TOP 100 PERCENT [rowid]

FROM [tableB]

)

ORDER BY [rowid]

Here is where I am at with PK, FK and AK (Alternate Keys / Indexes), every table needs a PK, period. I don't care how small the table is or...