Grant Fritchey (6/24/2009)

Well as a database developer I don't know and I don't need to know what the logins are, at least in the environment I work for. I...

Grant Fritchey (6/24/2009)

---

Alexander Kuznetsov (6/24/2009)

---

Grant,

What do I need Active solution configuration and Active solution platform for?

This is a database project, not a C# one, so why am I exposed to...

Grant,

What do I need Active solution configuration and Active solution platform for?

This is a database project, not a C# one, so why am I exposed to and maybe even allowed...

Here is very good article about datetime by Tibor:

http://www.karaszi.com/SQLServer/info_datetime.asp

Steve,

Are you planning a discount for MVPs this year?

I've been using sp_generate_inserts for a long time, no problems:

http://vyaskn.tripod.com/code/generate_inserts.txt

TheSQLGuru (12/26/2008)

---

Arindam Ganguly (12/25/2008)

---

Hi Gaby,

Thanks for the Article. It is highly helpful for our perspect. Atleast this query will be of great help for those SPs/UDFs that are badly hit...

Actually in most cases the best alternative is a loop written in a modern language such as C#, not a T-SQL WHILE loop or a CURSOR. Not only you have...

Clearly DBCC against all databases will run almost identically the same time no matter which kind of loop you use to invoke it. I failed to see the point of...

gojko adzic (11/21/2008)

---

Solomon, in my experience the "SELECT * FROM Table1 to test that change" approach is very inefficient. Come to think of it, next month or next year you...

Solomon Rutzky (11/13/2008)

---

Alexander Kuznetsov (11/13/2008)

---

Solomon Rutzky (11/13/2008)

---

3) To test...

Solomon Rutzky (11/13/2008)

---

3) To test any result set, use...

How would you test the following cases:

- my stored procedure returns an unordered result set;

- my stored procedure returns two result sets;

- my stored...

Just looked up in Subversion: more than one hundred rollback scripts, all generated by SQL Compare of course.

hurcane (10/22/2008)

---

Alexander Kuznetsov (10/22/2008)

---

Hi,

I can use something like SQL Compare which has been around for a while, has been thoroughly tested out by thousands of users, and probably does all...