quote:

---

For stored procedures, I always include SET NOCOUNT ON as the first statement. I don't want the stored procedure to return those...

My intent was to show how you can use an array to pass the values. That it is clipped from a best practices document is more a best practices...

Here is a section from a document I wrote on ADO best practices:

Implicit Parameters

As explained above, implicit parameters can save code. For example, rather than create two lines of...

quote:

---

Both SiteServer and my user databases are using Windows Integrated security. Both have the required user set up and yet I still...

I ran your test. Here is my initial set of results:

4516 MILLISECONDS TO RUN 500 STORED PROCEDURES

5173 MILLISECONDS TO RUN 500 STORED PROCEDURES

4153 MILLISECONDS TO RUN 500 STORED PROCEDURES

5080...

quote:

---

Mromm, are you meaning that you do not normally like to use views for the data retrieval? Just curious as to your...

Ensure you execute the log backup command just prior to your database backup. This makes the backup as small as possible. I have also noticed that when I...

I recommend you set up a user for your SQL Server to use. During the installation, you have the choice to use local administrator or an NT user of...

quote:

---

A constraint is added to the column definition like this:

CREATE TABLE table_name (

abc int NOT NULL

CONSTRAINT constraint_name UNIQUE CLUSTERED

)

An...

quote:

---

...when I tested the column for an update with a date earlier than the CHECK condition, I found that the constraint was...

I have trouble with blanket statements such as "Stay away from public." In some, perhaps many cases, that is true. But sometimes it's not.

Public is used...

Here are a few things we do which no one has mentioned:

Regarding the id field, we use ID when its an autonumber which will be meaningless to users (eg intCallID);...

Good article. I too am amazed by how many people are willing to forgo primary keys on small tables. Data integrity always preceeds performance (esp such a slight...

I agree this is a great tool. We ran a lot of tests and simulated several disasters, all of which we recovered from. The interface is not entirely...

Two issues on the above statement:

I would write the commit trans statement as

IF @@transcount>0 COMMIT TRANS

Also, you are returning a value of 0, which indicates no error. Use RETURN(-1)...