15,582 reputation
11244
bio website
location New York, United States
age
visits member for 2 years, 4 months
seen 7 hours ago

I am a Sr.SQL Server and SybaseASE DBA working for a company that makes software for Investment Banks globally as well as does Hosting business. I love working on performance tuning, migration, baselining, process automation, Cloud (Azure), High availability as well as Disaster recovery technologies, etc. I firmly support SQL Server community and so being on this site is my way of gently giving back to the community of what I have earned over the years.


1d
revised Performance/Health checking queries for a user with Read permissions
added 150 characters in body
1d
answered Performance/Health checking queries for a user with Read permissions
2d
comment Is database record access sequential after retrieving the indexed page from disk?
This is a very broad topic and will be closed soon. To answer your question, for sql server, I would suggest you to read Reading Pages and Sequential Read Ahead
2d
comment SQL Server 2008 R2 - remove line below heading (which has ----,----) - dont have SSIS
@ShawnMelton my bad .. will delete my comment :-(
2d
comment On deleting a record from a table, Save that data in another table.
@AmeyaJoshi Check my answer here. That will give you some direction.
Sep
13
revised How to create procedure for this problem
added 12 characters in body
Sep
13
comment How to create procedure for this problem
Its very difficult to understand your question. I am guessing that you are probably looking for a trigger based solution as described here.
Sep
12
revised Schedule a value into calendar
edited tags
Sep
11
answered Query Governor Cost Limit relationship with Time
Sep
10
reviewed Edit suggested edit on SQL Server 2008 mirroring migration to SQL Server 2012 always on
Sep
10
revised SQL Server 2008 mirroring migration to SQL Server 2012 always on
Slight grammar improvement. Make use of the markdown formatting.
Sep
10
comment Index optimization for table that is truncated every day
@AaronBertrand Just to clarify, BOL recommends to update stats after TRUNCATE operation as well - Consider updating statistics after performing maintenance procedures that change the distribution of data, such as truncating a table or performing a bulk insert of a large percentage of the rows.. Agree with you that once the tables are truncated and then populated with new data, stats should be updated.
Sep
10
comment Index optimization for table that is truncated every day
I would suggest to update statistics after truncate / after lots of inserts. That will help Query Optimizer take better decision.
Sep
10
comment Iterating over the output of a SQL query with PowerShell
Shouldn't this @("Instance1","Instance2", "Instance3") be @("server1\Instance1","server2\Instance2", "server1\Instance3") ?
Sep
10
comment Database Properties Error - sys.spt_values missing but dbo.spt_values works?
Try installing the latest SSMS 2014 Microsoft SQL Server Management Studio version 12.0.2000.8
Sep
10
revised Pulling Top queries returns NULL in query plan and sql text
added 1523 characters in body
Sep
10
answered Pulling Top queries returns NULL in query plan and sql text
Sep
9
comment CHECKPOINT or COMMIT writes to disk?
Agreed this is far better than all of the ones .. Thanks @RemusRusanu !
Sep
9
comment Transaction Log Backups
@shanky did u got the message *Processed 0 pages for database 'logbackup_test', file 'logbackup_test_log' on file 1. 100 percent processed. BACKUP LOG successfully processed 0 pages in 0.072 seconds (0.000 MB/sec) .. Something like that .. It indicates that the log backup is empty .... As I said .. You have to be very precise to skip a log backup .. No activity does not mean an empty log backup. My example clearly suggest that it is possible, but as I said .. What's the point in doing it .. If u get it wrong, you will loose point in time restore.
Sep
8
comment INSERT takes over 5 hours, when inserting more than specific number of rows
Can you post what is the wait associated when insert is taking such a long time ?