Viewing 15 posts - 31 through 45 (of 49 total)
spaghettidba (4/17/2015)
craig 81366 (4/18/2013)
John Hick-456673 (4/18/2013)
I have tested it against large tables (1 billion plus rows) and performance is much better than with dynamic SQL.
I'm going to be blunt here.
I...
April 17, 2015 at 9:09 pm
Thanks to everyone who has commented. I am sorry that it has taken me so long to respond, but I have been a bit busy this morning.
When I wrote...
April 17, 2015 at 11:54 am
An impressive article - worth the 5 stars I gave it but, where did you find out about the S1 formula?
April 9, 2015 at 11:23 am
Phil Parkin (4/7/2015)
John Hick-456673 (4/7/2015)
I use PowerShell scripts to automate the orderly release of scripts - they are easy to modify when the environment changes.
How do these fit within your...
April 7, 2015 at 11:21 am
I use PowerShell scripts to automate the orderly release of scripts - they are easy to modify when the environment changes.
April 7, 2015 at 10:38 am
I like the concept, but I don't like extraneous function calls:
"WHERE a.Last_Status_DT >= DATEADD(day, -@LookbackDays, @CurrentDT)"
My preference would be to place the DATEADD clause in yet another variable before calling...
December 16, 2014 at 3:00 pm
john 69568 (2/7/2014)
Nice, but I think you meantset @start_of_day = dateadd(day,datediff(day,0,@date),0);
rather than
set @start_of_day = dateadd(day,datediff('day',0,@date),0);
or am I missing something?
You might test your "corrections" before you post...
.. your "correction" will...
February 7, 2014 at 4:23 pm
As a former software developer, I agree whole-heartedly! I'm giving you five stars on this.
February 7, 2014 at 10:14 am
Excellent! We have Replication latencies several times a day on our daisy-chain system (Production-to-Reporting-to-DataMart) and this proc found the bottlenecks.
Three thumbs up.
October 3, 2013 at 12:24 pm
MarbryHardin (4/19/2013)
Build a type containing name - value pairs, populate it...
April 19, 2013 at 3:45 pm
Knut Boehnert (4/18/2013)
Carlo Romagnano (4/18/2013)
Knut Boehnert (4/18/2013)
Carlo Romagnano (4/18/2013)
Old stuff!Dynamic sql will run better.
Sorry, all you are saying is that a red sky is always better than a green sky....
April 18, 2013 at 5:33 am
May every DBA enjoy a prosperous and stress-free holiday season. You've earned it. You have been Smokey the Bear, Mr. Peabody, and MegaMind all year - time to...
December 24, 2010 at 11:37 pm
Five pages about NULL and not one mention of using NULLIF to test against a datum...
August 24, 2010 at 5:41 pm
Just a note on this. I ran both Scott's and Jeff's solutions; Scott's returned 7 rows and Jeff's returned 5.
February 8, 2010 at 4:03 pm
I would love to be a giver - if I had anything to give. I fell into the DBA role by being the developer who was willing to give...
November 30, 2009 at 10:18 am
Viewing 15 posts - 31 through 45 (of 49 total)