Forum Replies Created

Viewing 15 posts - 766 through 780 (of 2,458 total)

  • RE: Potential presentation idea: Knowing your limits: are you in over your head?

    I think this is a common problem in the data world for sure.

    It all comes down to self-awareness and communication. Knowing your strengths, weaknesses and limitations, then knowing how...

    "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 3, 2016 at 12:35 pm

    #1876390

  • RE: determine SQL maintenance plan creator

    lawson2305 (5/3/2016)

    Well it helps if it is accurate which I'm guessing it is. The two scheduled jobs that exist in the SQL agent job list for these maintenance plans...

    "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 3, 2016 at 11:24 am

    #1876357

  • RE: determine SQL maintenance plan creator

    This likely wont help but it's worth noting that, if it is scheduled as a SQL Agent Job the default job owner will be the person that created the maintenance...

    "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 3, 2016 at 9:59 am

    #1876304

  • RE: Charindex in inner join affects the perfomance

    a.column has fts index installed on it and it is xml datatype.

    1. Full Text Indexing isn't going to help you here

    2. returning XML data in a SQL query is generally...

    "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 3, 2016 at 7:54 am

    #1876244

  • RE: Corrupted index - find out what caused it

    Luis Cazares (5/3/2016)

    Alan.B (5/2/2016)

    terry999 (5/2/2016)

    Hi

    I got this error on a scheduled integrity check. SQL 2005 sp2

    Data row does not have a matching index row in the index '' (ID...

    "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 3, 2016 at 7:27 am

    #1876227

  • RE: DBA Career Moves for Next 5 Years!

    No matter the job, it seems to me that if you're a bit of a Ninja in T-SQL, you'll be in demand...

    +1000

    "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 3, 2016 at 6:33 am

    #1876188

  • RE: Corrupted index - find out what caused it

    terry999 (5/2/2016)

    Hi

    I got this error on a scheduled integrity check. SQL 2005 sp2

    Data row does not have a matching index row in the index '' (ID 2). Possible missing...

    "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 2, 2016 at 5:22 pm

    #1876131

  • RE: Out of String Space

    I can't answer this but would suggest moving the Access to SQL Server. Then joins get much easier.

    "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 2, 2016 at 5:13 pm

    #1876129

  • RE: Loading XML table that outputs multiple table

    TheComedian (5/2/2016)

    I have an XML file that generates about 10 output tables when loaded into an XML source component. The natural solution would be either to:

    i) store them into...

    "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 2, 2016 at 7:39 am

    #1875895

  • RE: creating a view in SSRS?

    You can execute stored procedures from SSRS. Anything that you can do in a view you could also do in a subquery or temp table inside a stored procedure; a...

    "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 2, 2016 at 7:26 am

    #1875886

  • RE: Need guidance...

    Broniz (5/1/2016)

    Thanks a lot Alan.

    I wanted to try using SQL Snapshots for the BI and Excel, but I'll try using replication.

    I'm in middle of using Diskspd to get...

    "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 2, 2016 at 5:45 am

    #1875854

  • 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

Viewing 15 posts - 766 through 780 (of 2,458 total)