Noam Brezis is a technology expert and a senior SQL Server consultant at Madeira SQL Server Services. With over 10 years of experience in various technologies, he enjoys a wide knowledge range, from Visual C#, .Net, C++, MFC, COM and VB, through UNIX and Oracle and up to a deep and thorough understanding of SQL Server. In his work, Noam deals on a daily basis with a broad and varied clientele, designing, developing and troubleshooting their SQL Server systems. Noam also spends part of his career teaching SQL Server and frequently speaks at events such as the Israeli SQL Server User Group.

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

360 reads

Blogs

Adding a Check Constraint to a Table–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Azure SQL Database Elasticity – Presentation Notes

By

This blog covers the content and points to the code used to create the...

How To: Create Schema Only Database Copies

By

Have you ever been asked to make a schema only copy of a database?...

Read the latest Blogs

Forums

query

By sankaripr

Hi i have 3 table that need to find out which id missing two...

Joining 2 select results into a single row

By mtz676

select( select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as...

deleted duplicate post

By mtz676

deleted duplicate post

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers