Database Administrators
Gordon Linoff's user avatar
Gordon Linoff's user avatar
Gordon Linoff's user avatar
Gordon Linoff
  • Member for 11 years, 4 months
  • Last seen more than 2 years ago
Profile Activity
Stats
2,222
reputation
628k
reached
34
answers
2
questions
Communities
View all
About

Check out my book Data Analysis Using SQL and Excel".

I have a blog with periodic posts about data analysis and SQL here at blog.data-miners.com.

Badges
View all badges
1
gold badge
17
silver badges
18
bronze badges
Top tags
View all tags
99
Score
14
Posts
39
Posts %
57
Score
18
Posts
50
Posts %
43
Score
3
Posts
8
Posts %
25
Score
7
Posts
19
Posts %
25
Score
2
Posts
6
Posts %
19
Score
2
Posts
6
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
answer
40
Can I add a unique constraint that ignores existing violations?
Jun 4, 2013
answer
22
Why does query error with empty result set in SQL Server 2012?
Feb 13, 2014
answer
19
Optimize a query that's running slow with nested loops inner ioin
Apr 17, 2013
question
14
Concatenation Physical Operation: Does it guarantee order of execution?
Apr 2, 2013
answer
14
Deleting large amounts (4 million rows) of mysql data efficiently, on a very regular basis
Mar 4, 2014
answer
12
How database size affects performance: Theory vs reality
Aug 22, 2012
question
11
Handling exceptions in stored procedures called using insert-exec blocks
Feb 6, 2013
answer
6
When a previously-fast SQL query starts running slow, where do I look to find the source of the issue?
Mar 4, 2014
answer
5
ORDER BY optimization for a large table
Jun 20, 2013
answer
4
Optimizing MySQL query with left joins
May 19, 2015
Top network posts
View all network posts
490
How do I put an 'if clause' in an SQL string?
377
SQL "between" not inclusive
328
Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
298
UPDATE multiple rows with different values in one query in MySQL
258
Is there a LastIndexOf in SQL Server?

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.