Forum Replies Created

Viewing 15 posts - 8,116 through 8,130 (of 8,753 total)

  • RE: Sp & parameters

    ramana3327 (5/31/2014)

    Hi thanks for your reply.

    Code is confidential. So I am unable to provide the execution plan but I can explain what is the problem.

    I have a Stored procedure and...

    May 31, 2014 at 1:21 pm

    #1718034

  • RE: Vulnerability scan report

    You have to look at which kind of threats these vulnerabilities are! If it is a local one, normally you would have more problems already as the attacker would need...

    May 31, 2014 at 12:25 pm

    #1718028

  • RE: SSMS 2014 - anything new and noteworthy over SSMS 2012?

    The most noticeable thing so far is that it is ......:arrow:faster!

    😎

    May 31, 2014 at 12:01 pm

    #1718027

  • RE: SSIS PROBLEM

    baddulas (5/31/2014)

    Hi Steve,

    I am getting following error.

    [Execute Process Task] Error: In Executing "C:\Program Files\WinRAR\Rar.exe" "a D:\ZIPPINGFILE\20140528_225754.txt.zipD:\FLATFILEGENERATE\20140528_225754" at "D:\FLATFILEGENERATE\", The process exit code was "9" while the expected was "0".

    Looks like...

    May 31, 2014 at 11:52 am

    #1718026

  • RE: Sp & parameters

    Quick question, can you provide the procedure source code and the execution plans? As Jeff said earlier, without further information it is hard to tell what is going on?

    Furthermore do...

    May 31, 2014 at 11:38 am

    #1718025

  • RE: Sp & parameters

    Jeff Moden (5/30/2014)

    Eirikur Eiriksson (5/30/2014)

    Unfortunately that's not too useful, it will show if the parameter is nullable but that's about it.

    I just love fully documented and supposedly supported features that...

    May 31, 2014 at 12:12 am

    #1718006

  • RE: Sp & parameters

    Jeff Moden (5/30/2014)

    ramana3327 (5/30/2014)

    Hi,

    I am working with SP. How can we find out values of parameters when the SP is executed with the default values?

    If I understand your question correctly,...

    May 30, 2014 at 10:57 pm

    #1717998

  • RE: Sp & parameters

    ramana3327 (5/30/2014)

    Hi,

    I am working with SP. How can we find out values of parameters when the SP is executed with the default values?

    You will have to dissect the procedure as...

    May 30, 2014 at 10:17 pm

    #1717992

  • RE: SQL Challenge: Updating parts of fields.

    Raymond.Pietrzak (5/30/2014)

    I was able to write my query against the VarChar(4000) data type. This worked.

    Update [WBPROD].[dbo].[TASK_SCHEDULE]

    Set TSKSCD_DESCRIPTION = Replace(TSKSCD_DESCRIPTION, '<timezoneId>0</timezoneId><timezone>America/New_York</timezone>', '<timezoneId>1</timezoneId><timezone>America/Chicago</timezone>')

    Update [WBPROD].[dbo].[TASK_SCHEDULE]

    Set TSKSCD_DESCRIPTION = Replace(TSKSCD_DESCRIPTION,

    ...

    May 30, 2014 at 10:14 pm

    #1717991

  • RE: Getting first and last value for every group.

    Since this is a 2012 thread, how about the window functions?

    😎

    create table #sampledata

    (

    userId int,

    BaseYear int,

    TotalSales float

    )

    insert into #sampledata

    select 1,2008,25000 union

    select 1,2009,22500 union

    select 1,2010,23400 union

    select 1,2011,26700 union

    select 1,2012,25200 union

    select 2,2008,25050...

    May 30, 2014 at 10:05 am

    #1717864

  • RE: STintersect with buff

    I have found that one should generally (as much as I dislike generalization) avoid AUTO_GRID.

    😎

    May 29, 2014 at 1:57 pm

    #1717566

  • RE: Just curious, what are your SQL pet peeves ?

    samalex (5/29/2014)

    Everyone has their own style of writing code and doing things, but there are some pet peeves I've developed over the years, especially when I review other people's code,...

    May 29, 2014 at 1:54 pm

    #1717564

  • RE: Just curious, what are your SQL pet peeves ?

    Sean Lange (5/29/2014)

    samalex (5/29/2014)

    Wow, I agree with literally 100% of what you guys have entered, including 'sprocs'. We have a few non-DBA's who use this verbiage, and it always makes...

    May 29, 2014 at 1:32 pm

    #1717553

  • RE: Just curious, what are your SQL pet peeves ?

    GilaMonster (5/29/2014)

    Developers who think they know more than I do. 😉 :hehe:

    Ouch..... good thing that my title is no longer a "developer" :-P:-P

    May 29, 2014 at 12:54 pm

    #1717525

  • RE: MAX Degree of Parallelism Option Not working in Resource Governer

    adhiman (5/29/2014)

    I am running a query on SQL 2012 Server with the Resource governer setup for my account to have Max DOP option set to 1.

    The query still runs...

    May 29, 2014 at 12:51 pm

    #1717523

Viewing 15 posts - 8,116 through 8,130 (of 8,753 total)