Martin Smith

Martin Smith has asked 14 questions and find answers to 1517 problems.

Stats

About

Martin Smith questions

SQL Server Code Pages and Collations
How to add row group headers to a "headerless" style report?
Logical reads for seeks on a non unique clustered index
subversion/cruise control/nant/nunit with visual studio projects and solutions
XSLT Built-in Template Rules for attributes
Should I define interfaces in Duck Typed languages?
Performance of Non Clustered Indexes on Heaps vs Clustered Indexes [closed]
Why are logical reads for windowed aggregate functions so high?

Martin Smith answers

String or Binary Data Would Be Truncated: NVARCHAR(MAX), SQL Server 2008
Create index WITH (ONLINE = ON) using SSDT
sql INNER JOIN table variable ON VS. INNER JOIN (select) ON
Look for trailing spaces in a table
Benefits of use parameters instead of concatenation
What are the benefits of storing name as "sysname" instead of "nvarchar(128)"?
Unique index and treating multiple values as one SQL
How can I SELECT distinct data based on a date field?
SELECT COUNT(*) > into variable T-SQL
What does "::" mean in a SQL context?