Forum Replies Created

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

  • RE: Hide or Disable parameters in SSRS 2005

    Yusuf Bhiwandiwala (9/18/2009)

    tmacs33,

    The question is : How do we grey out a report parameter (date type or not)?

    If greying out can be achieved, the SSRS world would be a happier...

    "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 4, 2016 at 9:18 am

    #1876633

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

    Eirikur Eiriksson (5/3/2016)

    Alan.B (5/3/2016)

    Eirikur Eiriksson (5/3/2016)

    Alan.B (5/3/2016)

    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,...

    "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 2:14 pm

    #1876430

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

    Eirikur Eiriksson (5/3/2016)

    Alan.B (5/3/2016)

    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,...

    "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 1:27 pm

    #1876416

  • RE: Index

    You'll find some scripts that you can alter as needed here as well.

    "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:37 pm

    #1876391

  • 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

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