One more thing - in your application you could copy the desired data to the 'empty' database and replicate that. Second tweak - if that still leaves you a lot...

The solution above - use an empty snapshot works - I have used this a lot.  Basically we had in my last job a humongous production database which at the month...

A Happy DBA is a ....... rarity maybe ;-). I think that the original point about thinking differently is true. How people think depends very much on the background they...

Er well it may be that your filegroups no longer have for you any purpose as far as backup is concerned they will however have a performance impact. SQL uses...

yes you can export from a view when using ncp so basically you can order the fields in any way that suits you and can even 'stroke the data' via...

if you look at the following using the pubs database

select au_id from authors

order by null

seems pretty redundant but it is just to illustrate what happens when an expression returns null...

Possibly you have a problem and then again probably you do not. If you have no problem once it is open then you probably do not have a problem. I...

Without the code this is an almost impossible question...however I am going to assume that you are running a very simple query and are dividing one field by another.

I assume...

I would say you have a network issue - I dont understand what you mean by downloading data? Are you trying to bring data accross the T1 lines locally dont...

This easier to do than to post - so the short version without the pseudocode which I did not copy

This depends on the fact that you have a restricted group...

The problem most likely is to do with the locallisation of the particular machine you are running. It may be getting confused between the 02/08 as the second of august...

I aint got ime to look at the moment but try this

Go to you destination server. Script out a user table ensuring that you have the create and the drop...

The last thing you want is to subject SQL servers data cache to having to serve loads of blobs - it isnt optimised for that - ghughes suggestion is the...

TSQL

whoever told you that you have to learn  TSQL to administer MS SQL is either an Oracle bod or never had charge of a multi server installation - most DBAs...

I am not going to use it until 2005 is out and stable - I just have a feeling that they will change it just enough to make lots of...