We have a forum topic for job posters and a service on the left (SQL Jobs) for jobs.

Topic moved.

Not sure what you mean? Can you run the proc from SSMS/SQLCMD?

You should be doing log backups as well. If you aren't, then you aren't going to have recovery between full backups. I'd add in a full a day or at...

The way this works, is a new table is created, the data copied, the old one dropped, and the new one renamed.

It doesn't matter which GUI you use, this is...

How are you retrieving the data? If you select the data, SQL Server returns all of it, but the client application may only show part of it.

In SSMS there are...

Turn off the machine?

I guess you could just convert the physical to a VM, save it off somewhere on tape? Maybe the same thing for the db?

That's very true. Many HR departments buy surveys and use those titles to set ranges.

Maybe that's what you should do? Look for a good paying title and lobby for it!

And...

Sometimes it's cheaper. Other times it means hiring a consultant or another job for one of us.

Look at those "mistakes" as opportunities, and it won't seem so bad.

Gail,

I'd be interested to know which one you pick. I looked at an O'Reilly one and went through it in 2000/2001, but then got distracted with some VB.NET. Would like...

Good catch, I'll enable that one and XLSX now.

I'll paraphrase my buddy, Andy, who reminded me of his core tenet a week ago.

Go with the defaults until you have a reason not to.

Normalizing should be a default.

Great comments and like many of you, I fell into this job. I was a network admin, a CNE in a Novell environment and we got a SQL Server. It...

Just got back from 3 days of "vacation" at Scout camp with my two little kids. After some bad food, lots of sun, and sleeping on the ground, I need...

I think this is a great idea, and it's similar to one I've used to email myself DBA reports every day.

xp_sendmail has worked fine for me for years. And very...

If you read the internals books or dig into BOL, there are pages inside SQL Server that create a map for all allocations. Just as pages have a map of...