The pain of Forced Parameterization in SQL Server

A few months ago I blogged about the challenges of Simple Parameterization in SQL Server. Today I want to continue this discussion by talking about Forced Parameterization in SQL Server. Forced Parameterization Simple Parameterization has a number of limitations in SQL Server. It will not happen if your SQL statements ...

Read more

Primary Key vs. Clustered Index

In today’s blog posting I want to talk about a very important topic in SQL Server that always confuses people when they first work with SQL Server. It is about the difference between the Primary Key constraint and the Clustered Index. What is a Primary Key? Let’s talk first about ...

Read more

Copyright © 2015 by SQLpassion · Klaus Aschenbrenner · Imprint · Offerings · Academy · Contact · Go to Top