Viewing 15 posts - 856 through 870 (of 1,246 total)
That's almost an exact description of my previous job. I maintained an ETL process for what we called the Master Patient Index; matching up distinct patients across medical claims, enrollments,...
September 6, 2016 at 6:38 pm
Eric M Russell (9/6/2016)
J Livingston SQL (9/6/2016)
-- just for fun
SELECT[dbo].[DoubleMetaPhone]('Pheasant');
SELECT[dbo].[DoubleMetaPhone]('Phesant');
SELECT[dbo].[DoubleMetaPhone]('Fessant');
SELECT[dbo].[DoubleMetaPhone]('Fezant');
SELECT[dbo].[DoubleMetaPhone]('Phes ant');
SELECT[dbo].[DoubleMetaPhone]('Fez aunt');
quite impressive
Still there is the issue that two words sounding alike are completely different.
SELECT[dbo].[DoubleMetaPhone]('Pheasant');
FSNT FSNT
SELECT[dbo].[DoubleMetaPhone]('Fussy Aunt');
FSNT FSNT
It's been my...
September 6, 2016 at 11:49 am
J Livingston SQL (9/6/2016)
-- just for fun
SELECT[dbo].[DoubleMetaPhone]('Pheasant');
SELECT[dbo].[DoubleMetaPhone]('Phesant');
SELECT[dbo].[DoubleMetaPhone]('Fessant');
SELECT[dbo].[DoubleMetaPhone]('Fezant');
SELECT[dbo].[DoubleMetaPhone]('Phes ant');
SELECT[dbo].[DoubleMetaPhone]('Fez aunt');
quite impressive
Yeah... Wish I could take credit for it (Google skills perhaps?), but my contribution was just a straight copy & paste...
September 6, 2016 at 11:32 am
An oldie but a goody... Years ago, Keith Henry translated Lawrence Philips C++ function to SQL function.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13574
Yes, it is a Scalar function and no I haven't attempted to rewrite it...
September 6, 2016 at 10:45 am
Can't say w/o looking at the actual execution plan... But... If I were to hazard a bling guess, I'd look for scalar functions and/or multi-statement table valued functions.
August 8, 2016 at 7:18 am
Eric M Russell (6/17/2016)
June 17, 2016 at 12:06 pm
CMRWB (6/17/2016)
Also, Before drop any index, look for indexusage statistics report....
June 17, 2016 at 11:34 am
TheSQLGuru (6/17/2016)
June 17, 2016 at 10:33 am
RV16 (5/13/2016)
You mean If I want to count number of students according to crs_cde then I should write like this
count(sch.id_num) OVER (PARTITION BY ss.CRS_CDE) "No of student"
I just want to...
May 16, 2016 at 8:14 am
Looks like you just need to "window" the count function and loose the group by...
COUNT(TableName.StudentID) OVER (PARTITION BY NULL)
HTH,
Jason
May 13, 2016 at 12:04 pm
I've has to do something similar in terms of enabling & disabling gobs based on various conditions... I found that adding a call to sp_start_job to the end of my...
May 13, 2016 at 11:56 am
SQL006 (4/21/2016)
No i am not using dynamic SQL, just passing it to storeprocedure as a parameter which is used in 'IN' operator.
one doubt does REPLACE has any performance...
April 25, 2016 at 4:41 pm
TheSQLGuru (1/28/2016)
Jason A. Long (1/28/2016)
It's an outstanding presentation....
January 29, 2016 at 7:01 am
I just wanted to give a HUGE thank you to Kevin. He gave his "Common SQL Programming Mistakes" presentation for out company today.
It's an outstanding presentation. If you you're fortunate...
January 28, 2016 at 6:11 pm
Just my 2 cents... If you want to prove anything to anybody, do it with the code...
Write a 2nd version of the proc (the way you believe it should have...
January 27, 2016 at 8:44 am
Viewing 15 posts - 856 through 870 (of 1,246 total)