Martin Smith

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

How to select overlapping date ranges in SQL
Set a value within a range 0-30
SQL Server CHOOSE() function behaving unexpectedly with RAND() function
Rowstore index on Clustered Columnstore - cardinality estimation mistake?
Get SQL Substring After a Certain Character but before a Different Character
Unexpected output from SQL Server IN operator [duplicate]
How to add constraint to SQL Server 2008 using constraint dialog?
Is there an efficient way to avoid UNIONs of fixed values in SQL?
More efficient way of writing this query?
How to increment DateTime column by a second for every row?