SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...

Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the ...

Les plans de maintenance pour SQL Server existent depuis SQL Server 2000, mais ils ont toujours fait l'objet de critiques partagées. Cela s'explique en partie par leur approche quelque peu lourde, ...

SELECT * FROM table1 WHERE fieldStatus IN (@Status) AND (CASE WHEN @Status = 'Open' AND COUNT(@Status) = 1 THEN fieldDate >= GETDATE() END) I hope that makes sense. Anyone know how to test for a multi ...

The DICTIONARY tables component is specified in the FROM clause of a SELECT statement. DICTIONARY is a reserved libref for use only in PROC SQL. Data from DICTIONARY tables are generated at run time.

SQL Sentry Plan Explorer was launched two years ago and has since become one of the most popular free tools available to the SQL Server Community. The latest version adds several requested features, ...