Forum Replies Created

Viewing 15 posts - 14,011 through 14,025 (of 49,552 total)

  • RE: Indexed views

    IgorMi (3/6/2013)

    That said, I'm curious as to why you want a heap plus a nonclustered index for the base table rather than just a clustered index with no need for...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 6, 2013 at 2:31 pm

    #1594166

  • RE: Is there a name for this concept?

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 6, 2013 at 2:14 pm

    #1594160

  • RE: Indexed views

    There's no requirement that the base table for an indexed view has any indexes at all.

    That said, I'm curious as to why you want a heap plus a nonclustered index...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 6, 2013 at 2:11 pm

    #1594158

  • RE: Read a backup file to find the version

    Copy the backup to a machine that has SQL server (or to a machine that a SQL server instance can see across the network) and run a restore headeronly. Even...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 6, 2013 at 2:07 pm

    #1594156

  • RE: Read a backup file to find the version

    No need to read the backup file manually.

    RESTORE HEADERONLY FROM DISK = <path to backup file>

    Among the columns are SoftwareVersionMajor, SoftwareVersionMinor and SoftwareVersionBuild that tell you the version and service...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 6, 2013 at 1:37 pm

    #1594148

  • RE: Database getting into recovery mode

    Why is SQL being restarted every morning?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 6, 2013 at 12:01 pm

    #1594112

  • RE: If I compress a primary key, am I compressing the whole table --> P-key with DATA_COMPRESSION

    SQLCharger (3/6/2013)

    My tests have shown a performance degradation when the same queries run on compressed tables compared to uncompressed.

    I know, there are fewer pages to trawl across, but it is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 6, 2013 at 7:13 am

    #1593935

  • RE: If I compress a primary key, am I compressing the whole table --> P-key with DATA_COMPRESSION

    SQLCharger (3/6/2013)

    If it is normally in memory anyway, you may decide to leave it uncompressed.

    Why?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 6, 2013 at 6:15 am

    #1593905

  • RE: Lazy Writer

    What do you mean by 'looks after'?

    btw, first page of search results for 'lazy writer plan cache data cache'

    http://msdn.microsoft.com/en-us/library/ms181055%28v=sql.90%29.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 6, 2013 at 1:10 am

    #1593807

  • RE: In which Scenario we can use ldf file in sql server?

    You use the log file any time you take a log backup, roll a transaction back, restart SQL and let the database recover, implement mirroring, transactional replication or CDC.

    So...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 6, 2013 at 1:06 am

    #1593806

  • RE: Attempt to fetch logical page (1:440) in database 2 failed. It belongs to allocation unit 422212869292032 not to 6269010747738816512.

    TempDB problem...

    Does restarting SQL help? Anyone been shrinking TempDB by any chance?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 6, 2013 at 12:34 am

    #1593796

  • RE: MSDN subscription confusion resulted in wrong edition of SQL installation!

    Uninstall, reinstall. Edition upgrade is for upgrades not downgrades.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 6, 2013 at 12:26 am

    #1593792

  • RE: Disable & Rename 'SA'

    I would also not rename the account.

    Renaming it makes the account harder for hackers to locate and try to crack, but if the account's disabled there's no way to log...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 6, 2013 at 12:25 am

    #1593791

  • RE: Disable AUTO_CREATE_STATISTICS and AUTO_CREATE_STATISTICS for all databases

    Why do you want to do that? Are you aware of the impact that will have on query performance? Do you have jobs in place to manually create and update...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 6, 2013 at 12:22 am

    #1593788

  • RE: If I compress a primary key, am I compressing the whole table --> P-key with DATA_COMPRESSION

    Steve Malley (3/5/2013)

    Can someone explain how data compression works at the index level? If I compress a primary key, am I compressing the whole table [since the data pages are...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 5, 2013 at 4:40 pm

    #1593686

Viewing 15 posts - 14,011 through 14,025 (of 49,552 total)