User Michael Cherevko

5 votes

1 answer

9k views

Passing NULL to SSIS variables

asked Nov 20, 2016 at 8:59

3 votes

3 answers

737 views

Reducing table scans using group by and window functions

asked Nov 14, 2019 at 8:22

3 votes

0 answers

118 views

Incremental statistics with failover

asked Dec 17, 2015 at 7:28

3 votes

1 answer

3k views

Using ddl triggers with in-memory tables

asked Jan 12, 2016 at 14:42

3 votes

2 answers

2k views

Most restricting permissions for querying view with linked server

asked Feb 4, 2016 at 6:56

3 votes

3 answers

2k views

Catching two error messages/Throw into table

asked May 22, 2016 at 5:51

2 votes

2 answers

539 views

Filtering extended events with configuration table

asked Jul 21, 2016 at 11:33

2 votes

1 answer

93 views

Window function not working on non selected rows

asked Mar 2, 2016 at 8:48

2 votes

1 answer

75 views

Setting rowlock order

asked Dec 17, 2015 at 7:38

2 votes

1 answer

110 views

Advanced job flow control

asked Feb 16, 2017 at 9:21

2 votes

1 answer

179 views

Query store audit

asked Sep 10, 2019 at 11:31

1 vote

1 answer

76 views

Trouble understanding locking logic

asked Dec 11, 2016 at 10:12

1 vote

2 answers

4k views

All instances upgrade from Command Prompt

asked Dec 21, 2016 at 9:50

1 vote

0 answers

751 views

Using loops inside Openrowset

asked Feb 25, 2015 at 13:28

1 vote

2 answers

1k views

Finding AD group permissions source

asked Feb 26, 2015 at 12:07

1 vote

0 answers

114 views

"Fire and forget" in SSIS

asked Nov 14, 2016 at 9:57

0 votes

1 answer

74 views

Is there a way to tell optimizer not to use index for reads?

asked Apr 21, 2021 at 12:52

0 votes

1 answer

411 views

Sending one email when all jobs completes successfully

asked Jul 9, 2014 at 8:35

0 votes

0 answers

35 views

Causing SQL to prefer casted time seek in view query

asked Aug 6 at 14:13

-2 votes

1 answer

214 views

Understanding $dateAdd/$dateSubtract behavior in mongodb

asked Jul 4, 2023 at 12:53

Stack Exchange Network

20 Questions

Passing NULL to SSIS variables

Reducing table scans using group by and window functions

Incremental statistics with failover

Using ddl triggers with in-memory tables

Most restricting permissions for querying view with linked server

Catching two error messages/Throw into table

Filtering extended events with configuration table

Window function not working on non selected rows

Setting rowlock order

Advanced job flow control

Query store audit

Trouble understanding locking logic

All instances upgrade from Command Prompt

Using loops inside Openrowset

Finding AD group permissions source

"Fire and forget" in SSIS

Is there a way to tell optimizer not to use index for reads?

Sending one email when all jobs completes successfully

Causing SQL to prefer casted time seek in view query

Understanding $dateAdd/$dateSubtract behavior in mongodb