Lamak
  • Member for 11 years
  • Last seen this week
  • Chile
2 answers
470 votes
246k views
308 bookmarks
What's the difference between a temp table and table variable in SQL Server?
7 answers
184 votes
196k views
100 bookmarks
What's the difference between a CTE and a Temp Table?
4 answers
116 votes
20k views
35 bookmarks
Why are numbers tables "invaluable"?
9 answers
104 votes
41k views
76 bookmarks
Where are some useful SQL puzzles to teach SQL in a workplace?
8 answers
102 votes
19k views
23 bookmarks
Does SQL Server read all of a COALESCE function even if the first argument is not NULL?
5 answers
89 votes
24k views
69 bookmarks
Why can't RDBM's cluster the way NoSQL does?
4 answers
77 votes
190k views
39 bookmarks
How to identify which query is filling up the tempdb transaction log?
4 answers
66 votes
57k views
41 bookmarks
Index Seek vs Index Scan
1 answers
62 votes
21k views
42 bookmarks
What event information can I get by default from SQL Server?
2 answers
58 votes
9k views
24 bookmarks
Cast to date is sargable but is it a good idea?
4 answers
53 votes
289k views
17 bookmarks
What's the easiest way to create a temp table in SQL Server that can hold the result of a stored procedure?
3 answers
51 votes
84k views
34 bookmarks
How do I get back some deleted records?
4 answers
50 votes
15k views
22 bookmarks
What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?
3 answers
42 votes
18k views
16 bookmarks
Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
3 answers
40 votes
4k views
14 bookmarks
Unexpected scans during delete operation using WHERE IN
2 answers
40 votes
21k views
25 bookmarks
What does a DBA have to know about SSAS?
3 answers
39 votes
6k views
4 bookmarks
Performance of Non Clustered Indexes on Heaps vs Clustered Indexes
2 answers
36 votes
4k views
7 bookmarks
Why are Denali sequences supposed to perform better than identity columns?
2 answers
33 votes
6k views
20 bookmarks
As a DBA, how would I go about transitioning from Oracle to SQL Server?
4 answers
33 votes
5k views
12 bookmarks
Still wrong to start the name of a user stored procedure with sp_?
1 answers
31 votes
9k views
12 bookmarks
Guidelines for full-text index maintenance
1 answers
31 votes
61k views
9 bookmarks
Change length of varchar on live prod table
4 answers
27 votes
16k views
10 bookmarks
SQL Server "empty table" is slow after deleting all (12 million) records?
2 answers
26 votes
1k views
5 bookmarks
Why does a subquery reduce the row estimate to 1?
1 answers
26 votes
6k views
3 bookmarks
What date/time literal formats are LANGUAGE and DATEFORMAT safe?
1 answers
23 votes
6k views
7 bookmarks
Is my SQL Server patched?
1 answers
23 votes
26k views
10 bookmarks
SQL query for combinations without repetition
2 answers
23 votes
26k views
16 bookmarks
Performance difference between Clustered and Non Clustered Index
1 answers
21 votes
2k views
4 bookmarks
What's the anatomy of a columnstore index?
1 answers
21 votes
5k views
2 bookmarks
Should I be alarmed by this NO JOIN PREDICATE warning?