Forum Replies Created

Viewing 15 posts - 301 through 315 (of 2,462 total)

  • RE: SQL Server primary key on float data type

    The direct answer is NO. Float (53) is not 8 bytes and imprecise as has already been mentioned. Another problem is that, although, your existing data is int, using float...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 28, 2017 at 11:07 am

    #1935325

  • RE: SELECT @local_variable '=' Versus SELECT @local_variable '+='

    No problem. Glad to help.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 23, 2017 at 3:54 pm

    #1934668

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson - Thursday, March 23, 2017 3:12 AM

    Anyone with an iPhone and iCloud should have a look at this...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 23, 2017 at 10:57 am

    #1934572

  • RE: Load data in chunks daily

    jonas.gunnarsson 52434 - Thursday, March 23, 2017 7:36 AM

    may be the following can help
    importing large SQL files

    That link is for...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 23, 2017 at 8:21 am

    #1934520

  • RE: Extracting Number from Text

    There's many ways to tackle this, here's a few:Sample data

    CREATE TABLE #TEMP(ID Varchar(200));

    INSERT #TEMP
    VALUES ('ABC205916_DAN'),('ABC243296'),('ABC222249_DAN25'),('IN217465_v99'),('ABC#243296');
    GO

    If it's...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 23, 2017 at 6:40 am

    #1934494

  • RE: Problem running cmd file from SQL Agent

    The cmd file works no problem from the command line


    You are running the file locally or on the remote system? I don't know anything about Putty and,...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 22, 2017 at 9:07 pm

    #1934435

  • RE: SELECT @local_variable '=' Versus SELECT @local_variable '+='

    Correct that this has nothing to do with joins or anything that Joe was talking about. 

    The += syntax is an example of a compound assignment operator; These...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 22, 2017 at 6:58 pm

    #1934430

  • RE: Windows Functions: Tell me when that changes.

    Luis Cazares - Wednesday, March 22, 2017 1:17 PM

    bc_ - Wednesday, March 22, 2017 12:43 PM
    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 22, 2017 at 1:47 pm

    #1934384

  • RE: Are the posted questions getting worse?

    Lynn - I'm good at dealing with XML in SQL too. Post the code and I'll also be happy to take a look.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 18, 2017 at 3:11 pm

    #1933865

  • RE: Are the posted questions getting worse?

    Jeff Moden - Wednesday, March 15, 2017 8:49 PM

    Alan.B - Wednesday, March 15, 2017 3:01 PM
    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 15, 2017 at 10:12 pm

    #1933396

  • RE: Are the posted questions getting worse?

    Lowell - Wednesday, March 15, 2017 1:32 PM

    Sean Lange - Wednesday, March 15, 2017 12:50 PM
    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 15, 2017 at 3:01 pm

    #1933360

  • RE: Are the posted questions getting worse?

    Luis Cazares - Wednesday, March 15, 2017 12:32 PM

    I was looking for a reference to reply on a thread and found this...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 15, 2017 at 12:37 pm

    #1933328

  • RE: Converting Stored Procedure to Function

    Sergiy - Wednesday, January 25, 2017 3:19 PM

    I'm currently thinking of converting a TVF to a stored procedure.
    There are complications, especially in...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 25, 2017 at 9:27 pm

    #1924998

  • RE: Comma separated list

    Sergiy - Wednesday, January 25, 2017 3:32 PM

    Try not to use DISTINCT.
    Ever.
    Just forget this keyword exists 

    As for this query - keep in...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 25, 2017 at 9:14 pm

    #1924997

  • RE: COUNTING TIME DIFFERENCE IN YEAR, MONTH, DAYS

    ChrisM@Work - Thursday, January 19, 2017 5:41 AM

    Deny Christian - Monday, January 16, 2017 1:55 AM
    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 25, 2017 at 8:59 pm

    #1924996

Viewing 15 posts - 301 through 315 (of 2,462 total)