The only link that there is between a job review and one's feelings is that you get the opportinity to state how you feel about your job - well thats...

First of all, yes, you do have some fragmentation in your tables and I would look to reindex/defrag these.

Also, look at your distribution statistics. How up to date are...

What do you see is sysdatabases?

Have you tried dropping it from Query Analyser too? If so, what error message do you get?

Did it have a name and it was...

Not sure the salary difference is so much now with the price of the pound against the dollar! Who knows...But then again, it really depends on which industry and...

Well, I've not read every comment, but personally, I find going out for drinks or lunch or even a round of golf on a weekend with colleagues great fun. ...

I don't think your way behind. I was in the same boat up until I changed jobs in August. Infact, my previous company were trying to move me...

I would have to agree with your comments Steve.

I've been to a few Microsoft seminars and also attended a couple of inhouse classes and you go get varying levels of...

Selected tables. 80% of tables are static or rarely changed.

SCC is a superb site first and foremost. The site has a great mix of beginners and experts and everything inbetween.

The best part of the site is the common...

Agree with Steve, use the wizard if you have enterprise edition.

We had Enterprise edition in a previous company but they still decided on a manual process using VBScript to pull/push...

A restore, simply, is replacing the existing database with a combination of full, differential and log backups (varying combinations).

A recovery occurs when SQL Server fails and is restarted. Transactions...

Just another consideration...

Split your datafiles from your transaction log files. 

Morning,

BCP (Bulk Copy Process) will export the data to another data source.  Steve suggested this to test the validity of the table and data.

One other thing you could possibly try. ...

I was going to suggest something similar.  A job could be run every hour or so to add any columns.  You could create some kind of work_pending table and use...

To alter a table you need to be the table owner, sysadmin, dbo or ddl_admin, so if you want it all done in that 1 stored procedure, you will have...