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,351 reads
Carl P. Anderson
Concatenating Rows
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,211 reads
Blogs
What’s my MAC Address in a Command Prompt?–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
You don’t need a blockchain
After writing several posts about a neat feature in Azure SQL called system-versioned ledger...
Daily Coping 27 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Error connecting using AlwaysON Listener
Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...
How to get feature key and feature value separated $ based on part id ?
I work on sql server 2012 i need to get featurekey and feature value...
Setting Up SQL Server 2019 for Optimal Performance
Hi I have a very large database (600GB) that I am looking at creating. ...
Ask SSC