Using Comments to Quickly Test CTEs
A quick tip for using a combination of block and line comments to test CTEs
2014-11-10
7,358 reads
A quick tip for using a combination of block and line comments to test CTEs
2014-11-10
7,358 reads
Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.
2011-03-04 (first published: 2009-10-14)
149,710 reads
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
Hi Experts. We recently set up a second location. our software at our first...
I am trying to migrate a DB from an old dying laptop to a...
I'm sure this has been asked many, many, many times and hoping several optimal...