Martin Smith

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

List distinct tuples in a table(SQL query)(10 ways)
Create #temp using SELECT INTO with desired data type
Unhelpful error message when doing pivot
Values controlled by foreign keys
How do I generate row number without using rownum() in sql server
Cannot convert a char value to money. The char value has incorrect syntax
Single-row subquery returns more than one row
Money data type to store date values in SQL Server?
Problem with SQL select statment
SQL Server 2008 - using local variables for an INSERT and UPDATE trigger