Forum Replies Created

Viewing 15 posts - 1 through 15 (of 19 total)

  • RE: Measuring Snapshot Isolation update conflict resolution time

    Thanks for the help. It is the SQL Server internal row version update conflict resolution process I am referring to. The applications retry when a conflict occurs but I am...

  • RE: SQL 2016 and SQL VM's

    1) Yes you can install it. Not really. I wouldn't recommend installing a CTP version of SQL Server onto any server I want to keep afterwards as you can't always...

  • RE: 2008 R2 upgrade advisor error

    I had to install the advisor on a server too but its not ideal and I really hate to have to do that :blush:

  • RE: Output of Query

    Great question - unfortunately I got it wrong.

    I thought it was too simple so I over compensated and assumed that the code would have "set ansi_nulls off" for the session...

  • RE: Shrink Database

    I was expecting the fragmentation to grow on the basis that pages at the end of a database file get moved to empty pages earlier during a shrink.

    When i tried...

  • RE: 2008 R2 upgrade advisor error

    I have admin rights (local and domain), UAC is turned down to minimum, I have redownloaded the package multiple times. I dont think I can execute the installer as administrator...

  • RE: QuestionCan SQL 2005 SP 4 be UNinstalled? How do you install SP4 on a Cluster?

    you cant uninstall a SQL 2005 service pack. To remove an SP you need to uninstall SQL, re-install, restore the database backups and server configurations.

    installation guide just posted at

  • RE: How to install SQL Server SP4 on a Cluster environment???

    1. ensure you have 3gb disk space free on the system drive of all nodes

    2. ensure you are logged on with local admin privileges

    *edit* and the account you are...

  • RE: Heaps

    Like christian I am wondering why the page is full. Can someone explain why a page with 3 x 1000 bytes rows, 1 x deleted 1000 byte row (now a...

  • RE: Physical vs Virtual Memory Question

    I experienced the "AppDomains being unloaded due to memory pressure" error recently so I will explain how I fixed that so you can see if it works for you. The...

  • RE: xp_cmdshell

    The xp_cmdshell is calling a command line program called OSQL which is connecting to the default instance on the local computer with the username teste and password teste.

    If you...

  • RE: query plans not being reused

    Sorry I haven't been very clear. I was trying to leave the question open for other ideas which I guess is leaving it a bit too open. I was meaning...

  • RE: problems with a more complex query than I'm used to :)

    hopefully this should do the trick if you are using SQL 2005 or later.

    WITH CTE AS (

    SELECT custID

    , module

    ...

  • RE: SQL Server 2005 SP3

    I had a support incident with MS in July and the PSS guy said a month or so. Officially MS announced SP3 by the end of this calendar year so...

  • RE: sa account IsLocked?

    I have the same issue with sql logins not working if the account has check_policy enabled. I am using Guids for the sql accounts so they clearly meet password policy...

Viewing 15 posts - 1 through 15 (of 19 total)