Forum Replies Created

Viewing 15 posts - 1,351 through 1,365 (of 2,458 total)

  • RE: Confused about what function to create

    .Netter (6/16/2015)

    Hey,

    I can't provide any code, as I haven't got that far yet.

    I have built my UserSettings table where by I will be comparing the values between this table and...

    "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

    June 16, 2015 at 1:52 pm

    #1805879

  • RE: Data Warehouse automation tool suggestions?

    I have been doing BI for about 8 years now and have never heard of these products. That does not mean they're not good. I looked over the website for...

    "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

    June 15, 2015 at 10:35 pm

    #1805631

  • RE: Levenshtein Distance Algorithm

    I put together a real-life example of where the Levenshtein Distance is used.

    Say you had a SQL Job or ETL package that imported data into a data warehouse or data...

    "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

    June 15, 2015 at 9:47 pm

    #1805629

  • RE: Levenshtein Distance Algorithm

    You could apply it to a table like so:

    USE tempdb

    GO

    CREATE FUNCTION edit_distance(@s1 nvarchar(3999), @s2 nvarchar(3999))

    RETURNS int

    AS

    BEGIN

    DECLARE @s1_len int, @s2_len int, @i int, @j-2 int, @s1_char nchar, @c...

    "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

    June 15, 2015 at 8:57 pm

    #1805626

  • RE: SQL Join

    sgmunson (6/15/2015)

    drew.allen (6/15/2015)

    sgmunson (6/15/2015)Also, just as a general rule, almost no one uses RIGHT joins because it's just not intuitive.

    I've actually wondered about this. I know this is true...

    "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

    June 15, 2015 at 8:31 pm

    #1805625

  • RE: How to Convert an MS Access DB to an MS SQL DB

    Getting the data from Access to SQL Server is pretty easy. From SQL Server you wI'll right click on the DB where you want to import the access data, select...

    "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

    June 15, 2015 at 4:38 pm

    #1805610

  • RE: An RDP Session issue

    Jeff Moden (6/13/2015)

    Alan.B (6/12/2015)

    It's a bad idea to use RDP to manage a DB server.

    If you're going to say something like that, you need to explain why....

    "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

    June 15, 2015 at 12:25 pm

    #1805540

  • RE: An RDP Session issue

    Take a look at this article:

    http://blogs.msdn.com/b/brendangrant/archive/2009/02/17/most-useful-feature-of-remote-desktop-i-never-knew-about.aspx

    It's a bad idea to use RDP to manage a DB server. MS Windows and SQL Server offer a variety of tools for...

    "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

    June 12, 2015 at 9:21 pm

    #1805289

  • RE: TVF is slower when running as paramerized

    phosplait (6/12/2015)

    @jeff, there is no begin in the function. It is an inline function that does a cross apply with another inline function onto a range of dates

    @Lynn, I would...

    "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

    June 12, 2015 at 6:02 pm

    #1805282

  • RE: SQL 2016 R Syntax?

    Check this:

    http://blog.revolutionanalytics.com/2015/05/r-in-sql-server.html

    "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

    June 12, 2015 at 4:19 pm

    #1805271

  • RE: The Scientific Method: a call to action

    Yes, the Scientific Method is a lot more work than making unsubstantiated claims and hitting publish, but it's also a lot more likely to produce a post that's useful, and...

    "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

    June 12, 2015 at 2:08 pm

    #1805228

  • RE: Prompt for Date Range?

    tsobiech (6/12/2015)

    ...

    Things would be so much easier if I could just use a parameter in a view.

    That's what an inline table valued function is (or at least how you can...

    "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

    June 12, 2015 at 11:57 am

    #1805178

  • RE: sp_who3 showing sleeping ask

    Shawn Melton (6/12/2015)

    Just go download Sp_WhoIsActive and use it.

    +1

    Awesome tool!

    "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

    June 12, 2015 at 8:55 am

    #1805083

  • RE: sp_who3 showing sleeping ask

    And... SP_WHO3 is not a built-in Microsoft sproc. - can you post the DDL you are using to create SP_WHO3?

    "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

    June 12, 2015 at 8:42 am

    #1805077

  • RE: Gathering Stored Procedure execution time in real time?

    JP10 (6/11/2015)

    Alan, your saying for the total time it took to execute and not in real time correct?

    I don't know if I understand your question so I'm not sure if...

    "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

    June 11, 2015 at 7:02 pm

    #1804868

Viewing 15 posts - 1,351 through 1,365 (of 2,458 total)