Stack Exchange

crokusek

top accounts reputation activity bookmarks subscriptions
Top Questions
68 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 '14 at 18:11
superuser.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 '13 at 1: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 '12 at 19:41
dba.stackexchange.com

10 votes

Is support for Parallel Scalar UDF a reasonable feature request?

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

9 votes

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

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

8 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 '16 at 23:54
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 '19 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 '19 at 1:15
dba.stackexchange.com

7 votes

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

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

7 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 '16 at 4:22
stackoverflow.com

1 2

Top Answers
81
How do I get client IP address in ASP.NET 5 CORE?
stackoverflow.com

41
SQL Server IN vs. EXISTS Performance
stackoverflow.com

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

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

18
How to get a tab character?
stackoverflow.com

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

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

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

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

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

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

8
How to make [DebuggerNonUserCode] hide an exception from the debugger in simple test case?
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
How does SqlConnection manage IsolationLevel?
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 can row estimates be improved in order to reduce chances of spills to tempdb
dba.stackexchange.com

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