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

I don't have SQL to hand to test this but

Use the DATEDIFF function to find the number of days, then your average will be SUM(STATE) / DATEDIFF(d, @startDate, @EndDate)

http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp

It is worth looking at the help text for XCOPY because there are a number of switches that are extremely useful.

I have to copy across a backup file from one...

I notice that you are using DAO.

I last touched MS Access 6 years ago and at the time Microsoft were pushing ADOX as the way to manipulate MS Access objects...

In the UK we are bombarded with adverts for shredders at £xx.xx and everyone is looking at them and thinking "hmmm... that is pretty good value".

Call me a...

I think that this subject is worth an article if anyone is prepared to write it.

Scenarios, Pros, Cons, Gotchas etc.

According to books on line it is 1,048,516 TB.

It does say that the maximum size of any one file in the database can be 32TB and that the maximum number...