Forum Replies Created

Viewing 15 posts - 1,651 through 1,665 (of 2,458 total)

  • RE: What you use for service account

    Domain accounts have worked just fine for me for many years.

    "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 3, 2015 at 11:39 am

    #1788636

  • RE: Spam topics

    Koen Verbeeck (4/3/2015)

    Alan.B (4/3/2015)

    I actually came into the "Anything that is NOT about SQL!" forum to ask this question but think it's appropriate here....

    How do you report spam?

    At the top...

    "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 3, 2015 at 11:35 am

    #1788632

  • RE: Spam topics

    I actually came into the "Anything that is NOT about SQL!" forum to ask this question but think it's appropriate here....

    How do you report spam?

    "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 3, 2015 at 11:12 am

    #1788624

  • RE: Is it worth splitting a stored procedure for performance reasons?

    I wonder if I split the procedure into different procedures depending on the user selected option. This way, the different procedures would have their own saved query plan.

    This is something...

    "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 3, 2015 at 11:02 am

    #1788620

  • RE: Charindex issue

    It's worth noting SQLNAIVE, that Eirikur's solution will perform about 3X faster.

    I took your solution and put it into a scalar valued function like so:

    CREATE FUNCTION dbo.SVF_LOCATE_PATTERN_IN_STRING

    (

    @Expression VARCHAR(8000),

    @SearchString VARCHAR(10),

    @OccuranceNumber...

    "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 3, 2015 at 9:32 am

    #1788600

  • RE: SPROC with XML

    Do you have some DDL and test data so we can re-create and populate your two temp tables?

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

    #1788432

  • RE: What is wrong with my query, conversion from binary version string.

    Nice!

    "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 2, 2015 at 9:53 am

    #1788363

  • RE: Formatting in a datetime parameter

    Understood. That's all I could think of, hopefully someone else chimes in.

    "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 2, 2015 at 9:24 am

    #1788353

  • RE: Formatting in a datetime parameter

    Why is it doing this

    It has to do with how SSRS explicitly converts values. If the time is 00:00:00 it is assuming you want to treat the values as 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

    April 1, 2015 at 9:18 pm

    #1788178

  • RE: Where do I find the Report Path?

    I recently rolled off a project where we needed to extract some information from the report server catalog (e.g. the reportserver db). This function will includes the report path to...

    "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 1, 2015 at 8:32 pm

    #1788175

  • RE: SQL HTML

    Since nobody else is providing a solution I'll give it a try. I am simplifying the query against sys.columns because I don't really understand what you are doing. That said,...

    "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 1, 2015 at 8:18 pm

    #1788174

  • RE: Expression to TRIM

    You could also modify your stored proc (or ad hoc query) that feeds the dataset to format the data before it gets to SSRS. Your query would look something 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 1, 2015 at 8:12 pm

    #1788173

  • RE: Identity on Uniqueidentifier

    If you wanted to get a column to act like an identity column but to be a uniqueidentifier instead of an int you could do this:

    CREATE TABLE dbo.yourtable

    (

    pk_col AS newid(),

    xxx...

    "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 1, 2015 at 7:49 pm

    #1788171

  • RE: T-SQL Help...probably pretty simple but I'm tired :)

    Eirikur Eiriksson (3/31/2015)

    ScottPletcher (3/31/2015)

    As a side note, but still critical, let me warn everyone to use lowercase only for data type names in SQL Server. That is, "int" not...

    "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 31, 2015 at 1:30 pm

    #1787847

  • RE: Need Sample Data

    Thanks Luis. That stack overflow thread led me in the right direction.

    "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 31, 2015 at 1:22 pm

    #1787845

Viewing 15 posts - 1,651 through 1,665 (of 2,458 total)