garik's user avatar
garik's user avatar
garik's user avatar
garik
  • Member for 12 years, 9 months
  • Last seen this week
  • Russia
86 votes
13 answers
76k views

How should I best name my timestamp fields?

39 votes
5 answers
155k views

Logical operators OR AND in condition and order of conditions in WHERE

29 votes
5 answers
30k views

How do I switch off SCHEMABINDING for a view without recreating it?

28 votes
3 answers
38k views

Code to simulate deadlock

21 votes
5 answers
8k views

Is ROLLBACK a fast operation?

21 votes
3 answers
14k views

Is it possible to get execution call stack in a trigger?

20 votes
9 answers
5k views

Version control for database objects

20 votes
6 answers
6k views

What is SQL Server "Denali"? What's new?

15 votes
5 answers
49k views

How to detect any changes to a database (DDL and DML)

14 votes
1 answer
45k views

Database 'MyDb' is being recovered. Waiting until recovery is finished

12 votes
3 answers
4k views

How to change the firing order of Triggers?

11 votes
2 answers
8k views

Why does this query cause a deadlock?

11 votes
1 answer
4k views

noexpand hint for non-enterpise edition and performance

7 votes
2 answers
2k views

Using totals on aggregates to improve performance

6 votes
2 answers
464 views

How to manage my own scripts

6 votes
1 answer
210 views

Is my function nondeterministic one

6 votes
1 answer
512 views

how to improve performance by using or not using table variables

6 votes
1 answer
1k views

How to get text for default language

6 votes
2 answers
542 views

Row padding to get more performance

5 votes
2 answers
28k views

Why TRY CATCH does not suppress exception in trigger

5 votes
1 answer
126 views

Data transformation implementation

4 votes
2 answers
539 views

TOP X of SQL Server in MySQL Analog

4 votes
2 answers
2k views

Performance degradation after rebuilding indexes

4 votes
4 answers
10k views

How to move data from big table

4 votes
1 answer
714 views

Locking, deadlocking workaround while process data at the same table

3 votes
3 answers
509 views

How to determinate in a trigger direct inserts and inserts via stored procedure

3 votes
2 answers
4k views

How to check that stored procedure is valid

2 votes
1 answer
2k views

Inner cursor performance issues

2 votes
5 answers
8k views

How to restore database using old full backup and current log file

2 votes
1 answer
645 views

Clustered monotonically increased index insert performance