Forum Replies Created

Viewing 15 posts - 6,961 through 6,975 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    I do not see this ending well... http://www.sqlservercentral.com/Forums/Topic1646368-1291-1.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

    December 24, 2014 at 9:18 am

    #1766352

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    I'm going to be blunt and probably a little rude.

    Your chances are not good. Sure, you may well get something that mostly works most of the time by March. With...

    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

    December 24, 2014 at 9:15 am

    #1766351

  • RE: performance optimization of selecting more than 140 columns with over 3000 MB of data

    3GB of data in 26 seconds, that's fast!

    What is the end user going to do with 100 000 rows?

    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

    December 24, 2014 at 8:54 am

    #1766348

  • RE: SQL Sever has encountered the following error

    What are you trying to do?

    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

    December 24, 2014 at 8:42 am

    #1766347

  • RE: Several questions concerning data integrity

    kaplan71 (12/24/2014)

    1. The "Verify backup integrity" option within SQL Studio will be checked off for the Full, Differential, and Transaction log backups. Does this option do a Checksum and/or Cyclical...

    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

    December 24, 2014 at 8:41 am

    #1766346

  • RE: Best scenario for high DB availability

    choudhury.pradeep (12/24/2014)

    What I suppose to do if I find my DB taking a long time in recovery state after a server reboot?

    Well, I said earlier:

    The antivirus (which as mentioned earlier...

    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

    December 24, 2014 at 7:17 am

    #1766333

  • RE: Best scenario for high DB availability

    Shafat Husain (12/24/2014)

    We have set our DB for Simple recovery and do full DB backup in night 2:00 AM, Differential backup every 6 hrs. As its simple recovery no 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

    December 24, 2014 at 7:13 am

    #1766331

  • RE: is bulk logged recovery model support point in time recovery

    Yes, Bulk-logged recovery model does support point in time recovery, providing there are no minimally logged operations within the log interval containing the time you are trying to restore to.

    Let's...

    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

    December 24, 2014 at 2:15 am

    #1766310

  • RE: Are the posted questions getting worse?

    http://www.sqlservercentral.com/Forums/Topic1646163-391-1.aspx

    I'll just be in the corner sobbing softly...

    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

    December 23, 2014 at 2:05 pm

    #1766264

  • RE: Warning: The join order has been enforced because a local join hint is used. ( two views )

    That's changed the logic (changed an outer join to an inner join), and changed it to a 20+ year old form of SQL. You needed to remove the join *hint*,...

    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

    December 23, 2014 at 2:02 pm

    #1766263

  • RE: Warning: The join order has been enforced because a local join hint is used. ( two views )

    It is not an error.

    It is a warning and if the application is breaking, then the application is at fault. The query will run fine and will return data.

    You 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

    December 23, 2014 at 10:38 am

    #1766244

  • RE: Date column with 1900-01-01 value

    Can you not use a WHERE clause to filter out the rows with the 1900-01-01 date?

    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

    December 23, 2014 at 7:14 am

    #1766189

  • RE: Warning: The join order has been enforced because a local join hint is used. ( two views )

    It's not an error, it's a warning and it's there because one of your queries is using a join hint, like INNER MERGE JOIN or INNER HASH JOIN or LEFT...

    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

    December 23, 2014 at 7:04 am

    #1766188

  • RE: update statistics on frequently updated tables

    Stats only get updated when they are needed. If no query is requesting those stats for optimisation purposes, they won't get updated no matter how out of date they 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

    December 23, 2014 at 7:02 am

    #1766186

  • RE: Differences between SQL versions

    Try google. For the major versions "New features in SQL Server <version>" will get you the full list. For the service packs and CUs, "Fixes in SQL Server <version> 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

    December 23, 2014 at 5:14 am

    #1766167

Viewing 15 posts - 6,961 through 6,975 (of 49,552 total)