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?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
March 6, 2019 at 5:51 pm
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
November 30, 2018 at 7:44 am
ISNULL(LAG([to], 1) OVER(PARTITION BY CustID ORDER BY c.TransDate, c.Amount), 0)
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
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...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
October 20, 2018 at 7:52 pm
how can I rewrite below highlighted area? I am...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 10, 2018 at 12:17 pm
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 9, 2018 at 7:38 pm
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
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...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 7, 2018 at 6:05 pm
DOH!! Man I just have to stop trying to answer posts in my current state. 🙁
Hiatus declared ....
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 15, 2018 at 3:34 pm
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 15, 2018 at 11:10 am
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...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 14, 2018 at 11:02 pm
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 14, 2018 at 3:00 pm
I need a liitle help with this one, I have a live database and...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
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...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 14, 2018 at 2:57 pm
CASE is definitely my favorite TSQL thingy!! 😎
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 14, 2018 at 10:38 am
Viewing 15 posts - 1 through 15 (of 5,842 total)