I have managed to answer my own question. There were accounts that were local admins that had implied admin access. These were not being blocked out by the builtinAdminsAreServerAdmins...

I would say yes. but it depends on Index maintenance.

the yes is because an ideal clustered index should be small, unique, static and ever increasing(in a sequence). Unique identifiers are...

Hi Dave,

Luckily SQL holds a Pivot and unpivot function that will do the trick nicely.

if you follow this link then it will give you the details that you need....

Koen Verbeeck (8/7/2014)

---

jonidotcodotuk (8/7/2014)

---

Jeff Moden (8/6/2014)

---

Ed Wagner (8/6/2014)

---

How about a very simple one?

Please write the T-SQL code to count from 1 to 10.

There are many correct answers and how they...

Jeff Moden (8/6/2014)

---

Ed Wagner (8/6/2014)

---

How about a very simple one?

Please write the T-SQL code to count from 1 to 10.

There are many correct answers and how they answer can tell...

Hi Duncan,

you first need to decide which days are weekend by using the datepart function and create a list of every day between the 2 stating which is a weekend....

Hi Steve,

it looks to me as though you are trying to update the QTY column using a sub query that brings back more than one column. Change the select to...

Tell me about it. I'd love to use them more but they're so prohibitive

The error message is because i forgot to give the max column a name, each column in a temp table needs a name. replace it with "max(discount) as Discount "...

looking at the code is the exhibit table used in the select? i could see one column sectioned out if thats not needed you might be best getting rid of...

Hi Pbaldy,

unfortunately there are quite hefty restrictions on what can't be included in an indexed view an a union is one of them, please see the books online article below...

Hi Grasshopper,

this very much looks like a join problem, if you've looked in your data and found that there are multiple discounts for a single part you are on the...

4/5 isn't bad. especially when the last one was the trick question. There was no set showplan on the query and nothing to say that you were trying to bringing...