Martin Smith

Martin Smith has asked 17 questions and find answers to 1749 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

TSQL merge: target table where on "ON" condition
SQL SORT BY DATENAME does not work
Cannot insert the value NULL into column 'Reason', table 'dbo.History'; column does not allow nulls. INSERT fails
SQL Server - help deleting rows with a multiple where clause using a sub query
Help me turn a SUBQUERY into a JOIN
T-SQL inner join first result of inner join
How can I tell if a column can be made into a varChar from a nVarChar?
SQL query to count frequency
SQL MAX(column) With Additional Criteria
join multiple nvarchar columns