Forum Replies Created

Viewing 15 posts - 211 through 225 (of 1,957 total)

  • RE: Help needed in separating values

    Can you guarantee the format of that data will be consistent?

    For example, will you ever see "1.Oz." (no spaces) or "1.. Oz." or " 1 Oz"?

  • RE: techniques for ensuring isolated temp table scope?

    As long as you are using a single # before the temp table name, they will be isolated without any intervention on your part.

    If you use two ## before the...

  • RE: Query Optimiser not using optimum Index

    It could well be down to bad estimates.

    According to this White Paper: Statistics Used by the Query Optimizer in Microsoft SQL Server 2008, when you use local variables,

    If you...

  • RE: Getting error message in sql server

    One way round this sort of problem is to declare your parameter as longer than the you want to allow, then test the length to see if it is going...

  • RE: Server-side vs App-side

    Use stored procedures for CRUD operations, and include code in there to update the header.

    The problem I have with triggers, is that people/tools don't always remember to check for them...

  • RE: Extract the titles from XML

    Jeff Moden (7/13/2015)


    However it does belong in the db, and there are valid cases for it. I might have data like this list of books, perhaps it's old data and...

  • RE: Extract the titles from XML

    Jeff Moden (7/13/2015)


    The correct answer isn't actually available. The correct answer should be to "hunt down the moroff that used XML to transmit purely flat data and introduce him...

  • RE: Stored procedure never finishes running from SSRS report manager

    Could be parameter sniffing, so please read this: Catch-all queries[/url]

    Could be different settings on the connection (not the conn.string), try capturing the execution plan for the SSRS run and compare...

  • RE: Formatting a date field to just show the date, not minutes.

    faulknerwilliam2 (7/6/2015)


    Hello

    A date field in a report returns the date value as:

    2015-07-01 13:30:27.000

    Is there any way I can script this to appear as:

    01 July 2015 (or 01-07-2015 or 01/07/2015) ...

  • RE: Bug in SSMS

    OK, let's try another way.

    Open regedit (usual rules apply - don't change anything) and navigate to:

    HKEY_CURRENT_USER\SOFTWARE\Microsoft\SQL Server Management Studio\XX.0\Packages (where XX is your version number - I think 2014 is...

  • RE: SSMS Maturity

    abatej (7/6/2015)


    One of the most annoying things about the SSMS shell is the kludgy way you have to go about having multiple queries in the same query tab. You...

  • RE: SSMS Maturity

    Eric M Russell (7/2/2015)


    SSMS might not have a future without AddIns for stuff like object searching and T-SQL formatting. Every release of SSMS should come bundled with a starter project,...

  • RE: Bug in SSMS

    mister.magoo (7/1/2015)


    The actual extension folder will be named something absurd like z05we0ea.mff, and you can remove it by simply deleting the folder when SSMS is not running.

    **WARNING** Make sure you...

  • RE: Bug in SSMS

    Don't bother looking in that file, it will only tell you the same thing - that the package failed to load.

    You have installed a Visual Studio extension package (it may...

  • RE: Trusting Source Control

    Ed Elliott (6/30/2015)


    That sounds awesome, are you going to share it?

    Been thinking about it, but not yet.

    I might stick it on github at some point, but it's not production ready...

Viewing 15 posts - 211 through 225 (of 1,957 total)