These sound like interview questions. A few hints.

1. you need to know what the process name is, it's in Books Online, and then you query for the processes running in...

You don't log into management studio. It is just an application that connects to SQL Server. The password depends on which instance you are connecting to.

The version of SSMS v...

If you have restored master from backup, you should not need to rebuild it.

One trick that might work, not sure since you havent' provided much info, is to use the "Go trick".

Have smaller cross joins, or variable ones, each one that handles a...

Two things.

1. Add notes/comments in your template to make sure you do xxx.

2. In your job, run this off of a table. So join with tables, use a cursor, whatever...

The backups are needed if you need to recover to a point in time between the full backups. If you do a full backup at midnight each day, and your...

Is this short term burnout or long term? Meaning is this a few days or weeks of a tough project or are you questioning the entire job/career?

If it's the former,...

The scrolling is a little strange since it seems to give you scroll bars when you're close to needing them, but don't necessarily need them.

I have 3.6.4 and some windows...

I'm not sure why someone woud vote this down if they knew this technique. Are you saying that all articles about things "you" know shouldn't be written? I asked Jeff...

ejoell 66477 (11/15/2010)

---

IE would not permit horizontal scrolling to display either of your queries so I have no idea of what you are proposing. Shame too as I was...

I guess I consider PASS to be 4 days. Pre-con/arrival and 3 days. The Rally is 3 days, one pre-con, 2days of sessions. I have tended to find that I...

I think Jay raises good points, and those are my concerns. There are lots of stuff to worry about with cars, even when they are all automated. We have deer...

Heard from Barry. He's fine, just busy.

Not sure if I'll go to the SQL Rally myself. The longer format is both good and bad for me. If I go, I'll likely be a Red Gate sponsor,...

Doh! Thanks, Pam

SQL Search (free): http://www.red-gate.com/products/SQL_Search/index.htm