Forum Replies Created

Viewing 15 posts - 3,991 through 4,005 (of 9,726 total)

  • RE: Installing SQL SERVER 2012 Developer Edition On Top of 2005 Editioon

    jrichards54 (9/11/2012)

    Now I am ready for the sixth install but I would like to install only the Database Service and since I am using Visual Studio 2005 I believe that...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 11:56 am

    #1536417

  • RE: Remotely Connect and Query a db.

    mike 61998 (9/11/2012)

    They are not on the same network.

    This sounds like it's a Trust issue. Talk to your network / Active Directory admin and see if they can set up...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 11:52 am

    #1536416

  • RE: Reformat Phone Number

    Eugene Elutin (9/11/2012)

    The best and easiest would be creating CLR function which will remove all non-digits from string using RegEx.Replace.

    Forgive me a moment, Eugene, while I poo-poo your "easiest" comment....

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 8:29 am

    #1536287

  • RE: Reformat Phone Number

    REPLACE() would take care of your spaces and hashes. You could also use the LEN() function to compare the data to what length the number should be in order to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 8:28 am

    #1536285

  • RE: how to best summarize data

    Just a warning, Christina, if your data is set up the way I think it is, t.brown's solution will not immediately give you the answer you're looking for. You will...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 8:16 am

    #1536276

  • RE: Upgrade to 2008R Collation

    As it is a side-by-side migration, what you need to do is start testing your data to make sure the collation is compatable and translatable before the migration starts.

    You could...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 8:13 am

    #1536272

  • RE: UNION Help

    Eugene Elutin (9/11/2012)

    Actually the attribute splitting may not be a flaw, but done on purpose. One of the common places where you can see this kind of picture is data...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 8:09 am

    #1536266

  • RE: Remotely Connect and Query a db.

    Did you create a Linked Server object for which to pass through credentials?

    Are the credentials you are using for one server valid on another, or can those credentials at least...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 8:07 am

    #1536262

  • RE: display table in hierarcies

    Glad I could help.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 7:53 am

    #1536248

  • RE: UNION Help

    Celko,

    Cute joke.

    Now do you actually have advice that is any different from that which was already offered?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 7:49 am

    #1536241

  • RE: display table in hierarcies

    The first thing I advise is taking a look at what you actually want mapped. It doesn't make sense to me.

    You want app3 stuff mapped to app4?

    The second thing I...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 6:55 am

    #1536203

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (9/11/2012)

    Hey Brandie, do you think you're going to WorldCon the next few years? Next year is in San Antonio and the year after is London. I was thinking...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 6:50 am

    #1536200

  • RE: Are the posted questions getting worse?

    It's nice to know that every once in a blue moon, I actually do have a clue and can answer some SQL Server questions here without making a total idiot...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 5:18 am

    #1536163

  • RE: Maintenance plan versus 3rd party software

    The biggest issue with third party backup tools is that if the company suddenly goes out of business, or you lose your license, you could loose the ability to restore...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 5:13 am

    #1536160

  • RE: Importing excel data into SQL Server

    SSIS is your best friend for this type of thing. You can actually run a Data Flow task and do a Derived Column Transformation (use a REPLACE()) to get rid...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 11, 2012 at 5:11 am

    #1536159

Viewing 15 posts - 3,991 through 4,005 (of 9,726 total)