Forum Replies Created

Viewing 15 posts - 6,556 through 6,570 (of 18,923 total)

  • RE: Query to generate comma separate column

    I don't understand what you are doing.

    In all the erps I've ever worked with balance is never saved. It's always recalculated on the fly.

    If you want to keep it...

  • RE: Strange Restore Performance

    Gordon Pollokoff (5/3/2011)


    1. To clarify some points, the restore is from the local server drive. The drive is SAN storage connected via a 2GB fiber optic connection.

    2. ...

  • RE: Strange Restore Performance

    2 GB connection... ya but what I've seen was the windows "network" connection to the san had dropped from 1Gb to 100 or 10 MB and the information just couldn't...

  • RE: Is this a good backup strategy?

    The real answer is simple : does it work? That implies you must have requirements and tested that you can restore the files (which I do on all my...

  • RE: Waits issues

    Ah, another reason to NOT post 1-2 mb bmp attachements... Gail would have spotted those if she had opened the files!

  • RE: Strange Restore Performance

    Either your disks are getting trashed doing something else or maybe the network is down to 100 mbps rather than 1gbps for some weird reason (assuming you restore from network...

  • RE: Shrink large database

    TheSQLGuru (5/3/2011)


    I'll make it plus 2 million to Ninja's + 1 million 😀

    I'm all in :hehe:.

  • RE: Shrink large database

    sachnam (5/2/2011)


    boris.kovalcik (5/2/2011)


    Hi all,

    I have problem with database size. I have one database about 330GB(4 datafiles + 2 logfiles). I archived a lot of old records to archive database and...

  • RE: The multi-part identifier "#StagingA.Number " could not be bound.

    Pls post the actual query so we can help. This is clearly not what you are running.

  • RE: date diffference calculation base on name

    30 people watching this thread and no answer... not normal.

    can you post the exact expected answer from your sample data?

    Also how much data to do you have in that table...

  • RE: hash join

    Well maybe I'm missing something but what's the point of returning 12M + rows to anything?

    I'd understand the left join if you wanted to find unactive users. But with...

  • RE: Security

    You need to readup on the subject.

    Read up on grant and deny in books online. Everything you need is there.

  • RE: How do you vulgarize a DBA's job?

    Craig Farrell (5/2/2011)


    Brandie Tarvin (4/29/2011)


    GSquared (4/29/2011)


    I tell people that my job description is specifically designed to see how fast a person's eyes can glaze over. The entertainment starts there.

    I...

  • RE: Are the posted questions getting worse?

    GilaMonster (5/2/2011)


    Ninja's_RGR'us (5/2/2011)


    BTW did you have a chance to tackle my puzzle to get all the prepared plans in the cache (from sp_sprepare)?

    I started on something for that (and cursorfetch),...

  • RE: Are the posted questions getting worse?

    SQLkiwi (5/2/2011)


    Ninja's_RGR'us (5/2/2011)


    You can always mail it to me if you want... I won't tell a soul :-).

    No, I am resisting casting further aspertions on Craig's mental health.

    Ninja's_RGR'us (5/2/2011)


    BTW did...

Viewing 15 posts - 6,556 through 6,570 (of 18,923 total)