Forum Replies Created

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

  • RE: List of SQL 2005 features incompatible with level 80?

    There's no comprehensive list, but ISTR that I had to change compatibility before I could use PIVOT / UNPIVOT.

    I can't tell for sure now because all the DBs...

    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 4:37 am

    #772333

  • RE: How to have multiple WHERE clauses depending on condition

    I go with Ian's suggestion. I always try various combinations then run through a Query Execution plan to see which one works best for my current needs. 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.

    January 28, 2008 at 4:32 am

    #772331

  • RE: Move Database to different Partition

    Are you talking user databases or System databases?

    Because System Databases cannot be detached while SQL Server Service is running. You'll have to use the Alter Database command...

    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 4:29 am

    #772329

  • RE: General Information for new "wannabe" DBA

    There are all sorts of books and training materials out there. Some of the stuff for certification exams can also be useful for learning the basics of SQL Server.

    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 28, 2008 at 4:26 am

    #772327

  • RE: DATABASE

    And if there are error messages, don't forget to include them in your post.

    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 4:10 am

    #772326

  • 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

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