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 ... 96
Title Δ
SQL Server: Perfomance of INNER JOIN on small table vs subquery in... +0.21
Date portion should be defaulted to 1900-01-01 0.00
Result order of string_split? -2.05
Message 102 Level 15 error SQL Server: Incorrect syntax 0.00
Is it better to use parameter or column value when copying data fro... +0.94
Parallel updates causing deadlock when no clustered index in where... -3.09
How do I get list of Physical Partition in Azure CosmosDb, is there... -0.79
Can't place OPTION (Recompile) after WHERE Clause in SQL Server 0.00
Uncommitted transaction asking every time in SQL Server 2012 +0.21
SQL Server conditional join techniques +1.06
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.21
How to replicate a SCH_S, SCH_M deadlock 0.00
What does the number mean in this statement: DATEDIFF(wk, 6, '2... -0.73
Stored procedure "forgetting" field between update and in... 0.00
Elegant way to filter a record with nullable field in SQL using nul... +0.60
System.Data.SqlClient.SqlException: 'Operand type clash: dateti... 0.00
SQL Server system table identity crysis / SYSOBJECTS table ID is cl... +0.25
Alter Table add column and check constraint in one script - getting... -0.84
SQL Server DB Locks - select with nolock 0.00
Extract data from XML using T-SQL query +0.20
SQL Select Converting to ASCII/varchar from Hex +0.46
Order of execution and which one is faster +0.79
how to create while loop in select? -3.35
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... +1.46
SQL query to select the start and end datetime of a value with syst... +0.21
The argument 1 of the XML data type method “value” must be a string... -0.54
Clustered Index order 0.00
How can i get only 1 value from table for each client and get all v... +0.75
SQL CASE WHEN still reading field even if it is not used 0.00
Stored Procedure argument "NULL" or "= NULL" +0.86
Data x exist and data y does not for the same column of a table +0.21
Produce a value based on aggregated rows where I want to CASE on mu... -0.81
Create index WITH (ONLINE = ON) using SSDT 0.00
Query Optimization, Issue -2.84
SQL Server: is it possible to use the select @var=field from table... +0.22
SQL Server - using DATALENGTH in where clause causes truncation error +0.22
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