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,565 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,597 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)
510 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,495 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,441 reads
By Gail Shaw
It’s a few days into April, but not too late I hope to mention...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Sometimes in life you have to do things you really don’t like to do....
Hi everyone. I have a process that is taking a long time to execute...
Daily Coping Tip: Rediscover your favourite music that really lifts your spirits. My thoughts:...
I am proposing to the business that we use SQL 2019 Developer in our...
Ask SSC