Forum Replies Created

Viewing 15 posts - 241 through 255 (of 5,841 total)

  • RE: Reasons to have Mirroring AND local backups?

    --3) Logs bloating, therefore backups maintained (which IS the case there) 

    There is NO reason for log bloating with proper backup strategies (which perforce should be happening with log...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    July 4, 2017 at 8:59 am

    #1949340

  • RE: Cross Apply Timing Out on Large (1bn rows) Table

    SirWittles - Monday, July 3, 2017 10:18 PM

    I have a small table Members (1000 rows) that contains member information.
    I have a large...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    July 4, 2017 at 8:56 am

    #1949339

  • RE: Splitting TempDB

    Mike Scalise - Friday, June 30, 2017 6:49 PM

    Kevin,

    Thank you for the response and information. I do have a few follow-up...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    July 1, 2017 at 3:20 pm

    #1949059

  • RE: Splitting TempDB

    Mike Scalise - Friday, June 30, 2017 8:04 AM

    Hi, I noticed yesterday that I have the following setup for one of my...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 30, 2017 at 10:37 am

    #1948976

  • RE: More problems with SQL 2014's new Cardinality Estimator

    I just noticed the part about previously using triggers to enforce complex logic and switching to using FKs on complex computed persisted columns. Without details, my gut tells me the...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 30, 2017 at 7:32 am

    #1948933

  • RE: More problems with SQL 2014's new Cardinality Estimator

    GilaMonster - Thursday, June 29, 2017 9:40 AM

    julian.fletcher - Thursday, June 29, 2017 9:30 AM

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 29, 2017 at 12:48 pm

    #1948811

  • RE: More problems with SQL 2014's new Cardinality Estimator

    No time to dig into the details here, but every single time I have seen soft-deletes (or active flags, et al) at clients over the years if said fields weren't...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 29, 2017 at 7:57 am

    #1948735

  • RE: INCLUDE columns in nonclustered index which are in PK

    Xedni - Tuesday, June 27, 2017 9:38 AM

    Adi Cohn-120898 - Tuesday, June 27, 2017 9:30 AM

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 27, 2017 at 11:20 am

    #1948425

  • RE: Tempdb

    Tempdb file(s) should be EXACTLY the same size with EXACTLY the same growth increments. It is all but mandatory to have trace flags 1117 and 1118 enabled globally on every...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 26, 2017 at 10:40 am

    #1948194

  • RE: Database engine tuning advisor

    Grant Fritchey - Thursday, June 22, 2017 7:57 AM

    Eirikur Eiriksson - Thursday, June 22, 2017 7:36 AM

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 22, 2017 at 12:01 pm

    #1947826

  • RE: Storing File in Table

    There are WAY too many variables and needs for such a project to cover them all in a forum post and be able to offer sound and well-reasoned advice. Sorry....

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 22, 2017 at 11:50 am

    #1947824

  • RE: Merging two large tables physically in SQL 2014

    Robin35 - Monday, June 19, 2017 8:53 AM

    Hello,

    I have a requirement to merge two large tables with redundant data.

    Table...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 19, 2017 at 2:16 pm

    #1947318

  • RE: Storing File in Table

    Rechana Rajan - Monday, June 19, 2017 2:21 AM

    Which is the best option to save files in a table.

    Varbinary(max) or Varbinary (Max)...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 19, 2017 at 5:52 am

    #1947231

  • RE: best way to learn T-SQL

    coool_sweet - Sunday, May 28, 2017 6:31 AM

    hi

    so i want to know what is best way to learn TSQL, like i know...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 28, 2017 at 9:23 am

    #1944444

  • RE: Windows Server 2016 Standard and Disk Alignment and Offset.

    cmp119 - Wednesday, May 24, 2017 2:45 PM

    I am prepping a Windows Server 2016 box to install SQL Server 2014 Standard.  I...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 24, 2017 at 6:35 pm

    #1944096

Viewing 15 posts - 241 through 255 (of 5,841 total)