Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Learn something every day with brand new articles by email:
Sign up
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...
By
Alessandro Mortola
2015/04/09
|
Source:
SQLServerCentral.com
|
Category:
cardinality estimator
Rating:
|
Discuss
|
Briefcase
|
6,324 reads
Items 1 to 3 of 3
Copyright © 2002-2019 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.