StackRating

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

Martin Smith

Rating
1734.18 (52nd)
Reputation
225,186 (69th)
Page: 1 2 3 ... 92
Title Δ
Quering 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.13
Loop through XML using SQL +1.44
SQL: How to get both match and non-match records +0.05
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.08
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.74
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.87
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.81
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.55
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
T-SQL Union (distinct, not all) and Order by with priority +1.16
How to check a database in SQL to make sure that all of its tables... -0.81
SQL How would I group records based on conditions? -2.26
SQL Server : if column is not null show as a new row +1.02
Selectivity estimation error on a simple query 0.00
Is it always possible to avoid using a UNION in SQL? +0.85
Why am I getting a different actual execution plan between my two s... -1.35