StackRating

An Elo-based rating system for Stack Overflow

Home | About | Stats and Analysis | Get a Badge

Rating Stats for

Martin Smith

Rating
1720.58 (83rd)

Reputation
426,666 (84th)

Page: 1 2 3 4 5 6 7 ... 96

Title	Δ
Why DELETE TOP(X) statement is not deleting the same records that a...	-3.19
Why doesn't this windowed expression result in a divide by zero...	+0.17
Problem with scalar UDF inlining in SQL Server 2019	0.00
SQL Server: How do I sort and compare lots of versions?	+1.95
Why am I getting "Operand type clash: date is incompatible wit...	0.00
Conversion failed when converting the varchar value '%' to...	+0.21
How to do binary search by table with known data order in specific...	+0.44
Querying a view after creating a clustered index on it still yields...	0.00
Why is my SQL Server 2017 query returning incorrect results?	0.00
SQL - Comparing Dates in 2 Tables, Retrieving Most Recent	-1.12
Loop through XML using SQL	+1.44
SQL: How to get both match and non-match records	+0.06
Select row with least value in multiple columns without ROW_NUMBER	+0.47
How does SQL server determine the data type of a column derived thr...	+1.47
why is AS (column name alias) not getting latest result?	+0.20
Query won't convert a nvarchar(30) to a decimal	+1.07
Using the OR operator - SQL Server	-2.90
On SQL insert, write the new row's assigned ID in a second column	0.00
inner join performance issue with or condition	-0.89
SQL Server performance issues when using EXCEPT in query	+0.63
Capture SysEndTime on SQL Server temporal table delete	+0.75
GROUP BY ROLLUP Producing unnecessary rows	0.00
Can this business rule be enforced with an index?	+0.83
Why is query with phone = N'1234' slower than phone = '...	+1.00
How would one create a DATE column that is updated via a DATETIME c...	0.00
Trigger to Avoid Deletion of Last Row of that Value SQL Server	+1.07
Filter Out NULL Columns from GROUP BY CUBE Results	0.00
There is a better way to write this sql query (union)?	-2.88
Only saving disinct rows in temporary table	+0.27
Split a long string into an array of shorter strings in SQL	0.00
Subtract one number range from another	0.00
How to optimize this SQL Server query	0.00
TSQL Continuous Membership for specific Period of time, simplify WH...	-0.17
Special Pattern by SQL LIKE clause	+0.63
How to find pair relationships between rows in a very large table	+0.21
SQL: Unexpected results with SUM and COUNT functions	0.00
Timeout during SET SYSTEM_VERSIONING = ON with large table	0.00
TSQL merge: target table where on "ON" condition	0.00
BINARY_CHECKSUM - different result depending on number of rows	-1.80
How do not scan all records to query top rows by complex condition	+0.97
Divide the coordinates into X and Y coordinates from a table having...	+0.56
Multiple SELECTS into single result row	0.00
SQL query to select with Range condition in source table	+0.67
Flat file connection manager carriage return/line feed discrepancy	0.00
Cumulative Count of NULL restarting at NOT NULL	0.00
SQL Server 2016 - Running Count and Sum for a 24 hours sliding window	-0.79
Full text search using CONTAINS	+0.20
SQL Server 2008R2: SET ANSI_NULLS OFF does not affect merge matchin...	+1.39
Using over() in SQL Server	0.00
OPTION (MAXRECURSION X) in MERGE Statement with CTE not working?	+0.77