Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 5,841 total)

  • RE: Pivot EDI EAV type table

    al_nick (9/18/2013)

    Hi all-

    I'm trying to flatten this table into something like the second table. Any suggestions would be greatly appreciated.

    Nick

    See the attached table in Excel.

    Entity | Attribute ...

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

    September 18, 2013 at 9:13 pm

    #1651356

  • RE: Can't we rely on execution plan for performance !!!

    There are SOOOO many things that come into play with the term "query performance". And which one(s) of those things is MOST important for a GIVEN QUERY EXECUTION can...

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

    September 17, 2013 at 10:18 am

    #1650847

  • RE: Encrypting a Coulmn in SQL Server 2012

    Google is your friend: http://lmgtfy.com/?q=sql+server+column+level+encryption

    Oh, and Books Online is a great resource too!

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

    September 14, 2013 at 9:48 am

    #1650238

  • RE: store proc based logical issue

    GilaMonster (9/13/2013)

    TheSQLGuru (9/13/2013)

    4) The WITH (ROWLOCK) hint could be helpful. See Books Online for info.

    Or could make it worse. 15000 rows locked at the row level is above the...

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

    September 14, 2013 at 7:17 am

    #1650229

  • RE: store proc based logical issue

    ekant_alone (9/13/2013)

    I have a job which runs a store procedure. The proc is something like

    BEGIN

    STEP 1) Archive records into Table A..... (around 15K records)

    from TABLE B

    STEP 2) Delete some...

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

    September 13, 2013 at 9:27 am

    #1650078

  • RE: Max Consecutive Dates Without an Exclusion Date

    I totally don't understand what the output you expect for this. Please provide the ACTUAL output you expect for your given sample. You may need to set up...

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

    September 13, 2013 at 9:21 am

    #1650076

  • RE: Help on a complex query that may be easier than what we have??

    See if one of these links can help (from SSC.com's own Jeff Moden):

    http://www.sqlservercentral.com/articles/94040/

    http://www.sqlservercentral.com/articles/94570/

    http://www.sqlservercentral.com/articles/72503/

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

    September 12, 2013 at 12:03 pm

    #1649830

  • RE: Query plan parameter run time value not appearing in sys.dm_exec_query_plan

    HAH - good one Grant!! And Erland is correct about Profiler.

    Oh, and I LOVE DBSophic's Qure product!! That thing makes me look like a WIZARD at...

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

    September 11, 2013 at 1:57 pm

    #1649486

  • RE: copy files through network to another server

    sql_novice_2007 (9/11/2013)

    Do I need to install the litespeed on the server or is it ok if I install it on my machine and compress the backup file from my machine?

    All...

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

    September 11, 2013 at 8:31 am

    #1649335

  • RE: Tempdb data file fills up very often

    p.swathi4 (8/19/2013)

    Can you suggest me the best autogrowth settings on the tempdb files

    In this particular case I would have NO autogrowth. Make your tempdb file(s) consume the ENTIRE 30GB...

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

    September 11, 2013 at 6:59 am

    #1649268

  • RE: GEO - Spatial

    I think .STContains() is the proper function to use.

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

    September 11, 2013 at 6:54 am

    #1649264

  • RE: Query plan parameter run time value not appearing in sys.dm_exec_query_plan

    Grant Fritchey (9/11/2013)

    Erland Sommarskog (9/10/2013)

    Grant Fritchey (9/10/2013)

    The only way to get run-time information is to capture the plan while executing using SSMS or extended events.

    You can also capture them with...

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

    September 11, 2013 at 6:38 am

    #1649252

  • RE: Become a License Reseller or Not?

    If you can keep it SIMPLE, then this is something you might pursue. It could improve your sales closure rate by reducing another impediment/hassle. But know that licensing...

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

    September 11, 2013 at 6:32 am

    #1649250

  • RE: Help On Query

    For those using ROW_NUMBER, if you want users having 2 OR MORE roles, shouldn't the filter be rownum >= 2 instead of just rownum = 2?

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

    September 10, 2013 at 11:22 am

    #1648981

  • RE: Sql Query

    Since you are on SQL 2012, new Windowing Functionality is available too. Here is a solution based on that. Note you may want to add in columns and/or...

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

    September 9, 2013 at 8:03 am

    #1648550

Viewing 15 posts - 2,371 through 2,385 (of 5,841 total)