Forum Replies Created

Viewing 15 posts - 5,566 through 5,580 (of 7,164 total)

  • RE: Bringing Active Directory Groups and users to the Sql server 2005 users

    desertrosenp (7/10/2011)

    Dear.

    Here I am trying to Add all the Users of the Active Directory as SQL server Users so that they can log in as sql users...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 11, 2011 at 4:27 pm

    #1351368

  • RE: Recursion Problem

    Provide DDL, DML for sample data and expected results relative to the sample data please.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 11, 2011 at 4:20 pm

    #1351364

  • RE: Connection Issues

    Welsh Punk (7/11/2011)

    Can I connect to local what.... Sorry Im a newbie here. IN SSMS I get the choice to connect to

    Literally the string "(local)", like this:

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 11, 2011 at 4:17 pm

    #1351363

  • RE: Parameterized query performance

    Please post the actual execution plans for both queries.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 11, 2011 at 2:39 pm

    #1351331

  • RE: A type of string search.

    I like to keep everything in stored procedures despite some of them making use of Dynamic SQL. It makes it much simpler when refactoring your database is the topic. As...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 11, 2011 at 2:33 pm

    #1351329

  • RE: Handle NULLs

    Revenant (7/11/2011)

    Re results varying depending on GPU, you may expect that in the next version of SQLS: the new version of Visual Studio has heavy focus on async and parallelization,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 11, 2011 at 12:13 pm

    #1351264

  • RE: Handle NULLs

    SQLkiwi (7/11/2011)

    opc.three (7/11/2011)

    Craig's testing showed it for a single-column narrow PK (INT). I wondered whether wider clustering keys would have SELECT...INTO start outperforming the CREATE/INSERT method, and while I did...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 11, 2011 at 12:04 pm

    #1351260

  • RE: Handle NULLs

    Thanks a lot Jeff...another thread completely derailed!

    Anyone have thoughts on The Dixie Flatline's fine solution? Hopefully conclusions won't depend on a video GPU or sound card or anything like that...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 11, 2011 at 11:29 am

    #1351238

  • RE: Handle NULLs

    Revenant (7/11/2011)

    opc.three (7/11/2011)

    . . . :unsure: How would CPU architecture figure in? Got stats?

    Yes, I do have hard measurements. I did comparisons between Nehalem and Sandy Bridge, and at...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 11, 2011 at 10:24 am

    #1351201

  • RE: Handle NULLs

    Revenant (7/11/2011)

    opc.three (7/11/2011)

    Craig's testing showed it for a single-column narrow PK (INT). I wondered whether wider clustering keys would have SELECT...INTO start outperforming the CREATE/INSERT method, and while I did...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 11, 2011 at 10:01 am

    #1351189

  • RE: Handle NULLs

    Craig's testing showed it for a single-column narrow PK (INT). I wondered whether wider clustering keys would have SELECT...INTO start outperforming the CREATE/INSERT method, and while I did some basic...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 11, 2011 at 9:10 am

    #1351151

  • RE: Migrating sql server logins

    Perry Whittle (7/10/2011)

    opc.three (7/9/2011)

    If you did follow Method 2 you could always try the long way around and migrate the logins to 2005 per the article, then from there to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 10, 2011 at 12:51 pm

    #1350844

  • RE: Migrating sql server logins

    GilaMonster (7/10/2011)

    SVR (7/9/2011)

    Thank you. I tried the second method . But I did not realize I have to transfer the logins first to 2005. I was trying to to transfer...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 10, 2011 at 7:03 am

    #1350823

  • RE: Delete statement for records with multiple FK

    anitia (7/9/2011)

    I am trying to delete records from a table that has multiple FK in Multiple tables. So I created a statement for each table. I was told I needed...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 10, 2011 at 6:53 am

    #1350822

  • RE: Migrating sql server logins

    Thanks for posting back, happy you got it sorted 🙂

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 10, 2011 at 6:41 am

    #1350816

Viewing 15 posts - 5,566 through 5,580 (of 7,164 total)