Forum Replies Created

Viewing 15 posts - 2,161 through 2,175 (of 2,643 total)

  • RE: SQL Server stored procedures fast in SQL but slow when called by ASP.NET

    jkramprakash - Sunday, September 23, 2018 4:37 AM

    Query inside the stored procedure giving result fast (twenty seven  thousand records in 2 seconds)...

    September 24, 2018 at 6:44 am

    #2006721

  • RE: Are the posted questions getting worse?

    TomThomson - Sunday, September 23, 2018 6:20 PM

    patrickmcginnis59 10839 - Tuesday, September 18, 2018 6:55 AM

    September 24, 2018 at 5:34 am

    #2006702

  • RE: Convert Date

    Jeff Moden - Friday, September 21, 2018 9:22 AM

    Jonathan AC Roberts - Friday, September 21, 2018 9:04...

    September 21, 2018 at 9:51 am

    #2006599

  • RE: move sql database files to bigger drive

    HBK_4700 - Friday, September 21, 2018 9:29 AM

    Hi, I am in a situation of refreshing a lower environment database with production backup....

    September 21, 2018 at 9:35 am

    #2006592

  • RE: Convert Date

    Jeff Moden - Friday, September 21, 2018 8:41 AM

    Jonathan AC Roberts - Friday, September 21, 2018 7:06...

    September 21, 2018 at 9:04 am

    #2006588

  • RE: Convert Date

    below86 - Friday, September 21, 2018 7:50 AM

    You could try this:
    CONVERT(CHAR(11), DateIn, 107) AS DateIn

    That's nearly there but it also adds a...

    September 21, 2018 at 8:07 am

    #2006565

  • RE: Convert Date

    craig.jenkins - Friday, September 21, 2018 6:53 AM

    Hi Guys,
    Is there a way to convert the Datein in the below to show this...

    September 21, 2018 at 7:06 am

    #2006544

  • RE: Help on query

    Have you tried using DBCC CHECKCONSTRAINTS?

    September 21, 2018 at 4:27 am

    #2006533

  • RE: Shrink data file issue

    WhiteLotus - Monday, September 17, 2018 7:52 PM

    Hi All 

    I shrank data file in a production database . at first the size...

    September 21, 2018 at 3:50 am

    #2006530

  • RE: COUNT(*) returns wrong value

    sk 939 - Thursday, September 20, 2018 12:38 AM

    Hi

    I have some difficulties getting a COUNT(*) on my below SQL Query, atleast one...

    September 20, 2018 at 3:44 pm

    #2006504

  • RE: Audit In SQL Server

    Admingod - Thursday, September 13, 2018 3:11 PM

    I need to save an audit trail of changes made to some tables.

    Firstly I agree...

    September 19, 2018 at 5:16 am

    #2006240

  • RE: Rewrite query

    Jason A. Long - Monday, September 17, 2018 2:55 PM

    Jonathan AC Roberts - Monday, September 17, 2018...

    September 17, 2018 at 5:24 pm

    #2006068

  • RE: Rewrite query

    Jason A. Long - Monday, September 17, 2018 1:51 PM

    Why would you not assume that? 
    Given that it's a temp table there's a...

    September 17, 2018 at 2:28 pm

    #2006052

  • RE: Rewrite query

    Jason A. Long - Monday, September 17, 2018 1:51 PM

    Why would you not assume that? 
    Given that it's a temp table there's a...

    September 17, 2018 at 2:28 pm

    #2006051

  • RE: Rewrite query

    Jason A. Long - Monday, September 17, 2018 11:54 AM

    It's only the fastest because it was the only horse in the...

    September 17, 2018 at 12:48 pm

    #2006022

Viewing 15 posts - 2,161 through 2,175 (of 2,643 total)