bitbucket-25253 (7/7/2011)

---

The source cited has the following statement:

But, as it always is, how does one determine the number of soft NUMA nodes? ...

I'll stick it in the back of my mind and see if we can better group these together. Maybe a forum with all BI topics and then sub topics for...

Maintenance plans have worked for me in the past, but I like Ola's script as a more flexible solution.

Create the login, then the user. I would set the login default database to the one in which you create the user. The login will have connect rights.

Then grant your...

ditto. Just saw that come through.

Thanks, I think that was a forum post, so it's hard to screen those out, but I'll see what we can do.

First you need to connect locally as an administrator. Local Windows admins usually have default rights, or the account that installed Express.

to add other accounts, use CREATE LOGIN: http://msdn.microsoft.com/en-us/library/ms189751.aspx

Most books have some practice questions in there, but publishing any of the exam questions or very similar ones is a violation of the NDA.

My advice is to go...

The only feature difference is in StreamInsight, with the amount and latency of events you capture.

The rest is CPU, RAM, and licensing.

I was surprised, but a quick test shows that a diff actually does reset the log chain.

Note that I took a full in simple, then added rows, then switched to...

Belated congratulations.

I thought it was 1-2%, which Paul doesn't dispute here: http://www.sqlservercentral.com/Forums/Topic663009-266-1.aspx

I do agree with Gail. If you cannot tune the queries, analyze them and send back information and suggestions to...

My apologies for the delays in responding. This has gotten a little out of hand, and it's become an argument on advice rather than an answer to a question. I...

I wouldn't pay for a report, and there are numerous ones out there, as Leeland noted. I also always participate in salary surveys, mostly just to get a copy of...

TravisDBA (7/5/2011)

---

Good article Steve! When it comes to ethics, I think Mr. Price Pritchett said it best: "You can't put someone else in charge of your morals. Ethics is a...