Like PHP, MySQL seems to have been written by a bunch of people who thought "what is missing from all web creation languages and how can we put all the...

As we all know the product as Yukon why not stick with that name?

When you brand a product by the year of release even the name has obsolescence. If...

OK, I worked on a database that had several million transactions per country per week appended to a database. I established a rule early on that said only one...

My personal preference follows the 80:20 rule. 20% of the data caters for 80% of the needs. Therefore I prefer to have a small amount of live data...

Has anyone changed the recovery mode of your database to simple?

Let us suppose that you develop on a case sensitive server and that development includes a substantial amount of data, that is, more than you would want to insert using...

I have to admit that I still look at an XML document as a posh version of a COBOL data division.

I quite like the ideas behind OOP and when it...

My wife took one look at a 42" plasma screen and said "it takes up less room than our existing one and will require less dusting".

What a woman!!!!!

It's a shame...

Will we be able to chip it and use it as a cheap web server

If the cache is case sensitive then surely this also has implications for sp_executesql?

I use them as they do 90% of what I want.

I wish they were a bit more robust and/or had the facility to allow a stepped action if a particular...

Try TRUNCATE TABLE dbo.YourTable if you are not concerned with logging.

I always script my databases but the problem with drop is where there are dependent views and stored procedures. ...

Firstly, within TEMPDB your #tmpTable will be called something like tmpTable__________________345u3i5y3. It has to append the rubbish on the end because a # table is specific to your session...

The bog standard install of SQL comes with 5 CALS, one of which is supposed to be the server itself.

If your app is web based then you should be using...

If you rely on transaction log backups then you can't use it.

If you are in a heavy production environment then you may want more control over the truncation of the...