Forum Replies Created

Viewing 15 posts - 12,256 through 12,270 (of 39,896 total)

  • RE: prerequisites

    Note that in addition to sean's reference, there isn't just "replication" in SQL Server. There are different types, and the complexity, monitoring, and administration is different for them. You should...

  • RE: Are the posted questions getting worse?

    Notifications working for people? Seem like the queue might be stuck.

  • RE: Depending on CurrentStatus will determin where to pull the values from

    Not sure if this is more efficient and you'd have to test, but you could join with an OR and then use a CASE statement.

    Select

    case

    ...

  • RE: SQLServerCentral Runs sp_Blitz - Informational Items

    TheSQLGuru (7/6/2013)


    I am wondering why you are using the older 1204 for deadlock information instead of (usually more useful) 1222.

    No idea. I'll have to ask.

  • RE: issue with tempdb

    You are right (as usual), Gail. I thought it would start in read-only mode, but sure enough I get a failure.

    The problem is probably rights. Your system cannot open c:\xxx.mdf...

  • RE: issue with tempdb

    There should be information in the SQL Server error log about it starting. Look for that. tempdb being broken doesn't prevent the instance from starting.

  • RE: Independence Day 2013

    jasona.work (7/5/2013)


    Hmm, can we amend that to be:

    We hold these truths to be self-evident, that all men are created equal, that they are endowed by their Creator with certain unalienable...

  • RE: Are the posted questions getting worse?

    Hope everyone had a good Fourth. My day?

    We leave late for the mountains (1), hit traffic (2), Tia's hungry, but everywhere in Idaho Springs is packed and busy (3). Hit...

  • RE: How to Check Change in the Status

    I hate doing this in individual emails, since I think it's a poor design practice. Over time, or when things are busy, people get tons of emails that aren't necessary....

  • RE: Add Variable to integer

    Lowell does it the way I'd do it if the data is static.

    If it's not completely static, or may change often, then you could use another table.

    create table status

    ( code...

  • RE: issue with tempdb

    What's in the error log?

  • RE: Who's Got Your Data?

    swwg69 (7/4/2013)


    As a father with daughters, I worry about the indiscriminate abuse by single FBI agents. Let me cross reference birth control pills with condom purchases and bar patronage....

  • RE: The US Holiday

    Thomas Abraham (7/4/2013)


    Thanks for the question Steve. However, in the spirit of harmonic international relations, I propose that we extend the same courtesy to other countries: August 1st for Switzerland,...

  • RE: SQL in the City 2013

    Jan Van der Eecken (7/5/2013)


    I expect that we'll bring more events to locations outside the US...

    How about "outside the US and Europe"? Like Africa 😎

    Perhaps at some point. It's sales...

  • RE: help with sp_MsForEachDb

    PearlJammer1 (7/4/2013)


    @steve-2 - Thanks for the extra info on this. By the way - terrible shirt at the sql in the city in London !!!! 😉

    Fantastic day though !!

    you misspelled...

Viewing 15 posts - 12,256 through 12,270 (of 39,896 total)