Forum Replies Created

Viewing 15 posts - 11,521 through 11,535 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Here things are still getting worse (mining problems and government blunderings not helping), so I'm seeing less demand for competant (expensive) people and more 'oh, you've done a university course...

    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

    September 28, 2013 at 4:44 am

    #1654273

  • RE: Basic difference between log shipping and mirroring

    I don't have links to any offhand. I use google for that.

    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

    September 28, 2013 at 4:38 am

    #1654272

  • RE: Are the posted questions getting worse?

    Thursday at Summit is going to be sooo funny. Just saying...

    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

    September 27, 2013 at 4:36 pm

    #1654228

  • RE: What roles do I add to a new custom role, which will allow CRUD and execute on SP?

    Ok, so you can nest roles. So you'd add db_datareader and db_datawriter to your custom role.

    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

    September 27, 2013 at 4:05 pm

    #1654223

  • RE: Are the posted questions getting worse?

    Sean Lange (9/27/2013)

    When all else fails...do as the Romans!!!

    Fall upon your sword? Fiddle while Rome burns?

    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

    September 27, 2013 at 4:03 pm

    #1654221

  • RE: Query on identical objects different systems, A performs speedy with index seek, B performs poorly with clustered index scan

    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    September 27, 2013 at 10:08 am

    #1654121

  • RE: DBCC CHECKTABLE not reporting errors

    You can't just run checktable on all tables, you need check alloc and check catalog too. Could be that it's one of those phases that's failing checkDB. Can't tell without...

    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

    September 27, 2013 at 9:57 am

    #1654114

  • RE: Jobs to do after restoring 2000 db to 2008 R2

    Please read what I wrote

    CheckDB and CheckCatalog BEFORE the upgrade and if there are any errors do not proceed!!!

    Then, after the upgrade CheckDB with data purity, update usage, 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

    September 27, 2013 at 9:54 am

    #1654112

  • RE: What roles do I add to a new custom role, which will allow CRUD and execute on SP?

    Grant those roles to the user, you can't afaik nest roles.

    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

    September 27, 2013 at 9:51 am

    #1654110

  • RE: DBCC CHECKTABLE not reporting errors

    If there is corruption, CheckDB will always find it. If you've manually edited an unallocated page, or the middle of a page when you don't have page checksums enabled, then...

    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

    September 27, 2013 at 6:14 am

    #1653988

  • RE: Jobs to do after restoring 2000 db to 2008 R2

    BEFORE you update, run DBCC CheckDB and DBCC CheckCatalog. If there are any errors, do not go further.

    After, checkDB with data purity, update all statistics, update usage. Order doesn't really...

    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

    September 27, 2013 at 6:12 am

    #1653986

  • RE: Conversion failed when converting the varchar value ' WHERE statusID = 1' to data type int.

    More insecure dynamic SQL....

    Please, do you company a favour and stop writing dynamic SQL until you've read up and understand SQL injection.

    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

    September 27, 2013 at 1:58 am

    #1653898

  • RE: Is it possible to install adventureworks 2012 database inside SQL server 2008 R2?

    You'll need to download a SQL 2008 or earlier adventureworks. The 2012 one is a 2012 database and hence can only be restored to SQL 2012 or newer.

    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

    September 27, 2013 at 1:56 am

    #1653897

  • RE: How many CPUs needed

    Depends on the workload. There is absolutely no way to answer that question in a useful way.

    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

    September 27, 2013 at 1:54 am

    #1653895

  • RE: Query on identical objects different systems, A performs speedy with index seek, B performs poorly with clustered index scan

    johntam (9/26/2013)

    Updating stats on all of the affected tables with FULLSCAN solved the problem.

    That's what I suspected. The plans showed different estimated row counts, so that was a second indication...

    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

    September 27, 2013 at 1:50 am

    #1653893

Viewing 15 posts - 11,521 through 11,535 (of 49,552 total)