Performance Monitor is traditionally the place to get this kind of information. You can look at the counter Database:Transactions/Sec:DBName to get the transactions/sec for any given database or use the...

jcrawf02 (7/24/2009)

---

That you have better...

Jack Corbett (7/24/2009)

---

The Mad Scientist Club, fantastic! I had those books and forgot. Will be checking to see if the local library has them for my kids! ...

ankur_libra (7/24/2009)

---

Thanks Grant and Allen for your valuable responses.

Does it mean Clustered index created on Primary Key is same as Unique Clustered Index?

Also it is said: PRIMARY KEY constraints create...

The day pack my wife carries from them...

One of many attributes that combine to make me "scary."

What size laptop did you get into it? I've got my 17" laptop in...

Oh, right. I keep forgetting the MS finally got smart. I'm so used to having to pull that access...

Because even if you change the recovery model for master, it's still going to behave as if it's in simple mode, by design.

Why are you trying to get log backups...

That more or less describes it, yes. You also know that execution plans can age out of cache and then need to be compiled again, right? Or that certain actions...

It's pretty straight forward. They're both clustered indexes, with all that entails. One has a constraint that only allows unique values into the column or columns that make up it's...

Yeah, that's from SQL Prompt. The Snippets function will do a bunch of work for you. Type cci and hit return.

It fills out all the code needed for making a...

If you're returning rows of data, just use a result set. But if you're returning a single row with only a few columns, output parameters are faster. It requires less...

Unless you've changed the default security on the machine (a good idea to do), you should be able to access the instance by being added to the local admin group...

In terms of security, you shouldn't have any concerns, assuming you properly wall off the IIS server. Performance could be a serious issue, depending on how much memory and processor...