Reputation
Next tag badge:
563/400 score
69/80 answers
Badges
9 93 163
Newest
 Enlightened
Impact
~550k people reached

13h
answered Translate query using APPLY to run under compatibility level 80
19h
answered Two servers, different execution plans. Several orders of magnitude difference in run time
1d
answered Can I optimize a left join for a single match?
1d
answered Routing data from one SQL Server to another
2d
answered Using sp_getapplock to implement a queue. Is it correct? Is there a better way?
2d
answered Should I mark a composite index as unique if it contains the primary key?
2d
answered How to give a user “create any database” permission in SQL Server?
2d
answered BCP stops after the last “1000 rows sent to SQL Server. Total sent: …”
2d
answered Do Nested Transactions commit?
Sep
1
answered Is REPEATABLE READ the right choice for validation before modifying data?
Sep
1
answered Is there a performance difference in committing and rolling back a read-only transaction?
Aug
31
answered How to set up indexed view when SELECTing TOP 1 with ORDER BY from different tables
Aug
29
wiki created mysql-5.7 excerpt
Aug
29
wiki created mysql-5.7 description
Aug
29
answered In Sql Server, is there a way to check if a selected group of rows are locked or not?
Aug
29
answered Return even empty groups when grouping by date
Aug
29
answered Add a flag when certain conditions are met
Aug
27
answered How does Oracle handle types in this UNION query?
Aug
27
answered Unable to restore the database with the query
Aug
26
answered Finding distinct rows across two tables: Full Outer Join more efficient than Union?