opc.three (7/11/2011)

---

Raghavender (7/8/2011)

---

Hi All,

We have a user for a database. Here we need that user should have exec permissions on all stored procedure.

If any new stored procedure created, that user...

Raghavender (7/8/2011)

---

Hi All,

We have a user for a database. Here we need that user should have exec permissions on all stored procedure.

If any new stored procedure created, that user should...

desertrosenp (7/10/2011)

---

Dear.

Here I am trying to Add all the Users of the Active Directory as SQL server Users so that they can log in as sql users...

Provide DDL, DML for sample data and expected results relative to the sample data please.

Literally the string "(local)", like this:

Please post the actual execution plans for both queries.

I like to keep everything in stored procedures despite some of them making use of Dynamic SQL. It makes it much simpler when refactoring your database is the topic. As...

Revenant (7/11/2011)

---

Re results varying depending on GPU, you may expect that in the next version of SQLS: the new version of Visual Studio has heavy focus on async and parallelization,...

SQLkiwi (7/11/2011)

---

opc.three (7/11/2011)

---

Craig's testing showed it for a single-column narrow PK (INT). I wondered whether wider clustering keys would have SELECT...INTO start outperforming the CREATE/INSERT method, and while I did...

Thanks a lot Jeff...another thread completely derailed!

Anyone have thoughts on The Dixie Flatline's fine solution? Hopefully conclusions won't depend on a video GPU or sound card or anything like that...

Revenant (7/11/2011)

---

Yes, I do have hard measurements. I did comparisons between Nehalem and Sandy Bridge, and at...

Revenant (7/11/2011)

---

opc.three (7/11/2011)

---

Craig's testing showed it for a single-column narrow PK (INT). I wondered whether wider clustering keys would have SELECT...INTO start outperforming the CREATE/INSERT method, and while I did...

Craig's testing showed it for a single-column narrow PK (INT). I wondered whether wider clustering keys would have SELECT...INTO start outperforming the CREATE/INSERT method, and while I did some basic...

Perry Whittle (7/10/2011)

---

opc.three (7/9/2011)

---

If you did follow Method 2 you could always try the long way around and migrate the logins to 2005 per the article, then from there to...

GilaMonster (7/10/2011)

---

SVR (7/9/2011)

---

Thank you. I tried the second method . But I did not realize I have to transfer the logins first to 2005. I was trying to to transfer...