Stack Exchange

Lamak

Chile

Age: 31

top accounts reputation activity favorites subscriptions
240
162 votes
8 answers

Getting the closest string match

javascript vb.net lua string-comparison levenshtein-distance Dec 19 '12 at 17:09 Fábio Perez
stackoverflow.com

61
139 votes
19 answers

Solutions for INSERT OR UPDATE on SQL Server

sql sql-server database insert upsert yesterday Eddie
stackoverflow.com

68
116 votes
3 answers

What's the difference between a temp table and table variable in SQL Server?

sql-server sql t-sql temp-tables Mar 16 at 20:43 Martin Smith
dba.stackexchange.com

38
70 votes
11 answers

T-SQL: Opposite to string concatenation - how to split string into multiple records

sql-server sql-server-2005 tsql Apr 18 at 16:49 kristof
stackoverflow.com

46
69 votes
11 answers

SQL left join vs multiple tables on FROM line?

sql syntax join Feb 1 at 7:27 xpda
stackoverflow.com

39
65 votes
12 answers

SQL Server: Query fast, but slow from procedure

sql-server performance stored-procedures Dec 12 '11 at 23:56 Mutix
stackoverflow.com

43
55 votes
7 answers

Where are some useful SQL puzzles to teach SQL in a workplace?

sql Oct 2 '11 at 17:58 Lazer
dba.stackexchange.com

17
53 votes
13 answers

SQL MAX of multiple columns?

sql sql-server tsql Jun 25 '12 at 16:40 Nigel Campbell
stackoverflow.com

19
52 votes
9 answers

Why are composite primary keys still around?

mysql sql-server database-design Feb 7 '12 at 20:04 gdoron
stackoverflow.com

24
45 votes
7 answers

Parameter Sniffing (or Spoofing) in SQL Server

sql-server tsql sql-server-2005 parameter-spoofing Mar 26 at 12:55 Unsliced
stackoverflow.com

11
42 votes
4 answers

Why are numbers tables “invaluable”?

sql-server May 17 at 19:53 Aaron Bertrand
dba.stackexchange.com

8
41 votes
7 answers

Does SQL Server read all of a COALESCE function even if the first argument is not NULL?

sql sql-server Feb 27 at 20:48 Martin Smith
dba.stackexchange.com

7
38 votes
4 answers

How to get sp_executesql result into a variable?

tsql dynamic-sql Oct 12 '11 at 13:34 Brian Mains
stackoverflow.com

11
34 votes
4 answers

XML Query in SQL Server 2008

sql-server xml query Feb 3 '12 at 0:07 Brad Knowles
stackoverflow.com

21
33 votes
5 answers

Why can't RDBM's cluster the way NoSQL does?

clustering nosql scalability relational-theory Mar 15 at 0:40 Jeremy Singer
dba.stackexchange.com

18
29 votes
6 answers

How to find foreign key dependencies in SQL Server?

.net sql-server foreign-keys Mar 27 at 12:07 Timothy Walden
stackoverflow.com

23
27 votes
11 answers

Most efficient way in SQL Server to get date from date+time?

sql sql-server tsql Aug 30 '12 at 15:59 Nigel Campbell
stackoverflow.com

13
27 votes
5 answers

Only inserting a row if it's not already there

sql sql-server tsql concurrency locking Jan 16 '11 at 19:14 Jonathan Leffler
stackoverflow.com

10
26 votes
4 answers

What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?

sql-server sql-server-2008 sql-server-2008-r2 sql-server-2012 May 2 '12 at 18:17 AlexKuznetsov
dba.stackexchange.com

10
24 votes
6 answers

What's the difference between a CTE and a Temp Table?

sql-server cte yesterday SQLAlan
dba.stackexchange.com

8
23 votes
3 answers

Unexpected scans during delete operation using WHERE IN

sql-server-2008-r2 query optimizer Dec 15 '12 at 1:20 Dmitriy Pilugin
dba.stackexchange.com

1
22 votes
3 answers

Performance of Non Clustered Indexes on Heaps vs Clustered Indexes

sql-server clustered-index Mar 15 '12 at 10:44 Martin Smith
dba.stackexchange.com

10
22 votes
1 answer

Using merge..output to get mapping between source.id and target.id

sql-server sql-server-2008 merge Mar 22 at 8:54 hofnarwillie
stackoverflow.com

10
21 votes
4 answers

Still wrong to start the name of a user stored procedure with sp_?

sql-server-2008-r2 stored-procedures May 14 at 16:39 Aaron Bertrand
dba.stackexchange.com

15
20 votes
5 answers

SQL, Auxiliary table of numbers

sql sql-server query numbers Jul 4 '11 at 12:24 Anthony Faull
stackoverflow.com

16
19 votes
24 answers

What is your reporting tool of choice?

sql reporting business-intelligence Apr 18 '11 at 18:49 Unsliced
stackoverflow.com

3
19 votes
2 answers

Why are Denali sequences supposed to perform better than identity columns?

sequence sql-server-2012 Dec 27 '12 at 16:46 Martin Smith
dba.stackexchange.com

9
19 votes
1 answer

Canonical Answers

discussion faq canonical Mar 20 at 17:15 Walter Mitty
meta.dba.stackexchange.com

13
18 votes
2 answers

What does a DBA have to know about SSAS?

sql-server database-administration ssas Mar 12 '12 at 20:42 ConcernedOfTunbridgeWells
dba.stackexchange.com

6
17 votes
4 answers

SQL Server “empty table” is slow after deleting all (12 million) records?

sql sql-server sql-server-2008 Mar 8 '12 at 2:33 Simon Righarts
dba.stackexchange.com

1 2 3 4 5 6