By Posted on Posted in DBCC Commands, SQL Sunday, TSQL No Comments Tagged with , , , , , ,

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 »

By Posted on Posted in SQL Saturday 1 Comment Tagged with , ,

  One of my sessions was accepted for SQL Saturday #190 in Denver this year. Please come see my CTE presentation. Common Table Expressions – Introduction Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn everything needed to start using CTE’s for recursive queries, …

I’m Speaking at SQL Saturday #190 in Denver Read more »

By Posted on Posted in Database Health, Technical Debt No Comments Tagged with , , , , ,

As Beta 7 of the Database Health Reports approaches is just three weeks, the big new feature that has been added is the SQL Technical Debt Analysis. The SQL Technical Debt Analysis a great check for those areas that are known problems when working on SQL Server. But what if I like the GOTO statement? All of the Database Health …

SQL Server Technical Debt Read more »

By Posted on Posted in TSQL No Comments Tagged with , , , , , , ,

The following SQL Server keywords are hidden in the word search puzzle. Find them all! ALTER BETWEEN CLUSTERED COLUMN COMMIT CREATE DATABASE DEFAULT ELSE END EXECUTE EXIT FOR FUNCTION GRANT IDENTITY INSERT KEY NOCHECK NONCLUSTERED NULL OFFSETS OPENDATASOURCE OPENQUERY OPENROWSET OPENXML OPTION OVER PIVOT PRIMARY PROCEDURE RAISERROR RECONFIGURE REPLICATION RESTORE RETURN RIGHT ROLLBACK ROWCOUNT SELECT SET STATISTICS THEN TRAN TRANSACTION …

SQL Sunday Fun – Word Search with SQL Server Keywords Read more »

By Posted on Posted in CTE, CTE Book 1 Comment Tagged with , , , , , , ,

  Related Common Table Expression Links Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First CTE with SQL Server Common Table Expressions – Terminating the Previous Statement CTE Scope Introduction to Recursive CTEs Recursive CTE for Dates In A Year Expanding on Recursive Dates CTE Multiple CTEs in a Query …

What is a Common Table Expression – Video Read more »

By Posted on Posted in Database Health No Comments Tagged with , , , , , , , , ,

Today marks the 1000th download of the Database Health Reports in the last 11 months since Beta 1 was released. I thought this would be the perfect opportunity to recap on the history of the database health report application. First I would like to thank everyone who has downloaded Database Health Reports application. Thank You! Here is a quick history, …

One Thousandth Download of Database Health Reports Read more »

By Posted on Posted in TSQL No Comments Tagged with , , , , ,

Across 2. Management Studio 5. The database that is used as a template when creating a new database 6. Using a backup 7. Reporting Services 9. An index that rearranges the structure of a table 12. The underlying structure of an index 13. Common Table Expression 20. Making queries run faster 21. An index that doesn’t change the structure of …

SQL Server Crossword Puzzle Read more »

By Posted on Posted in SQL 2014 11 Comments Tagged with , , , , , ,

To start with for Transparent Data Encyrption (TDE) we will need to be using Enterprise (or Developer) edition of SQL Server 2014. I am using SQL Server 2014 Enterprise Edition CTP1, which is the early release of SQL Server 2014. Next we need a database to work with.  I will just use the Sample Database for Common Table Expressions, a simple …

Enabling Transparent Data Encryption on SQL Server 2014 Read more »

By Posted on Posted in SQL 2014 No Comments Tagged with

Hekaton is also known as SQL Server In-Memory database, touted to accelerate transaction throughput up to 30x performance increases on existing hardware. With a new latch-free technology Hekaton is claimed to dramatically increase performance. Are you ready to increase the speed of your OLTP databases by 30x?