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...

What am I doing wrong Paul? I don't seem to get any space...

I want to make it totally impossible to use a SQL reserved word or T-SQL extension as an object name.

Being able to wrap up a reserved word in square brackets...

I noticed the extended property when I worked through management studio and the script is for when I don't want to use management studio.

for real deployments everything has to be...

A thank-you would be nice.

A personal training budget would be fantastic especially if I actually got to use what I learnt on the course.

I've just attended SQLBits 6 in London...