Forum Replies Created

Viewing 15 posts - 6,151 through 6,165 (of 49,552 total)

  • RE: 70-461 Exam question

    Please note: 2 year old thread.

    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

    April 17, 2015 at 7:23 am

    #1791671

  • RE: Database problems

    URLT.

    Start by informing the owners and users of the database that there's a good chance that data has been lost, if not the entire DB and that they should expect...

    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

    April 17, 2015 at 6:07 am

    #1791646

  • RE: Database can't be accessed ...- OFFLINE

    In case you didn't get the hint :-), you need to check the config of the anti-virus. There are plenty of articles (including a kb article from Microsoft) that details...

    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

    April 17, 2015 at 4:17 am

    #1791621

  • RE: SQL 2012 Querying - 70-461

    nm.

    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

    April 17, 2015 at 3:40 am

    #1791614

  • RE: index file groups and files

    Sorry, what's the question?

    ON in an index creation script refers to either a filegroup or a partition scheme

    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

    April 17, 2015 at 3:04 am

    #1791608

  • RE: Corrupted SQL database after partitioning and checkdisk

    If the CheckDB repair is failing and you have no clean backup (Why oh why oh why????), then there's pretty much no option left. I hope the DB's not too...

    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

    April 17, 2015 at 3:00 am

    #1791607

  • RE: How to tell the current setting for IMPLICIT_TRANSACTIONS

    Errr, kinda

    Autocommit is the default. If implicit transactions is off, then every statement is it's own transaction that's automatically started and committed. Hence autocommit

    If you explicitly BEGIN TRANSACTION, then you...

    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

    April 17, 2015 at 2:50 am

    #1791603

  • RE: Database can't be accessed ...- OFFLINE

    WhiteLotus (4/16/2015)

    Actually the database AUTOCLOSE setting is TRUE. Would it be the cause ?

    Not a direct cause, no. But if you have a mis-configured antivirus or some other process 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

    April 17, 2015 at 2:48 am

    #1791602

  • RE: SQL 2012 Querying - 70-461

    manub22 (4/16/2015)

    For exam details and on what to prepare for 70-461 Exam check the following blog post:

    Link:http://sqlwithmanoj.wordpress.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/%5B/url%5D

    Please note, 3 year old thread. Reported for spam

    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

    April 17, 2015 at 2:44 am

    #1791599

  • RE: Difference in query output

    And I'd suggest changing to use JOINs, not the old join syntax which has been out of favour for ~15 odd years or more. It looks like you have some...

    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

    April 17, 2015 at 2:44 am

    #1791598

  • RE: Attempting to replace not in with left outer join

    jackimo (4/16/2015)

    Another interesting bit is that if I use the left outer join with the query hint - OPTION (HASH JOIN), the query runs in about 1/3 the time. ...

    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

    April 16, 2015 at 9:29 am

    #1791394

  • RE: Clustered Index Defrag not working

    SQL Bandit (4/15/2015)

    Its not a huge issue the table only has 348 records.

    And there's the reason.

    Until a table hits at least one extent in size (8 pages, 64kB), a defrag...

    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

    April 15, 2015 at 6:31 am

    #1791070

  • RE: Quick question about indexes.

    Can you suggest to those who are responsible for it that storing dates in anything other than one of the date/datetime data types is... not ideal?

    In the mean time, 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

    April 15, 2015 at 6:20 am

    #1791063

  • RE: Quick question about indexes.

    No, it will not (well, maybe for a scan, but not for a seek).

    Aside, why are you storing a date in a string column?

    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

    April 15, 2015 at 6:13 am

    #1791061

  • RE: Attempting to replace not in with left outer join

    If you're trying to improve performance, these may be of interest

    http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

    http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

    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

    April 15, 2015 at 6:11 am

    #1791060

Viewing 15 posts - 6,151 through 6,165 (of 49,552 total)