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,474 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,574 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)
500 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,312 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,399 reads
By Devin-Knight
Check out this new series that I’ve started on Power Platform Quick Tips. This...
Over the years I’ve seen quite a few strange things with SQL Server. This...
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
Comments posted to this topic are about the item Numeric and Decimal, which is...
Comments posted to this topic are about the item Learn from the Troubles of...
Comments posted to this topic are about the item Agile Job Descriptions
Ask SSC