Noam Brezis

Pro and Cons of Parameter Sniffing

Look at the following 3 scripts:
-- 1. Hardcoded
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime < '19900101'

-- 2. Variable
DECLARE @FilterDate DATETIME = '19900101'
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime...

2012-01-02

351 reads

Blogs

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

By

Welcome back to my series on Power Platform quick tips! In this episode you...

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Read the latest Blogs

Forums

BUY REAL TRAVEL PASSPORT ..

By prodocuments

We are a group of professionals with many years of experience in Manufacture of...

BUY REAL TRAVEL PASSPORT AND VISA ....

By prodocuments

We are a group of professionals with many years of experience in Manufacture of...

BUY REAL TRAVEL PASSPORT

By prodocuments

We are a group of professionals with many years of experience in Manufacture of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers