Server or database level?

here are a few items:

http://www.sqlservercentral.com/scripts/Security/62064/

http://www.sqlservercentral.com/scripts/Security/66129/

Had a funny one today. On the DLM webinar I did with Grant, we had a guy ask how to recover a master database and another one show an error...

rustman (4/28/2015)

---

It is amazing to me how people's career paths can be so different at times and then others are similar...I too started my IT career as a Novell Administrator...

Ralph Hightower (4/28/2015)

---

In the "Understand the True Source of Problems" article:

2 – NOLOCK is required on every query. It makes things run faster.

Instead READ_UNCOMMITTED is suggested.

At one place I worked...

Gary Varga (4/28/2015)

---

I am certain that as an industry that we reduce our productivity over the longer term due to ignoring root cause analysis or, sometimes more frustrating, ignoring the...

Notifications default to the last setting you posted with. It's a simple switch. You post, we use what you last choose. If you change it, we change it for the...

Ah, sorry. Missed that multiple times.

Fixed

Take it and submit something. would like to see something here.

define sales > 0. You have multiple years.

You can add a HAVING clause to the end. Read up on that.

Just a joke on the exercise for better...

Anything that uses a percent at the beginning (%yahoo%) is going to require a table scan of every value. No way around that.

Perhaps full text indexing could help, but really...

+1 for backup/restore

Main thing here is to test, test, test. I know it might be obvious, but you need to point your applications (as a test) to the test upgrade...

The other indexes can be more efficient with the int (or bigint) rather than an internal key for uniqueness.

I'm not sure at 70k (or 700k) that the PK is an...

I'm with Cunningham for a few reasons. I don't like adding things to system databases, especially when they could cause issues with MS upgrades/patches. I wouldn't expect new schemas, but...