Forum Replies Created

Viewing 15 posts - 1,156 through 1,170 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    *sigh* Yup, I know the feeling.

    A client wants a SQL 2016 upgrade (from 2008 R2). I gave them a rough timeline, including analysing the environment (they don't fully...

    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

    July 10, 2017 at 7:48 am

    #1950171

  • RE: Getting error while restoring a database

    JasonClark - Monday, July 10, 2017 5:38 AM

    Either the data...

    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

    July 10, 2017 at 5:40 am

    #1950141

  • RE: Difference between stored procedure and view

    nadersam - Monday, July 10, 2017 4:13 AM

    GilaMonster - Monday, July 10, 2017 4:12 AM

    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

    July 10, 2017 at 4:22 am

    #1950132

  • RE: Difference between stored procedure and view

    If you're using ad-hoc queries, they should be parameterised, not have embedded literals. That's just good practice (and prevents SQL injection). At which point it's parameterised query vs parameterised query.

    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

    July 10, 2017 at 4:12 am

    #1950130

  • RE: Difference between stored procedure and view

    nadersam - Monday, July 10, 2017 3:53 AM

    But that takes me to another question, if some of those SQLs have variable...

    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

    July 10, 2017 at 3:57 am

    #1950128

  • RE: Difference between stored procedure and view

    They're completely different.

    Procedures are objects that you call and execute. They have cached plans.
    Views are used as part of other statements. The other statements have plans, but...

    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

    July 10, 2017 at 3:42 am

    #1950126

  • RE: Alternative Tool for SQL Profiler Trace?

    harvey007 - Sunday, July 9, 2017 1:15 PM

    https://github.com/harvey007y/IdealSqlTracer is a free open source alternative to SQL Profiler. IdealSqlTracer uses sp_trace_create, sp_trace_filter,...

    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

    July 9, 2017 at 1:50 pm

    #1950110

  • RE: Reindex, Reorganise and Statistics

    Sure. Use the sys.dm_db_stats_properties DMV to decide which stats to 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

    July 9, 2017 at 11:38 am

    #1950108

  • RE: Reindex, Reorganise and Statistics

    alex.sqldba - Sunday, July 9, 2017 5:50 AM

    I was under the impression that a reindex performed a update statistics with full scan...

    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

    July 9, 2017 at 10:25 am

    #1950103

  • RE: MCSA 2012/2014

    brk5tr - Sunday, July 9, 2017 4:20 AM

    Does anyone know how long I have to pass all 3 please?

    Until the exams...

    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

    July 9, 2017 at 4:56 am

    #1950093

  • RE: How to make design for booking hotel and program ?

    Personally I wouldn't link packages direct to hotels. Packages link to day details, which links to Hotel.

    There's way too many tables there
    Why are package and package duration...

    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

    July 8, 2017 at 2:31 pm

    #1950080

  • RE: How to make design for booking hotel and program ?

    And if it's not homework, consider getting an external consultant/contractor in who's familiar with DB design. Designing a full DB from sparse requirements is a bit beyond a forum's free...

    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

    July 8, 2017 at 7:05 am

    #1950060

  • RE: Please let me if this query is correct

    An update statement can't go into an infinite loop, not by itself. To get an infinite loop, you need a loop, ie a WHILE or a procedure that calls itself

    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

    July 8, 2017 at 7:02 am

    #1950059

  • RE: my database got in to suspect mode , i repaired it using dbcc , but i want to know the cause of error.

    First things first, repair with allow_data_loss is not the first thing you should try. It's a last resort. It loses data. How much, hard to tell.
    Restoring from a...

    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

    July 8, 2017 at 6:35 am

    #1950058

  • RE: Index Usage Details.

    SQL-DBA-01 - Friday, July 7, 2017 2:37 PM

    Is there anyway I also can check which indexes are doing more writes and which...

    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

    July 8, 2017 at 3:00 am

    #1950055

Viewing 15 posts - 1,156 through 1,170 (of 49,552 total)