Martin Smith

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

Trigger on extended properties? SQL SERVER
Consecutive streak of dates
Why is C# DateTime.Now/DateTime.UtcNow ahead of SQL Server's SYSUTCDATETIME()/SYSDATETIME() even though C# code executes before the SQL Query
Crosstabbing rows based on sequence islands in a list of times
In SQL Server actual execution plan what does x of y (z%) refer to?
The setting 'auto create statistics' causes wildcard TEXT field searches to hang
How can I combine sql aggregate functions with distinct more cleanly?
SQL query working fine in SQL Server 2012, but failed to execute in SQL Server 2008 R2
How to check if a table already exists in the database?
SQL: how to get rows containing only certain ids?