StackRating

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

Pittsburgh DBA

Rating
1510.66 (66,654th)
Reputation
4,770 (34,820th)
Page: 1 2 3
Title Δ
Monitoring Tabular Refresh with REST API - Obtaining Refresh ID 0.00
T-SQL - Finding records with chronological gaps -0.03
SQL query has me stumped -0.70
Performance impact of chained CTE vs Temp table -0.15
"Down" Casting columns while doing a UNION ALL (MS Sql Se... 0.00
Query for below pattern in Sql server -1.47
Improve performance on CTE with sub-queries 0.00
Long term application level pessimistic locking in SQL Server +1.46
Can't get this simple temporary table code to work -0.27
How do I hash a column of a table in SQL Server? -0.06
Aggregate for each day over time series, without using non-equijoin... +1.76
Display only those rows, whose SUM(price) is more than a certain nu... +3.87
Compare some date predicate based on 1st of the month +4.19
SQLite: INSERT or REPLACE certain columns, don't overwrite othe... +3.98
Can't Seem to Insert CTE Into Table -0.70
Set variable in the JOIN condition 0.00
GETDATE() specified for field default but not in effect when I pass... +3.47
How to replace CURSOR when it has effect on functions in SELECT sta... +2.42
Missing dates when using GROUP BY date -2.05
Adding a column with two-step calculations to an SQL table -0.02
What's the correct format of the format file for double quotes... +0.08
Memory Optimized Tables - Slower INSERT than SSD 0.00
How to group duplicate records and then update all members except l... -2.13
SQL - How to convert columns to rows +0.18
SQL - How to get a complete month calendar table +0.65
How to import CSV to Trello 0.00
When do we need self join exactly? -2.02
SQL Server Disk IO Performace appears different between otherwise i... 0.00
Storing entities with dynamic set of properties in a table (and usi... -0.04
How do I add to the date in a select query in SQL Server? +3.98
What is the most efficient way to process rows in a table? +4.14
Can you call from VB.Net code the ability to drop and crate a store... 0.00
Best Way to do a JOIN on Product UPC varchar(20)? +1.52
VB.NET single quotation not accepted by query -4.66
In SQL Server, can we set if it rounds or truncates by default? 0.00
How to change output of stored procedure on the fly in this query? 0.00
SQL Query: If Exists, Update, Else Insert, followed by addition of... 0.00
What is a good way to manage large ever growing tables in a database? 0.00
SQL Query Optimizing on large data 0.00
sql missing comma +3.68
SQL - How to find a distinct value for specific parameters in sql w... +0.28
Subquery returned more than 1 value. This is not permitted. Where i... -3.77
Conversion of a varchar date type to a datetime Error SQL -3.82
How to hide html source as this web? -0.20
sqlsrv only showing most recent row entries 0.00
SQL return data related to the corresponding MAX() value -2.14
SQL How to display all records in group by -3.11
SQL unit value and cumulative sum by groups -2.66
Different transactions must guarantedly select different items; avo... -3.95
Entity Framework Code First 4.3 / LINQKit predicate for related table 0.00