StackRating

An Elo-based rating system for Stack Overflow
Home   |   About   |   Stats and Analysis   |   Get a Badge
Rating Stats for

Martin Smith

Rating
1732.91 (59th)
Reputation
365,033 (71st)
Page: 1 2 3 ... 94
Title Δ
How to return partial result of a procedure during its calculation? 0.00
SQL IN clause in where condition causing performance issue with lar... 0.00
How to replicate a SCH_S, SCH_M deadlock 0.00
What does the number mean in this statement: DATEDIFF(wk, 6, '2... 0.00
Stored procedure "forgetting" field between update and in... 0.00
Elegant way to filter a record with nullable field in SQL using nul... 0.00
System.Data.SqlClient.SqlException: 'Operand type clash: dateti... 0.00
SQL Server system table identity crysis / SYSOBJECTS table ID is cl... 0.00
Alter Table add column and check constraint in one script - getting... 0.00
SQL Server DB Locks - select with nolock 0.00
Extract data from XML using T-SQL query 0.00
SQL Select Converting to ASCII/varchar from Hex 0.00
Order of execution and which one is faster 0.00
how to create while loop in select? 0.00
How to prevent table locking with multiple users writing and readin... 0.00
SQL: status flips between 1 and 2; select all statuses, which are 2... 0.00
SQL query to select the start and end datetime of a value with syst... 0.00
The argument 1 of the XML data type method “value” must be a string... 0.00
Clustered Index order 0.00
How can i get only 1 value from table for each client and get all v... 0.00
SQL CASE WHEN still reading field even if it is not used 0.00
Stored Procedure argument "NULL" or "= NULL" 0.00
Data x exist and data y does not for the same column of a table 0.00
Produce a value based on aggregated rows where I want to CASE on mu... 0.00
Create index WITH (ONLINE = ON) using SSDT 0.00
Query Optimization, Issue 0.00
SQL Server: is it possible to use the select @var=field from table... 0.00
SQL Server - using DATALENGTH in where clause causes truncation error 0.00
SQL Server Multi-Target Insert, Does It Exist? 0.00
Outer apply (and cross apply ) against the same table result 0.00
sql server partition performance 0.00
SQL Server - manage rows in same table 0.00
SQL Server: How to count each days of week between two dates withou... +0.74
Why does a passive (non-capturing) group behave better than a norma... 0.00
SQL Server - Dynamically Filling the column Values with 0's as... -1.60
How many times SUM() will be calculated? 0.00
finding part of a long string in a column of short strings 0.00
Updating / Inserting row only if it's different from current va... +0.21
Select every row from Table A which are not in Table B +0.21
SQL query to return any 100 rows quickly without scanning entire ta... +0.21
Does the concatenation of NULL + 'something' always yield N... +0.21
How can I see the rowcounts for tables in a log analytics workspace? 0.00
Is an Index seek operation more costly compared to index scan when... 0.00
CTE is a Best Practice instead of temp table? 0.00
SQL Server mismatch row count in SELECT and UPDATE query with same... 0.00
Execution times of subquery for an IN statement 0.00
date function will return different date if date changes while exec... +0.20
Use CONSTRAINT keyword when creating a table -0.28
Would `merge` statement guarantee the same value of a `default curr... +0.19
Handling objects being different for different SQL Server Versions 0.00