StackRating

An Elo-based rating system for Stack Overflow

Home | About | Stats and Analysis | Get a Badge

Rating Stats for

PeterHe

Rating
1489.11 (4,429,055th)

Reputation
414 (317,961st)

Page: 1 2 3 4 ... 5

Title	Δ
Mysql query Key to speed calc with 10M rows	+0.52
Can I show only the rows in which a is smaller than b in sql?	0.00
How to trace the issues in application server	0.00
How can I improve SQL performance on this Json Array?	0.00
MYSQL: How to count and group from 2 tables and then join to the 3r...	0.00
Automatically update columns values after 6 days	-0.24
how can show count for each row in mysql?	0.00
SQL: Overlapping records	0.00
How to return specific setting from DBCC USEROPTIONS?	-0.52
RowNum in Mysql, with group by (MySQL 5.x)	+2.04
Create a Function that Returns John Daniel Dec 6th 2009	+0.03
SQL Update from another table - Massive Screw up	0.00
Generate xml for Table data and column definitions	-0.71
Select criteria using a case expression in where clause based on ot...	+1.30
Parameter sniffing - only in stored procedures?	0.00
MySQL : Having a table with minimum and maximum value columns, how...	+2.05
Simple Inner Join for comparing two values in table	-0.48
Syntax to convert 'Nov 23, 2019, 1:44 PM' to a datetime lik...	-1.04
Get Max And Min dates for consecutive values in T-SQL	+0.80
Recursive MySQL Query for Variable Overlaps	0.00
MySQL: Return stats over grouped by date with subqueries	0.00
MsSql - Optimize Like %value%	-1.63
does result of pivot need to be a non shared temp table?	0.00
SQL variable assignment and comparison logic	-1.77
selecting value when two row numbers are the same	0.00
Availability Group synchronous commit - Write / Read Question	0.00
Dynamic SQL : Create insert queries for tables having relations	0.00
partitioning mysql table with 3b records per year	-0.26
Setting a Default SSRS parameter	0.00
STUFF function to display multiple columns output values in quotes...	0.00
Why does T-SQL in SSMS run faster when wrapped in explicit transact...	0.00
How to create an alternate key from multiple nullable columns	0.00
INSERT INTO, if already exist UPDATE. from an existing query. to be...	0.00
TSQL - Error when running a procedure within a transaction where th...	0.00
Trouble getting ```IF``` statement working to check records and pro...	0.00
Why is my SQL query not using the table's composite index?	0.00
How do I join two tables with ids and the closest next date in SQL?	0.00
How to correctly include the right columns in a SQL index	0.00
How to get how many hour 4AM on a day Tuesday have there been betwe...	+0.67
SQL Server "FOR XML" encoding HTML entities?	0.00
MYSQL HAVING (not) with ROW_NUMBER() why it returns different row c...	0.00
Converting MSSQL stored procedures to MySQL - CONCAT issue	0.00
SQL - Multiple PIVOT operator doesn't work with alias	+2.75
Taking most recent values in sum over date range	0.00
Taking most recent values in sum over date range	0.00
Conditionally select a row every month - SQL Server	+0.42
SQL Server: Report the most recent record if it does not contain NULL	+0.22
Automatically generate date for insert	+0.38
Priority in execution sql	0.00
t-sql to create XML file using FOR XML Path, multilevel issues	-1.43