functions

External Article

Bowled Over by SQL Window Functions

  • Article

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

Blogs

Truncating very large transaction log in full recovery mode

By

While I always configure transaction log backups for every database in non-simple recovery model,...

Autonomous Driving Around London

By

There’s a video of Bill Gates taking a drive in an autonomous car around...

Best way to monitor high worker thread on SQL Server

By

It is common to see high worker count issue on the production server and...

Read the latest Blogs

Forums

Remove the Dynamic code from my SQL sproc

By GrassHopper

I have a stored procedure that was created to run dynamically.  Other than me...

predictive query plan

By Arsh

Dear Friends, Please advise if there is a way to get a query plan...

Significance of Historical waits report in SQL server Performance dashboard

By IT researcher

I have the following historical wait report for my SQL server. I have noticed...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers