Noam Brezis

Blog Post

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

391 reads

Blogs

Visiting with DBAs at midnight : T-SQL Tuesday #153

By

🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our...

Working with Neo4j Imports–I HATE CASE SENSITIVITY

By

I’ve been working to better understand graph databases and where they can be useful....

Daily Coping 8 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

MAX not working with a CTE

By DaveBriCam

I have a query that is supposed to return one patient id but even...

doe it locks my view while checking it ? EXEC sp_refreshview '[View_SCHEMA]'

By RazLinky

i have a cursor that runs on all my views   and then exec...

Transaction log full error 9002 on Alwayon Availability groups

By vsamantha35

Hi All, I am looking for some inputs on how to avoid or prevent...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

DATETRUNC

See possible answers