Reputation
34,633
Next tag badge:
393/400 score
135/80 answers
Badges
3 46 112
Newest
 Nice Answer
Impact
~2.3m people reached

7m
comment Why does creating a buffer pool extension in SQL Server producing poor performance?
need more info .. what Service pack + CU are you on ? How much is Max memory allocated out of 128GB ? What size is the buffer pool extension ? What type of activity is happening on the server when you say performance grinds to an almighty halt! ? What are the wait stats when the performance is bad ?
12m
revised To find SQL Server is actually used or not?
added 302 characters in body
1h
answered To find SQL Server is actually used or not?
8h
comment Single instance SQL server, needs limited access to remote network resource
I would suggest having an SP that takes the file name that can be imported or an SSIS package.
23h
comment Foreign keys not trusted but they were not disabled
Controlling Constraint Checking by Bulk Import Operations will help you.
1d
comment Foreign keys not trusted but they were not disabled
is the data loaded using bulk insert ?
1d
revised Update field in SQL Server Table Dynamicaly
added 104 characters in body
1d
comment Locking in stored procedures
You should post the deadlock graph XML - that will help us to help you. I agree that there are many possibilities and without looking at the deadlock xml, we cant help you much.
1d
revised subscriber table needs to be updated - how to use a batch process AND how not to upset the replication while doing it?
added 7 characters in body
1d
comment SQL Server Index recomended but already there (DMVs)
highly suggest you to read - Don't just blindly create those "missing" indexes!. Indexes have maintenance cost and storage cost associated. Test any new index creation on a dev/test machine and validate the gain from it.
1d
comment Can we track data changes on all SQL Server tables based on primary-foreign key relationships?
Have you explored change data capture or change tracking ?
1d
revised Data transferring
added 48 characters in body
1d
comment SQL server export wizard gets stuck
May be autogrowth is kicking in frequently - size your data and log files properly.
1d
answered SQL Server Select in XML field
1d
revised How to set ENVREFERENCE when creating a SQL Server job
added 2 characters in body; edited tags
1d
comment How to set ENVREFERENCE when creating a SQL Server job
Does this answer help ?
1d
answered Exclude databases from automatic full backup
2d
revised T-SQL : Is string a Palindrome?
edited tags
2d
revised T-SQL : Is string a Palindrome?
added 74 characters in body; edited tags
2d
comment Do temporal tables log changes when there are none?
Not sure (have not tried it), but would be worth investigating on SQL Server 2016 temporal history tables + Stretch database functionality.You can store your data permanently :-)