Viewing 15 posts - 1 through 15 (of 5,842 total)
Should this (and PatExclude8K/PatReplace8K,et al) have Paul White's ORDER BY bug fixes put in place?
March 6, 2019 at 5:51 pm
November 30, 2018 at 7:44 am
ISNULL(LAG([to], 1) OVER(PARTITION BY CustID ORDER BY c.TransDate, c.Amount), 0)November 30, 2018 at 7:36 am
2016 SP1 is not a place to be. I would recommend you patch up. Same thing that was the solution for this thread.
I would also recommend you get...
October 20, 2018 at 7:52 pm
how can I rewrite below highlighted area? I am...
May 10, 2018 at 12:17 pm
May 9, 2018 at 7:38 pm
May 8, 2018 at 11:04 am
Maybe DB2 has the same objects and something different (like 10000X more data, missing indexes, different data types, etc)?
The best way to help you is to post the...
May 7, 2018 at 6:05 pm
DOH!! Man I just have to stop trying to answer posts in my current state. 🙁
Hiatus declared ....
February 15, 2018 at 3:34 pm
Steve Stedman has a great free tool for monitoring SQL Server.
Check out Brent Ozar's sp_blitz(whatever) sprocs.
Check out Glenn Berry's Diagnostic Scripts.
sp_whoisactive
Outside of...
February 14, 2018 at 11:02 pm
I need a liitle help with this one, I have a live database and...
February 14, 2018 at 2:59 pm
CASE is one of the very few SQL Server things that can short-circuit like this. I note that I don't think this behavior is GUARANTEED in all cases though, although...
February 14, 2018 at 2:57 pm
Viewing 15 posts - 1 through 15 (of 5,842 total)