Profile Activity

Shanky

Meta user

Network profile

Reputation

16,050

16.1k
10.9k
5.7k

2016
2017
2018
2019

Top tag

sql-server

Next privilege

20,000 Rep.

Access 'trusted user' tools

Badges

Newest

Nice Answer

Next badge

0/1

Impact

540 posts edited

123 helpful flags

1,839 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

69 Favorites

Added Views Newest Activity Votes

454

votes

answers

235k

views

What's the difference between a temp table and table variable in SQL Server?

May 4 at 17:41 Paul White says GoFundMonica♦ 50.3k

125

votes

answers

50k

views

Why shouldn't we allow NULLs?

database-design null

Apr 6 '18 at 23:55 Aaron Bertrand♦ 163k

100

votes

answers

33k

views

Why use both TRUNCATE and DROP?

sql-server sybase truncate

Oct 11 at 16:05 markp 2,240

votes

answers

11k

views

Authoritative source that <> and != are identical in performance in SQL Server

sql-server performance operator

Dec 1 '16 at 10:43 Community♦ 1

votes

answers

69k

views

What risks are there if we enable read committed snapshot in sql-server?

sql-server sql-server-2005 transaction

2d ago Anne Cao 1

votes

answers

10k

views

Excessive sort memory grant

sql-server execution-plan memory-grant

Jan 28 at 12:18 Paul White says GoFundMonica♦ 50.3k

votes

answers

views

Asked to Not Use Transactions and to Use A Workaround to Simulate One

sql-server t-sql transaction

Sep 20 at 18:49 Piotr 966

votes

answers

views

SQL Server's “Total Server Memory” consumption stagnant for months with 64GB+ more available

sql-server performance sql-server-2016 memory sp-blitz

Jun 12 at 14:04 Marcello Miorelli 11.4k

votes

answers

30k

views

SQL Server Agent Jobs and Availability Groups

sql-server sql-server-2012 sql-server-agent availability-groups

Oct 27 '18 at 16:52 Aleksey Vitsko 1,231

votes

answers

views

difference in execution plans on UAT and PROD server

sql-server-2008-r2 query-performance

Feb 8 '18 at 15:46 Erik Darling 29.6k

votes

answer

26k

views

SQL Server: How to track progress of CREATE INDEX command?

sql-server index sql-server-2014 index-maintenance

Dec 2 at 16:57 Solomon Rutzky 56k

votes

answers

13k

views

Optimising plans with XML readers

sql-server sql-server-2012 execution-plan xml database-internals

Nov 8 at 9:22 Paul White says GoFundMonica♦ 50.3k

votes

answer

30k

views

GO After every T-SQL statement

sql-server performance t-sql best-practices

Apr 2 '14 at 11:44 Vinoth _S 637

votes

answers

29k

views

Handling concurrent access to a key table without deadlocks in SQL Server

sql-server deadlock

Mar 30 '17 at 18:59 Andriy M 18.1k

votes

answers

views

What is a deterministic method for evaluating a sensible buffer pool size?

sql-server sql-server-2008-r2 sql-server-2012

Oct 16 '15 at 7:50 Community♦ 1

votes

answers

34k

views

Why does my query search datetime not match?

sql-server datetime

Dec 14 '18 at 1:48 ypercubeᵀᴹ 83.3k

votes

answer

views

Monumental difference in execution time between queries when using RECOMPILE query hint

sql-server sql-server-2005 query-performance optimization

Mar 19 '12 at 20:57 Martin Smith 71.3k

votes

answers

views

Will increased network latency cause table locks in MS SQL Server?

sql-server locking network

Oct 1 '14 at 18:31 Community♦ 1

votes

answer

views

What types of corruption can DBCC CheckDB miss?

sql-server-2008 sql-server-2005 dbcc corruption

Sep 2 '11 at 17:42 Community♦ 1

votes

answer

351

views

Read a partially updated row?

sql-server concurrency

Aug 10 '17 at 17:48 Max Vernon 59.8k

votes

answers

views

Is a join optimized to a where clause at runtime?

sql-server t-sql join optimization

Jan 10 '18 at 17:41 Aaron Bertrand♦ 163k

votes

answers

views

Deadlock error isn't returning the deadlock SQL

sql-server-2008 deadlock

Jul 31 '17 at 21:58 crokusek 1,733

votes

answers

views

Why am I not getting minimal logging when inserting to indexed tables

sql-server transaction-log

May 29 at 9:11 Paul White says GoFundMonica♦ 50.3k

votes

answers

views

Who created a procedure? (SQL Server 2008 R2 )

sql-server-2008-r2 stored-procedures

Aug 6 '15 at 11:09 Community♦ 1

votes

answer

10k

views

How to lower HEAP Fragmentation in SQL Server?

sql-server fragmentation heap

May 8 '18 at 17:56 Shanky 16.1k

votes

answer

821

views

HADR high worker thread usage

sql-server sql-server-2014 availability-groups hadr

May 19 at 5:01 Community♦ 1

votes

answers

14k

views

SQL Server 2012 memory consumption outside the buffer pool

sql-server sql-server-2012 memory

Aug 22 '15 at 3:34 Paul White says GoFundMonica♦ 50.3k

votes

answer

views

Can I recover a SQL database from Standby/Read-Only without a standby file?

sql-server sql-server-2008 recovery standby

Nov 30 '15 at 20:10 Kenneth Fisher 22.1k

votes

answers

views

What is the best way to rebuild a date from integer inputs?

sql-server-2008-r2

Jan 11 '19 at 19:10 IanF1 141

votes

answers

views

Why do temporal tables log the begin time of the transaction?

transaction sql-server-2016 temporal-tables

Feb 20 '18 at 21:27 Brent Kerby 131

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

69 Favorites

What's the difference between a temp table and table variable in SQL Server?

Why shouldn't we allow NULLs?

Why use both TRUNCATE and DROP?

Authoritative source that <> and != are identical in performance in SQL Server

What risks are there if we enable read committed snapshot in sql-server?

Excessive sort memory grant

Asked to Not Use Transactions and to Use A Workaround to Simulate One

SQL Server's “Total Server Memory” consumption stagnant for months with 64GB+ more available

SQL Server Agent Jobs and Availability Groups

difference in execution plans on UAT and PROD server

SQL Server: How to track progress of CREATE INDEX command?

Optimising plans with XML readers

GO After every T-SQL statement

Handling concurrent access to a key table without deadlocks in SQL Server

What is a deterministic method for evaluating a sensible buffer pool size?

Why does my query search datetime not match?

Monumental difference in execution time between queries when using RECOMPILE query hint

Will increased network latency cause table locks in MS SQL Server?

What types of corruption can DBCC CheckDB miss?

Read a partially updated row?

Is a join optimized to a where clause at runtime?

Deadlock error isn't returning the deadlock SQL

Why am I not getting minimal logging when inserting to indexed tables

Who created a procedure? (SQL Server 2008 R2 )

How to lower HEAP Fragmentation in SQL Server?

HADR high worker thread usage

SQL Server 2012 memory consumption outside the buffer pool

Can I recover a SQL database from Standby/Read-Only without a standby file?

What is the best way to rebuild a date from integer inputs?

Why do temporal tables log the begin time of the transaction?