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,331 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)
148,117 reads
Blogs
Graph – Shortest Path
‘Shortest path’ is by far the most feature of SQL Graph for now. What...
Last Week Reading (2019-09-22)
By Kamil
Hello #datafolks! Let’s review what happened last week in Data World. It’s hard to...
Simple Graph Queries
In this post we saw how to create some graph tables with data. In...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
memory not getting released to OS
Hi All, Need help here. Why is sql server is not releasing memory to...
Will the principal wait for acknowledgement from mirror?
Good Morning Experts, A transaction was sent to mirror database and immediately failover occured....
Ask SSC