Forum Replies Created

Viewing 15 posts - 1 through 15 (of 15 total)

  • RE: Can you truncate a published table?

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

  • RE: Can you truncate a published table?

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

  • RE: Think like a DBA

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

  • RE: Multiple files in primary file group

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

  • RE: PLS HELP - Export data to text file format

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

  • RE: Natural Sort Order

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

  • RE: Takes an age to open Enterprise manager

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

  • RE: Devide by zero

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

  • RE: Connectivity to SQL Server via VPN terribly slow...

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

  • RE: How to create a rolling average?

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

  • RE: Date Problem in Query

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

  • RE: DTS - Cant drop table not in System Catalog??

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

  • RE: sql server and photos

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

  • RE: Multiple Data Files? Why?

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

  • RE: Add the content of a text file in database

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

Viewing 15 posts - 1 through 15 (of 15 total)