Forum Replies Created

Viewing 15 posts - 31,711 through 31,725 (of 39,917 total)

  • RE: SQLDiag running amok.

    I haven't seen this, but SQLDiag grabs a lot of info and could eat up space. I think you can determine where this space is, so maybe you can run...

  • RE: Question of the Day for 22 Aug 2007

    Sorry, I misread a portion. I've changed the answer to include the currency symbol and edited the explanation (and thrown the question out).

  • RE: Avatars and Photos?

    It's being fixed!

    We're in beta now and we should have this rolled out in a few weeks as we tweak the last few things.

    If you want yours changed, send it...

  • RE: Question of the Day for 22 Aug 2007

    The answer is correct and the explanation according to the documentation. It's hard to show them on the screen and perhaps we could use [] or something else, but the...

  • RE: A Cool Job

    We'll build a cage around it, like the missle launchers in "War Games" and give the key to the SOX guys

    You have a...

  • RE: Tuning Time

    We don't work in Denver!! We order hardware that's shipped out while we ride our horses

  • RE: 70-431 simulations question

    You are welcome and definitely be sure you work through how to add and delete all the objects (users,schema, linked servers, logins, etc.). It helps to just go through it....

  • RE: Scalability Options

    Honestly, if you are thinking of this, I'd do it this way.

    Replicate back to separate DBs on your main server. This gives you some DR stuff since you can quickly...

  • RE: Find out all SQL Server 2005 installations on our network

    You might be better off with taking your list and running a "connect" to each one as a domain admin (should work) and getting the version. I think that's what...

  • RE: Selecting from various DBs

    missing a comma up there before one of the CASE statements.

    CASE when ... end

    is like a column. Needs commas to separate out.

    You have

    select x

    , y

    case...

  • RE: 13 Disasters

    The odds?

    Depends on whether it was your day off or not

  • RE: Using ''''IN'''' Function

    The code pages for the data are different. Meaning the way in which the data is encoded is causing problems. Since the OR works, I'm guessing there's some bug here.

    Report...

  • RE: identify most resource intensive query

    It's the cross apply with the function that gets the text. It's not in a table, need a handle to the plan to get it.

  • RE: Identity Field

    I've run out of INTs in some situations. Like SMS, constant scan type of stuff.

    Eventually it's an issue. BigINT gives you more space. If you run out, need to move...

Viewing 15 posts - 31,711 through 31,725 (of 39,917 total)