Forum Replies Created

Viewing 15 posts - 21,016 through 21,030 (of 49,552 total)

  • RE: Partitions, SANS and Logical Drives Setup

    Do bear in mind that this thread is 3 years old and the advice may no longer be correct.

    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

    January 15, 2012 at 7:37 am

    #1433826

  • RE: I've plan to apply Table Partitioned

    Little Nick (1/15/2012)

    If 1 table contains 70 million rows, what should I do? As a result, I can query very fast

    Write optimal queries that have appropriate indexes. I can't give...

    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

    January 15, 2012 at 7:27 am

    #1433825

  • RE: learn vb.net or c# in sql server

    meridius10 (1/15/2012)

    - Is the learning curve from VBA to VB.NET easier (I'm guessing this answer is YES!...)?

    Yes.

    - Is C# used more than VB.NET in SQL Server applications?

    It appears that 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

    January 15, 2012 at 7:24 am

    #1433824

  • RE: Running Full and Transaction-Log Backups Concurrently - Any Implications for Database Recovery?

    Marios Philippopoulos (1/15/2012)

    I guess my fear is that due to some freak timing between the log and full backups, the log sequence may get "corrupted" or unrecoverable.

    Unless you're doing...

    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

    January 15, 2012 at 7:17 am

    #1433821

  • RE: I've plan to apply Table Partitioned

    p.s. have a read through these two: http://msdn.microsoft.com/en-us/library/ms345146.aspx, http://msdn.microsoft.com/en-us/library/dd578580.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

    January 15, 2012 at 4:36 am

    #1433802

  • RE: I've plan to apply Table Partitioned

    Then forget about partitioning (at least for now).

    While partitioning can improve query performance the queries mostly have to be of particular forms to take advantage of it (partition elimination)...

    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

    January 15, 2012 at 4:31 am

    #1433801

  • RE: Perfromance query tuning help

    Two problems immediately.

    1) You have nolock everywhere. Either no one cares about the accuracy of the data or no one knows that nolock is not a go-faster switch. (see this...

    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

    January 15, 2012 at 3:52 am

    #1433795

  • RE: I've plan to apply Table Partitioned

    Before you spend lots of time doing this... What is the goal for partitioning? What is it you're trying to achieve? What problem are you trying to alleviate?

    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

    January 15, 2012 at 3:49 am

    #1433794

  • RE: Use of NoLock in Select Distinct yield duplicate

    jpdp101 (1/14/2012)

    does this mean the query did an Index Scan ? and since it knows that the involve columns in the SELECT DISTINCT are Unique Index, it just disregard the...

    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

    January 15, 2012 at 3:47 am

    #1433793

  • RE: .mdf

    chrisians2929 (1/14/2012)

    what about encapsulation?

    What about it? Not really a DB term.

    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

    January 15, 2012 at 3:43 am

    #1433791

  • RE: Msg 1204 Lock Error

    Jako de Wet (1/14/2012)

    Hi GilaMonster

    Both db's are on the same server, I was using a normal SQL Script Task, will change it to a DataFlow Task.

    I rebuilt the clustered 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

    January 15, 2012 at 3:42 am

    #1433790

  • RE: Msg 1204 Lock Error

    Are there any traceflags enabled on either of the servers?

    You say you're using INSERT INTO ... SELECT FROM..., so are you not using a standard data flow task (data source,...

    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

    January 14, 2012 at 3:06 pm

    #1433759

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/14/2012)

    However, I have heard some companies send people into the exams, and have them sneak out papers for the exam to better simulate what 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

    January 14, 2012 at 1:45 pm

    #1433752

  • RE: 70-432 exam

    The MCDBA certification was retired 2 or 3 years ago, it was a SQL 2000 certification.

    For info on the 70-432 exam, see http://www.microsoft.com/learning/en/us/Exam.aspx?ID=70-432&Locale=en-us

    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

    January 14, 2012 at 12:16 pm

    #1433734

  • RE: Microsoft Certifications

    The MCDBA certification was retired 2 or 3 years ago, it was a SQL 2000 certification.

    For the 2005 and 2008 certifications, see http://www.microsoft.com/learning/en/us/certification/cert-sql-server.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

    January 14, 2012 at 12:14 pm

    #1433733

Viewing 15 posts - 21,016 through 21,030 (of 49,552 total)