Viewing 15 posts - 14,071 through 14,085 (of 59,063 total)
Just make sure when you're doing timings, use that million...
October 13, 2017 at 8:22 pm
TOTAL datatype is (numeric(10,0),null)
STR datatype is (numeric(20,15),null)
REPLACE(FORMAT(CAST(ROUND((
CASE
WHEN SUM(CASE WHEN a.TOTAL IS NOT...
October 13, 2017 at 8:16 pm
By any chance, did you use Entity Framework (EF) to create the GUIs? This sounds precisely like something we went through recently. It turned out to the connection strings for...
October 13, 2017 at 8:09 pm
You're still joining the inline Tally functionality with the blob and, no matter how you swing it, that's still going to be a performance problem. A "nibbler" While Loop will...
October 13, 2017 at 5:17 pm
i wonder why executing a TRUNCATE and INSERT INTO Command is mutch slower than ...
October 13, 2017 at 12:26 pm
SELECT ...
October 13, 2017 at 9:45 am
Thanks, Phil. Good to see mostly consistency between disparate machines on these.
October 13, 2017 at 9:43 am
October 13, 2017 at 9:30 am
October 12, 2017 at 11:41 pm
October 12, 2017 at 8:54 am
October 11, 2017 at 11:43 pm
p.s. You might want to exclude system databases from the return just to be safe.
October 11, 2017 at 11:14 pm
Viewing 15 posts - 14,071 through 14,085 (of 59,063 total)