I was fortunate enough to hear Thomas Kesjner at SQL Bits in London earlier this year.

He started his presentation with "I'm not normally a transactional specialist but....." and proceeded to...

I can't stress the maintenance issue enough.

Let us suppose you hire a good DBA. By locking SQL in a code release you are hamstringing your DBA; you are not...

Why not use sp_ExecuteSQL and build up the query that is needed in T-SQL code. This will cache the execution plan for the query statement.

The other thing I would...

Not yet but I have spoken with people in the...

sp_who2 should give you details as to who is accessing your SQL Server.

I've found that SELECT * FROM sysprocesses WHERE Blocked<>0 is also quite revealing. Blocked is the SPID...

If you've got dupes in your source then you need to include dupe handling routines in your SELECT query.

If you have a table which has ID values 1,2,3,4 in it...

Tony++ (6/29/2010)

---

If the parm data is len(10) on a first call, len(11) on a 2nd, and len(2) on a 3rd, it creates different parameter sizes & ends up being...

There seems to be an assumption that there is a single field acting as the PK. This isn't necessarily true.

As to calling things ID because its easier for developers...

Non-database aware developers have a different perspective to DB aware developers on a particular problem.

I would not advocate having "ManagerEmployeeID", ManagerID is clearly more appropriate. I used to use...

sanjays-735734 (6/7/2010)

---

Hi David

I would like to add something in Your "simple example"...

IF EXISTS(SELECT 1 FROM ... WHERE...)

Instead of this Use following...

IF EXISTS(SELECT TOP(1) 1...

Imagine how you'd feel if it was June 2010 and you were...

I think data is going to come into ascendancy if it hasn't already. In the old days you needed a DBA simply to keep the lights on, now...

My thanks to Paul for his help in resolving the SQL2005 conundrum.

It was my bad. SQL2005 does reclaim space when the clustered index is rebuilt.

SQL2000 doesn't and this I...

The point of the...

@sipe_16

When you use an ORM tool it effectively hides the schema so you can get away with calling the fields almost anything.

When you are reading down a large block of...