Forum Replies Created

Viewing 15 posts - 12,331 through 12,345 (of 39,896 total)

  • RE: table corruption

    Errors 823/824/825 will be raised.

    If you suspect corruption, run DBCC CHECKDB.

  • RE: Talking baseball

    calvo (6/19/2013)


    Yeah, that's the problem I now have with "clutch", it is meaningless. To try and have a formula for defining a clutch score based on probabilities and leverage indices,...

  • RE: RESTORE DATABASE is terminating abnormally.

    The larger the file, the more changes that something breaks when it's transferred. I've had issues with downloads from MSDN that won't work, but when I re-download, things are fine.

    I'd...

  • RE: SQL Server Should Work for Us

    Eric M Russell (6/19/2013)


    ... Perhaps Microsoft has intentionally capped the investment on SSMS, implementing basic management functionality, thinking that 3rd party tool vendors or add-ins will fill in the gaps....

  • RE: RESTORE DATABASE is terminating abnormally.

    First, did you do as Gail asked and copied the backup file locally to take out network issues. They can be problematic.

    If so, then you have a corrupt backup. No...

  • RE: SQL Server Should Work for Us

    kevaburg (6/20/2013)


    Einstein once said: If you can't explain a subject in simple terms to a layman, you don't know enough about the subject yourself.

    Your DBA has mastered...

  • RE: SQL Server Should Work for Us

    Andy Leonard (6/19/2013)


    Put a team of 50 people to work on usability and improving the tooling. It will be a great investment for the future.

    Or....

    Microsoft could license (or buy) the...

  • RE: Need a help in backup Encyption Certificate

    No encryption takes place on the client. Unless you have your instance and client tools installed on the same Windows host.

    All encryption is server side. The client statistics can be...

  • RE: Need a help in backup Encyption Certificate

    That will show you the difference for that query only, but if that's all you need, it should demonstrate that. If you don't see a difference, you might need more...

  • RE: SOS DB In-Recovery

    "it would not let me" doesn't help us. Can you please give specific errors or issues and what commands you've run.

  • RE: Need a help in backup Encyption Certificate

    You set use SET STATISTICS IO and get the data back.

    You want server statistics, not client.

  • RE: Need a help in backup Encyption Certificate

    you can do this with a small database, but you likely won't see any difference in performance. If that's OK, or what you're trying to show, then it will be...

  • RE: Need a help in backup Encyption Certificate

    Performance? You'd have to have a workload you can run and run it before, and after, the encryption. Otherwise no good way to get the overhead. However I haven't seen...

  • RE: Talking baseball

    I knew I'd read something similar. I found this:

    Clutch = (WPA / pLI) – WPA/LI

    from: http://www.fangraphs.com/library/misc/clutch/

    I think there is something to it. I've seen plenty of people perform well under...

  • RE: data type change

    First ensure that your data will all fit in the new datatype. That could easily be an issue.

    Next, you have to find all objects that reference this column. Views, stored...

Viewing 15 posts - 12,331 through 12,345 (of 39,896 total)