16,101 reputation
11248
bio website sqlsybase.azurewebsites.net
location New York, United States
age
visits member for 2 years, 5 months
seen 7 mins 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.


4h
comment what is running VSS on my server
Yes I meant server side trace within SQL Server. If you want to track on OS level, I would recommend using sysinternals process explorer.
5h
comment what is running VSS on my server
Kick off a server side trace. That will tell you who is doing what. Make sure to filter by the stuff that you only need.
5h
reviewed Close Oracle 12c CLOB data type is not working as expected
5h
reviewed Close Joining data but without taking into account the where clause
5h
reviewed Close Running more than one copy operations in IBM Datastage in a single job
5h
reviewed Close Peer to peer replication error
5h
reviewed Close How to pass Parameters to stored procedure with input parameters from checkboxes
1d
awarded  Popular Question
Oct
17
comment How to set a restart on a TSQL Job?
Why would a job get hung ? It has to do with some blocking or some problem with the job logic. Please provide more details. Alternatively, you can run sp_whoisactive and see what it is doing ? sys.dm_os_waiting_tasks will tell u why it is waiting.
Oct
16
comment Log shipping option not showing
Do you have proper permissions?
Oct
16
comment ASSIGN value for cmd in sysprocesses? What does it mean?
Sp_whoisactive to the rescue. Run it and save the output to table for further analysis. Alternatively, you can use event notification with blocked process report as well.
Oct
15
revised How to use COLLATE with UNION
deleted 3 characters in body
Oct
15
revised SQL Server mirroring causing issues
added 6 characters in body
Oct
15
comment “Could not insert a backup or restore history/detail record in the msdb database” While restoring msdb
Different errors. Can you try restoring on a different server and take full and log backups? Something is not right - io subsystem may be ?
Oct
15
comment Deploying SQL Server database changes from test to production server
Are you using enterprise edition of SQL server 2012?
Oct
15
comment I NEED HELP IN ONE QUERY
no caps please
Oct
14
revised Trying to search using MATCH and AGAINST keyword
added 16 characters in body
Oct
14
comment .WRITE clause performance optimization
@gotqn updated my answer.
Oct
14
revised .WRITE clause performance optimization
added scripts as requested by OP
Oct
14
revised Deploying SQL Server database changes from test to production server
spelling mistake corrected