I tend to use short meaningful abbreviations, which is fine for databases with a few tables, but if you get an app with thousands of tables then your abbreviations cna...

quote:

---

Dude should have normalized his database...

---

Probably bought the list from a...

quote:

---

For the second best practice, i would like to add

Give proper alignments or Indent while writing the joins to make...

Perhaps you should write an article and submit it to the site.

Enlighten us all and earn US$25 in the process.

========================

He was not wholly unware of the potential lack of insignificance.

Yep, Douglas Adams.

The robot was Marvin the paranoid android but I'm thinking of a character in a later book in the series but can't think of his name.

There...

Sorry, forgot the language barrier.

They say that eskimos have thousands of names for snow, the British have millions that can be used as insults.

Bodily parts can be used as insults...

I used to work on an HP3000 mini-computer where the console had ultimate control followed by administrators followed by users.

We had a utility that let us impersonate differing levels of...

In my environment yes because

• I have a suitable carrot (the keys to the bosses drinks cabinet and the ability to sign expense forms).
• I have a suitable stick (I contribute...

As a DBA I expect all submitted code to be commented.

The comments should detail up front which tables are going to be used, what variables if any are declared and...

Do you mean the physical size of the database or the amount of data within the database?

If you use sp_helpfile within your database this will give you the files used...

I've had situations where I have had to use cursors.

I had a recordset containing the stages in securing a sale for customers.

The complete set of stages was called a chain.

Certain...

quote:

---

SQL Server is based on the relational model ....but not a very good implementation of it.

Of course, since SQL Server is not...

I would add that stored procedure names should not start with sp_ because SQL Server will search the MASTER database for the stored procedure first and then the user database....

It looks like you are creating two indices on the SID column of your tables.

To compound it, one is the primary key and the other is a unique index.

CREATE TABLE...

quote:

---

UPDATE a

SET a = b.a,

b = b.b,

c = b.c,

d = b.d

FROM a,b

WHERE a.id = b.id

---