Viewing 15 posts - 1,306 through 1,320 (of 8,760 total)
July 8, 2018 at 12:58 am
The alleged "correct" answer is wrong.
😎
What version of SQL Server did you test this on Steve? Looks to me that there must be an implicit type...
July 8, 2018 at 12:45 am
The Daily one for...
July 7, 2018 at 7:10 am
July 7, 2018 at 6:24 am
July 7, 2018 at 3:23 am
July 7, 2018 at 3:19 am
I have speaking with people that defend that even using tabular model we could...
July 7, 2018 at 2:26 am
July 7, 2018 at 1:02 am
Be careful relying on the elements ordinal position if the ordinal position is not set in an XSD, i.e. using a typed XML column. It is much safer to use...
July 7, 2018 at 12:53 am
July 6, 2018 at 10:25 am
Dear all,
We have a BI solution
In this solution we have stading area, a data mart and...
July 4, 2018 at 1:56 pm
Nice piece Stewart, thanks for this!
😎
I'll compare this with the methods I'm using and ping back with my findings.
July 3, 2018 at 10:24 am
The root cause is definitely Sp_send_dbmail, recommend a redesign with a queue type table and a separate job to actually send the emails.
😎
July 3, 2018 at 10:20 am
Just for fun, here is a completely different kind of solution
😎
Using Phil's data sample
;WITH PROD_COMPARE AS
(
SELECT
...
July 1, 2018 at 2:11 am
Viewing 15 posts - 1,306 through 1,320 (of 8,760 total)