Introduction TOP is one of the many syntactical operators available in T-SQL and at a first view, it could seem very simple and not particularly interesting. According to the official documentation, it “limits the rows returned in a query result set to a specified number of rows or percentage of rows”. The following is the […]
2019-06-04
4,335 reads
Based on a real fact, this article demonstrates how a bad use of sp_executesql can lead to unpleasant surprises
2018-04-30
1,567 reads
One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time
2016-09-29 (first published: 2016-09-08)
497 reads
Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK relationship? When can it help?
2016-09-16 (first published: 2015-06-29)
13,270 reads
SQL Server 2014 has introduced a rebuilt Cardinality Estimator (CE) with new algorithms. Which are the biggest differences between the new CE and the previous one? Which one works better? Read more to find out.
2015-04-09
6,375 reads
In this post we saw how to create some graph tables with data. In...
By Aaron Nelson
One of the top reasons I love PowerShell so much is that from the...
By Jen McCown
I was talking with a couple of excellent SQL people* recently, and we were bemoaning...
Comments posted to this topic are about the item Is Data the Future of...
Good Morning Experts, A transaction was sent to mirror database and immediately failover occured....
Good morning experts, The log file of my user db is full. Could you...
Ask SSC