Martin Smith

Martin Smith has asked 17 questions and find answers to 1765 problems.

Stats

About

Martin Smith questions

Triggers and row versioning information
How can I see the rowcounts for tables in a log analytics workspace?
SQL Server float datatype
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]

Martin Smith answers

Cant define SQL variable when using WITH statement
SQL PIVOT Syntax Error on Aggregate
Cumulative Count of NULL restarting at NOT NULL
Why do SUBSTRING or LEFT make the query much slower?
SQL Server Management Studio 2008: save database diagrams without applying tables just yet
SQL Server 2008: how to get the "Messages" tab (in Management Studio) output with powershell
How to set default value for column from another table in SQL Server 2005
MySQL SUM multiple columns
T-SQL FIxed-Width Output
SQL Server - How make allow NULL value in column