Viewing 15 posts - 1 through 15 (of 15 total)
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...
August 13, 2004 at 4:57 am
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...
August 13, 2004 at 4:39 am
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...
August 13, 2004 at 4:09 am
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...
August 10, 2004 at 5:29 am
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...
August 10, 2004 at 5:17 am
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...
August 6, 2004 at 8:18 am
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...
August 6, 2004 at 4:04 am
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...
August 6, 2004 at 3:19 am
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...
August 6, 2004 at 2:56 am
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...
August 5, 2004 at 8:46 am
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...
August 5, 2004 at 7:11 am
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...
August 5, 2004 at 7:05 am
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...
August 5, 2004 at 6:56 am
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...
August 5, 2004 at 6:44 am
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...
August 5, 2004 at 6:40 am
Viewing 15 posts - 1 through 15 (of 15 total)