2018-09-27
798 reads
2018-09-27
798 reads
What better way to learn how to construct complex CHECK CONSTRAINTs, use the SQL 2012 window frame capability of the OVER clause and LEAD analytic function, as well as how to pivot rows into columns using a crosstab query? Create the SQL code to score Ten-pin Bowling, of course. Dwain Camps explains the how, what and why.
2015-02-12
10,399 reads
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
It is common to see high worker count issue on the production server and...
I have a stored procedure that was created to run dynamically. Other than me...
I have the following historical wait report for my SQL server. I have noticed...