Forum Replies Created

Viewing 15 posts - 781 through 795 (of 2,458 total)

  • RE: Using reserved words as column names

    Lynn Pettis (4/29/2016)

    Alan.B (4/28/2016)

    Something like this would not work:

    CREATE TABLE LovelyTable(

    Join varchar(50)

    )

    SQL Server is generally very good at dealing with reserved keywords as column names but its a terrible practice....

    "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

    April 29, 2016 at 7:01 pm

    #1875739

  • RE: XML to SQL tables

    Sergiy (4/28/2016)

    Jeff Moden (4/28/2016)

    A lot of people incorrectly consider CROSS APPLY to be RBAR because it behaves like a correlated subquery when single row returns are produced by CROSS APPLY....

    "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

    April 28, 2016 at 8:35 pm

    #1875450

  • RE: Connection string question

    SQL!$@w$0ME (4/28/2016)

    Thanks, does using fqdn uses only tcp/ip protocol on sqlclient connectivity not named pipes?

    I believe so.

    "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

    April 28, 2016 at 5:36 pm

    #1875437

  • RE: Specialist or Generalist

    Yet Another DBA (4/27/2016)

    jeff.mason (4/26/2016)

    Microsoft has made SQL Server so big that even "generalists" are usually "specialists". I know of few people who are experts in the DB engine,...

    "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

    April 28, 2016 at 5:15 pm

    #1875434

  • RE: Certification for MSBI

    To clarify, the Microsoft Certified Solutions Expert cert has two paths: Data and BI.

    "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

    April 28, 2016 at 4:39 pm

    #1875429

  • RE: Connection string question

    If you're using the default port number then you don't need to include it in your connection string. If your DNS server resolves the server name without the fqdn then...

    "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

    April 28, 2016 at 4:31 pm

    #1875427

  • RE: Expression Help

    SilverBack (4/28/2016)

    In an Expression

    pietlinden (4/28/2016)

    multiple values where? In a multi-select parameter? In your report somewhere?

    What do those values mean? Where are they coming from? How did they get there?...

    "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

    April 28, 2016 at 3:27 pm

    #1875410

  • RE: t-sql 2012 change query

    Those ORDER BY clauses in your SELECT INTO queries aren't doing you any favors.

    "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

    April 28, 2016 at 2:37 pm

    #1875406

  • RE: Are the posted questions getting worse?

    Phil Parkin (4/28/2016)

    Does anyone have The Ball today?

    I was thinking

    PRINT '2016 Total: 700'

    "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

    April 28, 2016 at 2:23 pm

    #1875402

  • RE: Expression Help

    SilverBack (4/28/2016)

    "MSC000000002"&"C00303582"&"MSC000005747"&"MSC000006211"&"MSC000000067"&"C01938137"&"MSC000000061"

    Still returns a blank set. Where as Just one value returns data

    Try

    ="MSC000000002"&"C00303582"&"MSC000005747"&"MSC000006211"&"MSC000000067"&"C01938137"&"MSC000000061"

    "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

    April 28, 2016 at 2:11 pm

    #1875396

  • RE: Most unhelpful error message?

    There's one out there that I've seen since SQL Server 6.5. It reads something like:

    The query failed to process for the following reason(s):

    The operation completed successfully

    The one that drives me...

    "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

    April 28, 2016 at 12:55 pm

    #1875382

  • RE: Expression Help

    DUPLICATE POST, direct replies here.

    "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

    April 28, 2016 at 12:52 pm

    #1875378

  • RE: Using reserved words as column names

    Sioban Krzywicki (4/28/2016)

    Yeah, but this is an existing column that I want to rename and they're going to want a performance reason

    There's no performance benefit to using/not using reserved words...

    "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

    April 28, 2016 at 12:50 pm

    #1875377

  • RE: Expression Help

    Something like this perhaps...

    "MSC000000002" & "C00303582" &"MSC000005747" &....

    "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

    April 28, 2016 at 12:43 pm

    #1875370

  • RE: Using reserved words as column names

    Something like this would not work:

    CREATE TABLE LovelyTable(

    Join varchar(50)

    )

    SQL Server is generally very good at dealing with reserved keywords as column names but its a terrible practice. Column names like...

    "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

    April 28, 2016 at 12:41 pm

    #1875369

Viewing 15 posts - 781 through 795 (of 2,458 total)