SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Alessandro Mortola

SQLServerCentral.com profile

   Items 1 to 3 of 3   

Self SQL Injection

Based on a real fact, this article demonstrates how a bad use of sp_executesql can lead to unpleasant surprises  Read more...
By Alessandro Mortola 2018/04/30 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 1,519 reads

Indexing Foreign Keys

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?  Read more...
By Alessandro Mortola 2016/09/16 (first published: 2015/06/29) | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 13,169 reads

Cardinality Estimator – What’s new in SQL Server 2014

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.  Read more...
Rating: |  Discuss |   Briefcase | 6,324 reads
   Items 1 to 3 of 3