Actually there is a lot of value in using NoSQL in ecommerce sites.

One of the biggest headaches facing DBAs today is IO. Processing power is cheap, memory is cheap,...

About 10 minutes ago. I use them quite a bit for tweaking continuous integration and deployment scripts.

I've done a lot of reading around NoSQL. First of all it stands for Not Only SQL and not NO SQL!

There are a number of NoSQL solutions who claim...

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