Forum Replies Created

Viewing 15 posts - 271 through 285 (of 5,841 total)

  • RE: Dynamic SQL - Run formula in field

    You need to store mutliple associated pieces of data: table that has the field, field, operator/code. Then you need code that will reconstruct valid TSQL from this at run-time. This...

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

    May 8, 2017 at 12:00 pm

    #1941657

  • RE: Best Practices for tables with VARBINARY(MAX)

    kramaswamy - Monday, May 8, 2017 11:25 AM

    Hi all,

    Was wondering whether anyone had any recommendations, or references to articles with recommendations, regarding...

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

    May 8, 2017 at 11:58 am

    #1941655

  • RE: COMPUTED COLUMN needing to retain value

    Zososql - Wednesday, May 3, 2017 10:37 PM

    I need to restore a value in my travellog table by adding a computed column...

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

    May 4, 2017 at 9:14 am

    #1941125

  • RE: Do you need an order by when selecting TOP N from a clustered index?

    Feel free to ignore everything Joe wrote Rob.

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

    May 2, 2017 at 3:51 pm

    #1940801

  • RE: Query Performance Standards - Overall Per DB

    chris.munsell - Monday, May 1, 2017 2:08 PM

    Thank you Jeff. I will look into using this. I have long thought that ORM...

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

    May 1, 2017 at 2:47 pm

    #1940611

  • RE: How to manage temporary tables

    hurricaneDBA - Saturday, April 29, 2017 3:35 AM

    Hi Everyone
    Just to give an update i disabled all the stored procedures which were...

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

    April 29, 2017 at 7:31 am

    #1940484

  • RE: Single head blocker locking other DBs

    If Microsoft can't help (and I have been brought behind them a number of times over the years), there are several good consultants on SSC.com you can engage to help...

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

    April 28, 2017 at 6:20 pm

    #1940457

  • RE: Stored Procedure for Dynamic Query in Sql server

    Use one TVP per ID/Value sets. Then it is a join on both columns for each set. easy/peasy to do. Don't have time to think if this is the only/best...

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

    April 27, 2017 at 1:29 pm

    #1940307

  • RE: How to manage temporary tables

    My quick read says this is a no-brainer: you KNOW how big things get due to repeatedly seeing it get that big (presumably after shrinks - BAD). So simply make...

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

    April 27, 2017 at 10:32 am

    #1940268

  • RE: Stored Procedure for Dynamic Query in Sql server

    Take a look at Table Valued Parameters in Books Online maybe??

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

    April 27, 2017 at 10:29 am

    #1940266

  • RE: TEMPDB log growing HUGE

    Is your Always On stuff behind?

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

    April 27, 2017 at 10:28 am

    #1940265

  • RE: Best monitoring tool

    Here is an awesome and very capable FREE monitoring tool:

    DatabaseHealth

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

    April 27, 2017 at 10:27 am

    #1940264

  • RE: DMV sys.dm_db_index_physical_stats: Detailed vs. Limited

    Did you Binoogle that DMV? Did you read Books Online about it??

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

    April 27, 2017 at 10:23 am

    #1940262

  • RE: Query Performance Standards - Overall Per DB

    chris.munsell - Wednesday, April 26, 2017 9:26 AM

    One of our Dev's suggested that we replace our SQL environment with Intel Optane...

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

    April 26, 2017 at 1:13 pm

    #1940093

  • RE: Query Performance Standards - Overall Per DB

    chris.munsell - Wednesday, April 26, 2017 8:03 AM

    Good morning fellow SQL server folks!

    I have a general question regarding Query Performance standards....

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

    April 26, 2017 at 9:08 am

    #1940001

Viewing 15 posts - 271 through 285 (of 5,841 total)