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

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

sgmunson (6/15/2015)

---

drew.allen (6/15/2015)

---

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

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

Jeff Moden (6/13/2015)

---

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

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

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

Check this:

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

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

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

+1

Awesome tool!

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

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