Viewing 15 posts - 106 through 120 (of 4,080 total)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2019 at 3:06 pm
You were quicker, Drew.
---------------------------------------------------
-- helpful index
-- create unique nonclustered index IX1_EventStream on demoevents.EventStream(customer,id) include (eventname);
WITH cte1 as ( -- flag prior actions
select id,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2019 at 2:41 pm
First import your spreadsheet into a staging table in your database. Then run a MERGE statement to add/update rows in your target table. Both of these steps are well-documented. __________________________________________________ Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 4, 2019 at 1:42 pm
Since you apparently have a product limitation against full outer joins, you could try creating a view that does the full outer join for you and then report against the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 27, 2019 at 3:02 pm
So to summarize, I should have a look at my...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
January 14, 2019 at 9:56 am
Nice read, Mike. Short, clear, and concise. Supported by execution plans and time/io stats. This is what I like to see even though I've used lag() for years. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
January 14, 2019 at 9:33 am
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
January 12, 2019 at 10:54 pm
I guess I don't know what you mean. iTVFs will use the indexes...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
January 11, 2019 at 8:31 pm
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
January 10, 2019 at 2:56 pm
Good read, Steve. Quick, clean, accurate, and on point.
One thing worth mentioning when using APPLY with a table valued function is the difference between CROSS APPLY and OUTER...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
January 10, 2019 at 2:51 pm
Looks tasty, if imperfect, to me, Steve. Needs a big scoop of vanilla bean ice cream to go with. 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 23, 2018 at 12:28 pm
Talk to me about perfection when we can compute pi exactly (in anything other than Base pi). Reality is fuzzy 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2018 at 1:55 pm
Ears
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2018 at 1:49 pm
Can you use EXEC? In other words, is all dynamic SQL off-limits or is the prohibition only against sp_ExecuteSQL?
(Yes, yes, I know: That would make no sense.) ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 9, 2018 at 2:56 pm
Just thought I'd mention that I tried both cte tally schemes and they produce a different number of rows. Jacob, yours seems to produce a doubled result set.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 27, 2018 at 11:14 am
Viewing 15 posts - 106 through 120 (of 4,080 total)