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 of the Word Search. See Also TSQL Queries – Using NTILE TOP, Ranking, NTILE, and Aggregate Functions TSQL Analytics FREE …
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 TRYCONVERT THROW LEAD LAG FIRSTVALUE LASTVALUE PERCENTRANK CUMEDIST PERCENTILEDISC PERCENTILECONT NOTE: some of these terms normally have an underscore in …
SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality Read more »
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 TRACEON TRACESTATUS UNPINTABLE UPDATEUSAGE USEROPTIONS END OF PUZZLE ————————- See also: For more information on DBCC Commands: DBCC CheckAlloc DBCC …
SQL Sunday Fun – Word Search with SQL Server DBCC Commands Read more »