Stack Exchange

crokusek

top accounts reputation activity bookmarks subscriptions
Top Questions
75 votes

How to list the users and groups of an AD Security Group when not a domain admin

windows active-directory user-groups asked Aug 21, 2014 at 18:11
superuser.com

11 votes

Is support for Parallel Scalar UDF a reasonable feature request?

sql-server parallelism udf asked Jul 24, 2014 at 21:43
dba.stackexchange.com

11 votes

How can row estimates be improved in order to reduce chances of spills to tempdb

sql-server optimization join asked Jun 1, 2013 at 1:01
dba.stackexchange.com

10 votes

How to clear an Error 15404 after a DB restart (besides rebooting)

sql-server sql-server-agent active-directory job asked Dec 6, 2013 at 2:01
dba.stackexchange.com

10 votes

How to log error details when using using try/catch for dynamic SQL backup commands

sql-server backup error-handling asked Jun 25, 2012 at 19:41
dba.stackexchange.com

9 votes

How to make [DebuggerNonUserCode] hide an exception from the debugger in simple test case?

c# debugging exception visual-studio-2015 attributes asked Sep 8, 2016 at 4:22
stackoverflow.com

9 votes

How to improve estimate of 1 row in a View constrained by DateAdd() against an index

sql-server sql-server-2012 optimization view asked Apr 8, 2016 at 23:54
dba.stackexchange.com

8 votes

Is it possible to get seek based parallel plan for distinct/group by?

sql-server index optimization group-by distinct asked Mar 26, 2015 at 17:41
dba.stackexchange.com

8 votes

What cases benefit from the Reduce, Replicate, and Redistribute join hints?

sql-server join hints azure-sql-data-warehouse sql-server-pdw asked Jan 24, 2019 at 20:20
dba.stackexchange.com

7 votes

How to get cross apply to operate row by row on a view?

sql-server execution-plan view cross-apply asked Jan 25, 2019 at 1:15
dba.stackexchange.com

1 2

Top Answers
102
How do I get client IP address in ASP.NET Core?
stackoverflow.com

44
SQL Server IN vs. EXISTS Performance
stackoverflow.com

30
EF6 wraps every single stored procedure call in its own transaction. How to prevent this?
stackoverflow.com

22
SQL deadlocking..in single user mode now
stackoverflow.com

20
How to get a tab character?
stackoverflow.com

19
What difference does .AsNoTracking() make?
stackoverflow.com

16
LEN function not including trailing spaces in SQL Server
stackoverflow.com

11
HttpContext.Current is null in an asynchronous Callback
stackoverflow.com

10
Using ISNULL vs using COALESCE for checking a specific condition?
stackoverflow.com

10
How to check if a column exists in a SQL Server table
stackoverflow.com

10
Which drive is \Device\Harddisk1\DR1?
superuser.com

8
How to make [DebuggerNonUserCode] hide an exception from the debugger in simple test case?
stackoverflow.com

7
Best practice between using LEFT JOIN or NOT EXISTS
dba.stackexchange.com

7
Is it safe to use a session-owned SQL Server sp_getapplock with EF6 DbContexts?
stackoverflow.com

6
How does SqlConnection manage IsolationLevel?
stackoverflow.com

6
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. error in VB.Net
stackoverflow.com

5
Sql Server 2008 MERGE - best way to get counts
stackoverflow.com

5
SQL Server 2005: T-SQL to temporarily disable a trigger
stackoverflow.com

5
LINQ select on a SQL View gets wrong answer
stackoverflow.com

5
Using robocopy with Visual Studio 2010 Post-build and Pre-build events
stackoverflow.com

5
How to run a test at the same time a web project is being debugged?
stackoverflow.com

5
How can row estimates be improved in order to reduce chances of spills to tempdb
dba.stackexchange.com

5
Read system_health event_file instead of ring_buffer for deadlocks extended events
dba.stackexchange.com