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 ... 96
Title Δ
Need to efficiently join two tables; to calculate entry and exit ti... 0.00
In what case SQL will use an Index of the table 0.00
RID lookup - logical search -2.84
Constant expressions are not allowed in the ORDER BY clause - how e... 0.00
What is regexp_replace equivalent in SQL Server +0.22
SQL case ceiling weird result 0.00
Tiny Integer Space allocation in SQL Server 0.00
Is update/select of a single column in a single row atomic and safe... +1.21
Nth highest salary of an employee SQL when an Employee has multiple... 0.00
Is there a way to write Regex in SQL Server query? 0.00
Executed Query Performs Differently to Query (identity insert on is... 0.00
SQL Performance wise which one is better Distinct or group by 0.00
SQL SERVER generates different and unoptimized execution plan for t... 0.00
Value and TYPE in XML PATH 0.00
What is the theory behind when DELETE or UPDATE query comes in a Re... 0.00
Table Value Constructor performance -1.15
Standard Deviation of a Row 0.00
General performance expectation joins or subqueries in the select c... 0.00
Coalesce equivalent for NULL or zero amount -3.13
Setting multiple variables' value in one IIF() of a SELECT stat... -0.87
SQL code to find if a series of lists do NOT contain a particular v... -0.28
SQL - How can you use WHERE instead of LEFT/RIGHT JOIN? +0.68
Converting month name to month number in SQL Server +0.65
Rewrite SQL script without repeating same nested queries 0.00
Return statement inside If condition does not work in SQL Functions 0.00
Could not devise a query plan for the given query for full outer join 0.00
How to start a new row number every time, when there is a change in... 0.00
Filtering the same query 3 different times. Performance? -0.98
How to declare advanced SQL query in C#? -0.71
Count records with a specified condition from from a list of tables... +0.22
SQL Server Index column order performance optimization for order by 0.00
SQL Server : while Update querying is executing, cannot execute del... 0.00
Trying to understand the solution to the puzzle convert comma-separ... 0.00
How can I prevent integers being silently turned to asterisks in SQ... +0.21
Select string from multiple columns -2.63
Why use key lookup instead of rid lookup since rid lookup is faster? -0.29
JSON_VALUE with square-bracket terminated JSON object 0.00
how to filter out the year using mask characters or any other trick... +0.21
Use asterisk in count with table alias T-SQL -0.72
Why aren't there duplicates in a recursive SQL "range"... 0.00
SQL Server bad performance with a lot of ORs and repeating criteria... +0.94
MS SQL Server View not allowing CONCAT +0.21
Why does ISNULL(NULL, NULL) return int datatype? 0.00
SQL Server - OPTION CLAUSE -0.04
OUTER/CROSS APPLY Subquery without FROM clause +0.72
Unable to convert varchar to date +0.74
BEGIN TRY and EXECUTE dynamic simple query error 0.00
SQL Server - Reasons for OPTION (FAST N) to choose other execution... 0.00
Which is faster (ISNULL(@SKU, '') = '') or (@SKU IS... -1.52
XML exist method not filtering records in SQL Server 2012 +1.23