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

Anything that involves a string function will have a performance hit.

For example, let us suppose that you want to retrieve all names beginning "Smi".

Using WHERE PersonName LIKE 'Smi%' will be...

What about the IBM/Sony/Toshiba Cell processor? Cell 9 is supposed to behave like 9 CPUs on one chip and therefore you are talking about 9 computers with blindingly fast...

I found what I considered to be a bug in ADOX and therefore stopped using it.

The exact details as far as I remember were as follows.

As far as ADOX...