My suggestion is to not use maintenance plans. What do they do for you, besides cause headaches? 🙂 Create your own job with the proper steps as scripts. Then you...

Nevermind... http://support.microsoft.com/kb/2926699

Lynn Pettis (4/30/2014)

---

SQLKnowItAll (2/18/2014)

---

We are looking for a very knowledgeable mid-level DBA for a company in Westchester, IL. Knowledgeable means strong t-sql, knowledge of DMVs, Extended Events, and knowledge of...

I think that no matter what you use, a DBA "could" get around it if they have SA.

First, make sure this database is not involved in any cross-database or distributed transactions. They are not supported with AO. Have you thought about doing a geo-cluster? We are currently...

There has to be some political or architecture change involved here. There cannot possibly be any cost savings now (if there were any to begin with) because the man hours...

ramana3327 (3/28/2014)

---

Hi,

I have a table with clustered index on that. I have only 5 columns in that table. Execution plan is showing that Index scan occurred. Please let me know...

Hmm... This works just fine...

CREATE login ClarkKent WITH password = 'P@$$w0rdSr0ngEnough'

execute as login='ClarkKent'

select * from sys.procedures --nothing to see

select * from sys.all_objects --lots of system stuff, but they ALSO...

Yeah, I am looking really hard to find any inherited permissions for this, but I cannot. Again, the scenario is that a Windows Group is added with default, public, permissions....

jpomfret7 (3/5/2014)

---

SQLKnowItAll (3/4/2014)

---

jpomfret7 (7/13/2011)

---

Peter Maloof (7/5/2011)

---

David:

I have to disagree that a phone book is an unclustered index.

Unless I'm mistaken, the white pages contain data physically sorted by

last name, first name...

jpomfret7 (7/13/2011)

---

Peter Maloof (7/5/2011)

---

David:

I have to disagree that a phone book is an unclustered index.

Unless I'm mistaken, the white pages contain data physically sorted by

last name, first name and address....

Lowell (2/22/2014)

---

while a user might be able to see system procedures, they can't do anything with them due to permissions;

it's easy to test, just create a user.

create user ClarkKent without...

Jeff Moden (2/21/2014)

---

SQLKnowItAll (2/21/2014)

---

We have just recently noticed that a member of a group who executes sp_defaultdb will have his account added as an individual login with public rights. Our...

I wanted to add that I am not a recruiter, I am a part of the team and part of the decision making process. That is why my job description...

Nobody mentioned Dice.com? Also, get him on linkedin and post his resume. That's when recruiters started calling me when I wasn't even looking...