Sorry to hear it. I love big dogs. We have an 80lb German Shephard, Maximus. He's a...

Don't worry Roy, I've got your back. I can't stand cats either.

I suspect you're seeing parameter sniffing (do a search on that term for possible solutions). I'm saying this based on the fact that you see this: '[woon_ptc]=[@P1]' in the first...

If it expires, it usually means it can get overwritten or removed by the backup process, so you might want to watch for that. The real question is, how often...

I didn't even read what he said...

You don't suppose it's our favorite emmveepee that was so desperate to convince us all that we...

Pradyothana Shastry (5/27/2009)

---

Adding more disk space is one better option. If you want to keep dialy one day backup then better option is 'With copy_only' so that it will overwrite...

GilaMonster (5/28/2009)

---

Or posting bad advice (truncate tran...

Each transaction log backup gets all the logged operations to...

Different companies are going to define that in different ways. Where I work a senior database developer will be able to design databases based on requirements, develop t-sql, troubleshoot performance,...

Is the automated job running more often than you used to run the backups manually? If so, that would explain the difference.

Logs and log backups don't have anything to do with the data file groups. If the third group is read only, then no log activity will be recorded against it....

There is no SELECT trigger. The best way is what you already have planned, collect the data through a server-side trace (which you can use Profiler to set up). Depending...

Attention to detail.

Which server are you connected to? You might want to know before you run that drop table command.

Does this UPDATE query have a WHERE clause? Be sure before...

Right, all this echoing is starting to get creepy. You can stop now.

And because I can...

10 bottles of beer on the wall, 10 bottles of beer...