Forum Replies Created

Viewing 15 posts - 9,046 through 9,060 (of 9,720 total)

  • RE: The SQL * Wildcard

    I've stopped using NOLOCK just because of the drawbacks. I want to see all the data, so I'll take a little bit of a performance hit just to make...

    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.

    January 28, 2008 at 3:54 am

    #772323

  • RE: Installation problem

    Glad you found it. Thanks for posting the solution!

    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.

    January 28, 2008 at 3:53 am

    #772322

  • RE: Would you use sql_variant?

    ToString() would certainly return the values but you can't SUM() a string. So I would still have to do an additional conversion to get the money or smallmoney values...

    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.

    January 28, 2008 at 3:52 am

    #772321

  • RE: Upgrade question RS 2005

    Try Matt's suggestion first.

    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.

    January 25, 2008 at 3:49 pm

    #772054

  • RE: character length of tiny int

    It's the Microsoft Self-Paced Training Kit for 70-441. I don't have it on me at the moment (it's at work), but the cover is blue and it has a...

    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.

    January 25, 2008 at 3:32 pm

    #772048

  • RE: How to delete first couple of rows without knowing column name

    Without knowing at least one column name, there's no good way to do a delete other than manually before the run of the package.

    I recommend redirecting the rows out of...

    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.

    January 25, 2008 at 3:29 pm

    #772046

  • RE: How to see an image in db?

    If I'm not mistaken (someone correct me if I am), the Image datatype is actually stored in the DB as a binary file. Therefore, there is no good way...

    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.

    January 25, 2008 at 12:19 pm

    #771968

  • RE: Uninstalling mssql2005 with an instance of mssql2000 running causes problems

    If all else fails, you might have to back up all your databases, uninstall and then reinstall SQL Server, then restore all your databases.

    But try the MSDB restore first. ...

    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.

    January 25, 2008 at 12:11 pm

    #771961

  • RE: How to delete first couple of rows without knowing column name

    Why are you using SQL to delete from an Excel spreadsheet? What are you trying to accomplish?

    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.

    January 25, 2008 at 12:08 pm

    #771960

  • RE: Installation problem

    and this link:

    http://blogs.neudesic.com/blogs/pete_orologas/archive/2006/10/12/416.aspx

    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.

    January 25, 2008 at 11:42 am

    #771950

  • RE: Installation problem

    Check this link out and see if it helps:

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2553214&SiteID=1

    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.

    January 25, 2008 at 11:41 am

    #771948

  • RE: How can you respond to this...

    Given the staff changes issue, you need to start documenting what it is you're training the back up people on. Create a binder filled with details on what you...

    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.

    January 25, 2008 at 11:31 am

    #771936

  • RE: The old IT conundrum (how do I get from here to there)

    If the group is really tight knit, you might want to consider your approach to them carefully. You don't want them to think you're trying to steal one of...

    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.

    January 25, 2008 at 11:03 am

    #771913

  • RE: How can you respond to this...

    ...or rather, they trust that I will have everything working right again quick enough that its only a minor issue...

    And it's that comment that worries me. So you are...

    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.

    January 25, 2008 at 10:52 am

    #771902

  • RE: Uninstalling mssql2005 with an instance of mssql2000 running causes problems

    The problem is that SQL Server Agent is not part of the client tools. It's part of the whole SQL Server Engine install. So taking off the client...

    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.

    January 25, 2008 at 10:48 am

    #771899

Viewing 15 posts - 9,046 through 9,060 (of 9,720 total)