user avatar
user avatar
user avatar
Lamak
  • Member for 11 years, 7 months
  • Last seen more than a week ago
  • Chile
475 votes
2 answers
249k views

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

  • 78.5k
186 votes
7 answers
200k views

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

  • 8,289
116 votes
4 answers
20k views

Why are numbers tables "invaluable"?

  • 2,314
104 votes
9 answers
42k views

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

  • 477
102 votes
8 answers
20k views

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

  • 1,245
89 votes
5 answers
24k views

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

  • 1,021
80 votes
4 answers
196k views

How to identify which query is filling up the tempdb transaction log?

  • 1,023
68 votes
4 answers
57k views

Index Seek vs Index Scan

  • 3,152
63 votes
1 answer
22k views

What event information can I get by default from SQL Server?

60 votes
2 answers
9k views

Cast to date is sargable but is it a good idea?

53 votes
4 answers
290k views

What's the easiest way to create a temp table in SQL Server that can hold the result of a stored procedure?

51 votes
4 answers
15k views

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

  • 7,180
51 votes
3 answers
84k views

How do I get back some deleted records?

42 votes
3 answers
18k views

Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN

  • 3,306
40 votes
3 answers
4k views

Unexpected scans during delete operation using WHERE IN

40 votes
2 answers
22k views

What does a DBA have to know about SSAS?

  • 2,303
39 votes
3 answers
6k views

Performance of Non Clustered Indexes on Heaps vs Clustered Indexes

  • 78.5k
36 votes
2 answers
4k views

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

  • 11.8k
34 votes
4 answers
5k views

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

33 votes
2 answers
6k views

As a DBA, how would I go about transitioning from Oracle to SQL Server?

  • 30.9k
31 votes
1 answer
10k views

Guidelines for full-text index maintenance

31 votes
1 answer
62k views

Change length of varchar on live prod table

27 votes
1 answer
7k views

What date/time literal formats are LANGUAGE and DATEFORMAT safe?

27 votes
4 answers
17k views

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

26 votes
2 answers
1k views

Why does a subquery reduce the row estimate to 1?

  • 30.7k
23 votes
1 answer
7k views

Is my SQL Server patched?

  • 15.6k
23 votes
1 answer
27k views

SQL query for combinations without repetition

  • 1,012
23 votes
2 answers
26k views

Performance difference between Clustered and Non Clustered Index

21 votes
1 answer
3k views

What's the anatomy of a columnstore index?

  • 17.7k
21 votes
1 answer
6k views

Should I be alarmed by this NO JOIN PREDICATE warning?

  • 10.4k