Forum Replies Created

Viewing 15 posts - 3,646 through 3,660 (of 3,666 total)

  • RE: Logins and Users

    I'm wondering why you would want to create multiple users with the same login what keeps popping up in my mind is that you're trying to reduce the work required...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: How to find execution of stored procedure from application.

    I normally use SQL Profiler when I want to find out what is running.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Advantages to have mutiple data files

    Having multiple datafiles where the files are of different physical disks can improve the speed of data reads and writes since the data can be read from the different drives...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SQL Server grabs all the memory

    It's normal for an active SQL server to grab as much memory as you allow it to grab, especially if there are no other applications asking for memory on that...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Need DR Strategy Design Help

    DMC,

    If you using a "good" SAN then some form of SAN mirroring should be possible, but may not be possible when SQL Server is active. You're likely to run...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Moving TempDB

    Charles, I just had a sort of funny thought. If you go ahead with was said in here, or use tempdb, you might want to recommend to the...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Moving TempDB

    Charles, one thing to watch out for. The new table you're talking about adding to the Model database would not only be added to tempdb on reboot, but it...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: GROUP BY ALL

    Don't feel bad David. You're not alone in this boat.

    hmmmm ...... is it your turn to row?



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Bad Microsoft DB Schema Example

    K. Brian Kelley (8/1/2008)


    Alvin Ramard (8/1/2008)


    One thing to think about ....

    If you have separate tables for each product, what happens if they add a product? Someone needs to add...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Bad Microsoft DB Schema Example

    One thing to think about ....

    If you have separate tables for each product, what happens if they add a product? Someone needs to add at least one a new...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Beat this - comic relief for the day

    I can't help but wonder if the view definition looks something like:

    create view vwProviderDirectoryReportWithAllServiceLocations

    as

    Select *

    From

    ProviderDirectoryReportWithAllServiceLocations

    end



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: help me for following ssis package

    I would use a "For Loop Container" with a Script Task as the first step in that container. On the first pass, the script task would retrieve the list...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Power

    I'm sorry abinder but I think you're not considering a very important point.

    It would not be appropriate for SQL to change the data type of the answer unless it was...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Power

    The correct answer was returned with the error message but exceeded the maximum value allowed for that data type. That is why the result had to be an error.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Which is better? (SQL Server Best Practices)

    I prefer the (Where LEN(isnull(Message, '')) > 0) method.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 3,646 through 3,660 (of 3,666 total)