Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.
user avatar
user avatar
user avatar
Mihai
  • Member for 9 years, 4 months
  • Last seen more than a month ago
  • Romania
474 votes
2 answers
248k views

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

290 votes
4 answers
326k views

Why Does the Transaction Log Keep Growing or Run Out of Space?

  • 17.8k
139 votes
4 answers
138k views

Optimizing queries on a range of timestamps (two columns)

106 votes
7 answers
40k views

Why use both TRUNCATE and DROP?

  • 1,506
102 votes
8 answers
19k views

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

  • 1,245
93 votes
5 answers
62k views

When to use TINYINT over INT?

  • 6,243
68 votes
4 answers
57k views

Index Seek vs Index Scan

  • 3,152
58 votes
1 answer
10k views

Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?

  • 69.4k
57 votes
9 answers
13k views

Should you design the database before the application code is written?

51 votes
5 answers
51k views

When should you denormalize?

  • 6,243
48 votes
2 answers
59k views

Is there any difference at all between NUMERIC and DECIMAL?

  • 1,539
47 votes
2 answers
110k views

When To Update Statistics?

  • 1,079
47 votes
2 answers
41k views

What is the actual behavior of compatibility level 80?

  • 813
47 votes
6 answers
132k views

How to update 10 million+ rows in MySQL single table as Fast as possible?

42 votes
3 answers
18k views

Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN

  • 3,296
36 votes
3 answers
38k views

For absolute performance, is SUM faster or COUNT?

  • 4,268
36 votes
5 answers
54k views

Why are simple SELECTs on InnoDB 100x slower than on MyISAM?

34 votes
2 answers
297k views

oracle - list users with access to certain tables

  • 359
33 votes
2 answers
6k views

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

  • 30.8k
30 votes
3 answers
50k views

How to speed up select distinct?

  • 567
30 votes
4 answers
53k views

Why does transaction log continue to grow in Simple recovery mode with nightly backups

  • 438
28 votes
3 answers
3k views

Are RANK() and DENSE_RANK() deterministic or non-deterministic?

27 votes
9 answers
3k views

What is the most efficient method of performing the FIZZBUZZ test in SQL Server?

  • 67.1k
27 votes
2 answers
180k views

How is the default tablespace determined when creating a table?

  • 895
26 votes
2 answers
39k views

Changing a column from NOT NULL to NULL - What's going on under the hood?

  • 1,952
25 votes
3 answers
48k views

Why would a table use its primary key as a foreign key to itself

  • 429
24 votes
2 answers
19k views

Ready-to-Use Database models example

  • 1,005
24 votes
2 answers
2k views

Cardinality Estimate for LIKE operator (Local Variables)

  • 630
23 votes
2 answers
68k views

MySQL: Tree-Hierarchical query

23 votes
1 answer
3k views

How to calculate/store Top 10 in a tabular model?

  • 9,466
1
2 3 4 5
8