Category: SQL Sunday

SQL Sunday Word Scramble

SQL Server – TSQL Analytics Word Search   Find the following words in the word scramble above. TOP RANK DENSE_RANK ROW_NUMBER NTILE OVER LAG LEAD FIRST_VALUE LAST_VALUE PERCENT_RANK PERCENTILE_DISC PERCENTILE_CONT CUME_DIST PARTITION ROWS PRECEDING FOLLOWING UNBOUNDED   Download the Printable PDF

Posted in Analytic TSQL, SQL Sunday Tagged with: , , , , , , ,

SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality

    Click on the grid to enlarge, then print it. Find the following words in the grid up, down, left, right, horizontal, vertical, and diagonal. ROWS  RANGE  PRECEDING  FOLLOWING  UNBOUNDED  IIF  CHOOSE  OFFSET  FETCH  FORMAT  CONCAT  SEQUENCE  PARSE  TRYPARSE 

Posted in SQL Sunday, TSQL Tagged with: , , , , , , ,

SQL Sunday Fun – Word Search with SQL Server DBCC Commands

The following DBCC commands are all hidden in the word search.  Be aware, some of the DBCC commands are undocumented. CACHESTATS CHECKCATALOG CHECKCONSTRAINTS CHECKDB CHECKFILEGROUP CHECKIDENT CLEANTABLE DROPCLEANBUFFERS FLUSHPROCINDB FREE FREEPROCCACHE FREESESSIONCACHE FREESYSTEMCACHE INDEXDEFRAG OPENTRAN OUTPUTBUFFER PAGE PROCCACHE SHOWCONTIG SHRINKDATABASE

Posted in DBCC Commands, SQL Sunday, TSQL Tagged with: , , , , , ,