Good pickup I guess. Anyone to replace the aptly named...

ha, love it.

At the very least it is a resume bullet point.

Because in simple recovery SQL Server truncates the log whenever it reaches a checkpoint, which makes the transactions go away.

If you want to backup the log, switch to full or...

Whoa... what? Reflecting on the article, what intrigued me the most was the statement that you managed a nightclub.

Very interesting.

Yeah, I kept up with the series through sportscenter. Wasn't all that interested in the details of the game.

Grats to the Cards, they played hard and came back and...

Changing the ID of a row can be a dangerous thing so I have a few questions first.

What's your goal in doing this? Why does it matter if the IDs...

When a drive craps out on you, there's always a possibility a database can become corrupt. If you are able to hot-swap the drive successfully, there's nothing needed to be...

Sean Lange (10/28/2011)

And just for the record a bit is NOT a boolean. It has 3 possible values (0, 1, null). Something to keep in mind when writing your trigger...

Alright, since no one has mentioned it I'm going to throw it out there for consideration.

Index rebuilds in full recovery are fully logged. Because of this, the index may be...

I'm not sure what you want here. So I'll just guess and look for clarification.

Yes, you can use a bit data type in SQL Server. This will allow 1/0...

An alternative would be to just script the jobs. Make sure the Object Explorer Details window is open (f7), navigate SQL Server Agent > Jobs.

Select all the jobs you...

Hello,

I assume by "optimize" you mean maintain. By "maintain" I mean reorganize/rebuild to remove fragmentation from the indexes.

You can't really manage the index without effecting performance of the instance. Your...

lol, great answer!

I'd...

I was also thinking about backup solutions. Perhaps, depending on environment, a slightly more important topic would be security. Who has access to the server, who has access to the...

Currently named Addln which makes me think of Aladin. Since you don't know what is going to be in the database, Aladin makes me think of a genie in a...