User garik

11

61

votes

11

answers

42k

views

How should I best name my timestamp fields?

naming-convention

Oct 11 at 17:17 Shaunak Sontakke 181

7

35

votes

5

answers

124k

views

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

Sep 4 at 9:59 Community♦ 1

13

25

votes

3

answers

32k

views

Code to simulate deadlock

sql-server deadlock

Dec 20 '16 at 15:51 Tom V - try topanswers.xyz 15.1k

4

22

votes

4

answers

26k

views

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

sql-server sql-server-2008 view

Jan 15 '18 at 13:08 David Roodman 21

3

20

votes

5

answers

6k

views

Is ROLLBACK a fast operation?

sql-server-2008 performance transaction rdbms rollback

Mar 25 '19 at 21:02 Aaron Bertrand♦ 165k

6

19

votes

9

answers

5k

views

Version control for database objects

sql-server sql-server-2008-r2 version-control source-control

Feb 11 '15 at 15:16 jlee-tessik 109

8

19

votes

6

answers

6k

views

What is SQL Server “Denali”? What's new?

features sql-server-2012

Jul 30 '13 at 19:22 Community♦ 1

5

16

votes

3

answers

11k

views

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

sql-server-2008 trigger

Aug 11 at 15:54 Basil Kisel 83

3

14

votes

1

answer

36k

views

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

sql-server sql-server-2008-r2 recovery

Dec 1 '13 at 12:07 Community♦ 1

5

13

votes

5

answers

43k

views

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

sql-server-2008 backup trigger

Jun 28 '18 at 9:27 WAF 299

1

12

votes

3

answers

4k

views

How to change the firing order of Triggers?

sql-server-2008 sql-server-2005 trigger

Oct 4 '11 at 18:15 Nick Chammas 13.3k

11

votes

1

answer

4k

views

noexpand hint for non-enterpise edition and performance

sql-server-2008 performance clustered-index view

Nov 14 '18 at 15:01 gbn 66.6k

3

11

votes

2

answers

8k

views

Why does this query cause a deadlock?

sql-server-2008 deadlock

Aug 16 '11 at 16:39 Community♦ 1

7

votes

2

answers

2k

views

Using totals on aggregates to improve performance

sql-server-2008 performance aggregate query materialized-view

May 31 '11 at 13:46 Community♦ 1

1

6

votes

1

answer

1k

views

How to get text for default language

sql-server-2008 query t-sql cte

Sep 27 '11 at 21:59 Nick Chammas 13.3k

6

votes

2

answers

447

views

Row padding to get more performance

sql-server performance

Sep 1 '11 at 15:24 Aaron Bertrand♦ 165k

6

votes

2

answers

423

views

How to manage my own scripts

best-practices scripting

Mar 9 '11 at 12:35 Marian 14.1k

6

votes

1

answer

197

views

Is my function nondeterministic one

sql-server performance determinism

Jan 20 '11 at 14:19 Eric Humphrey - lotsahelp 4,793

5

votes

1

answer

493

views

how to improve performance by using or not using table variables

sql-server-2008 performance execution-plan

Jul 20 '11 at 11:10 garik 6,162

5

votes

1

answer

118

views

Data transformation implementation

sql-server-2008 performance database-design database-recommendation

Jan 20 '11 at 14:46 garik 6,162

1

4

votes

3

answers

9k

views

How to move data from big table

sql-server sql-server-2008-r2

May 14 '18 at 3:01 Michael Green 18.7k

1

4

votes

2

answers

21k

views

Why TRY CATCH does not suppress exception in trigger

sql-server-2008 trigger error-handling

Apr 9 '18 at 20:41 Beekir 1

4

votes

2

answers

1k

views

Performance degradation after rebuilding indexes

sql-server-2008 performance index statistics

Mar 5 '12 at 13:00 James L 4,078

4

votes

1

answer

657

views

Locking, deadlocking workaround while process data at the same table

sql-server-2008 transaction deadlock locking hints

Aug 25 '11 at 22:10 Simon Hughes 578

4

votes

2

answers

495

views

TOP X of SQL Server in MySQL Analog

mysql

Aug 16 '11 at 18:09 Community♦ 1

3

votes

3

answers

493

views

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

sql-server-2008 trigger

Jul 13 '11 at 17:35 gbn 66.6k

3

votes

2

answers

4k

views

How to check that stored procedure is valid

sql-server-2008 database-recommendation maintenance

Mar 29 '11 at 9:03 Marian 14.1k

1

2

votes

1

answer

11k

views

Changed database context to 'MyDbName'

sql-server-2008-r2 error-handling

Dec 14 '11 at 15:12 Community♦ 1

2

votes

1

answer

581

views

Clustered monotonically increased index insert performance

sql-server-2008 performance execution-plan clustered-index clustered-primary-key

Nov 10 '11 at 21:44 Community♦ 1

2

votes

1

answer

1k

views

Inner cursor performance issues

sql-server-2008 performance best-practices cursors

May 16 '11 at 18:24 Marian 14.1k

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

34 Questions

How should I best name my timestamp fields?

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

Code to simulate deadlock

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

Is ROLLBACK a fast operation?

Version control for database objects

What is SQL Server “Denali”? What's new?

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

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

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

How to change the firing order of Triggers?

noexpand hint for non-enterpise edition and performance

Why does this query cause a deadlock?

Using totals on aggregates to improve performance

How to get text for default language

Row padding to get more performance

How to manage my own scripts

Is my function nondeterministic one

how to improve performance by using or not using table variables

Data transformation implementation

How to move data from big table

Why TRY CATCH does not suppress exception in trigger

Performance degradation after rebuilding indexes

Locking, deadlocking workaround while process data at the same table

TOP X of SQL Server in MySQL Analog

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

How to check that stored procedure is valid

Changed database context to 'MyDbName'

Clustered monotonically increased index insert performance

Inner cursor performance issues