Forum Replies Created

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

  • RE: Need guidance...

    I would start by separating the transactional data from the reporting data if that hasn't already been done.

    For example, take this:

    - Excel connected to the live system doing queries...

    "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

    May 1, 2016 at 10:31 pm

    #1875824

  • RE: Read and parse XML -- tsql

    What format is the XML in? Is it in a table? An external file?

    If you can handle it as a variable this will do the trick.

    -- your lookup...

    "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

    May 1, 2016 at 10:18 pm

    #1875823

  • RE: This is very worrying and if it continues

    Spam reported.

    "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

    May 1, 2016 at 10:31 am

    #1875798

  • RE: What is the difference between SSRS and Power BI

    SSRS is part of the Microsoft "BI stack" and is part of SQL Server. When you install SQL Server you have the option to include different parts of the 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

    May 1, 2016 at 10:28 am

    #1875797

  • 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

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