Forum Replies Created

Viewing 15 posts - 916 through 930 (of 2,462 total)

  • RE: ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.

    An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database

    I love the precision in these errors....

    "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, 2016 at 9:05 pm

    #1866985

  • RE: Advice on query optmization - Multiple Unions

    Also, try to post the DDL and some sample data for the tables referenced in your query. Note the link on how to get help in my signature...

    In the...

    "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, 2016 at 8:00 pm

    #1866979

  • RE: Advice on query optmization - Multiple Unions

    Can you post the actual (not estimated) execution 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

    March 22, 2016 at 7:26 pm

    #1866976

  • RE: SQL

    Interviewing for what position?... DBA? SQL Developer? Data Architect? BI Consultant?

    What kind of interview?... Purely technical, e.g. "what's an index?" Strategic, e.g. "why would you create an index"?

    More...

    "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 21, 2016 at 9:56 pm

    #1866656

  • RE: Automation to find element path in xml files

    Here's some code to get you started. Note my comments:

    -- Two variables designed to emulate your XML files

    DECLARE @emp XML =

    '<?xml version="1.0" encoding="utf-8"?>

    <EmployeeDetails RunDate="2016-03-07">

    <Employees EmployeesCount="3">

    ...

    "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 21, 2016 at 8:31 pm

    #1866650

  • RE: Which indexes out of MISSING INDEXes report are most important to implement?

    VoldemarG (3/21/2016)

    WHen you look at query plans or query DMVs for missing indexes,

    it is an obvious practice not to implement them all. What is one most important criteria

    is...

    "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 21, 2016 at 8:04 pm

    #1866648

  • RE: The New Men of IT

    The SQL world is like the Wild West. I have stories similar to everyone on this thread and have also been interviewed by idiots. I'll offer some advice to people...

    "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 21, 2016 at 7:09 pm

    #1866647

  • RE: problem with the query plan cache probably

    Mad-Dog (3/21/2016)

    Hi,

    i'm using sql server 2008 R2 sp3 and i have some weird issue with some queries. every few days some of my query become very slow.

    if i clean the...

    "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 21, 2016 at 6:38 pm

    #1866645

  • RE: Trim string based on characters

    -- Sample values in a table

    DECLARE @repository TABLE(someid int, string varchar(100));

    INSERT @repository VALUES (1,'WebApp - 10148'),(2,'Smart - App - 1458'),(3,'No Number - here');

    -- Solution if there's always a number

    SELECT String,...

    "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 21, 2016 at 5:42 pm

    #1866642

  • RE: 2014 SSMS - SA Account password changing on it's owm - how to get rid off this issue.

    I'm a fan of disabling the SA account and using a SQL account with a different name if I need a SQL account with elevated privileges.

    In addition to what...

    "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 21, 2016 at 2:43 pm

    #1866616

  • RE: Trying to count distinct warehouses per order and get the total

    You can't do what Luis suggested because you can't COUNT(DISTINCT) with an OVER clause.

    That said, you may want to try to do the aggregations in SSRS because the is...

    "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 21, 2016 at 2:33 pm

    #1866614

  • RE: Looping and scalar value

    drew.allen (3/21/2016)

    Eirikur Eiriksson (3/21/2016)

    kuopaz (3/21/2016)

    I see, thanks. As it's scanning the tally table row-by-row from start to the predicate value, the order of N may be important in some cases...

    "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 21, 2016 at 11:57 am

    #1866573

  • RE: Are the posted questions getting worse?

    yb751 (3/21/2016)

    SQLRNNR (3/21/2016)

    Brandie Tarvin (3/21/2016)

    Lynn Pettis (3/21/2016)

    Okay, my daughter and I are in Providence, RI. We were scheduled to do campus visit at Johnson & Wales University this morning...

    "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 21, 2016 at 10:19 am

    #1866534

  • RE: Are the posted questions getting worse?

    Any CLR savvy people want to take a look at this? http://www.sqlservercentral.com/Forums/Topic1766573-3412-1.aspx

    Solomon Perhaps?

    "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 21, 2016 at 9:13 am

    #1866498

  • RE: Trouble Deploying CLR functions

    fxferguson (3/4/2016)

    Thanks Alan,

    The CLR assemblies I'm trying to deploy performs a lot of external file manipulation. I attempted to use them on a 2014 server and they would bomb. The...

    "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 21, 2016 at 9:11 am

    #1866497

Viewing 15 posts - 916 through 930 (of 2,462 total)