152 reputation
5
bio website bhavsar.us
location NYC Area
age 34
visits member for 1 year, 11 months
seen Jul 1 '13 at 20:51

Database adminstartor in Danbury, CT 06810

Ckeck my linkedin


Dec
30
awarded  Autobiographer
Oct
2
comment SQL Server agent option in SQL Server Express
SQL express does not have agent. you have to buy standard or enterprise version to get it.
Feb
26
comment Does disabling index exists in a table?
if you did not drop the index then it's still exist, Yes it will showdown the insert but will help updates. Thic command exec databasename..sp_help 'tableName' will saw you table and index information on that table. please replace databasename and tablename. Hope this help
Jan
14
awarded  Custodian
Jan
14
reviewed No Action Needed mysql auto adjusting max connections values
Jan
14
comment Shrink database operation in maintenance plan failed
Do you know which "DB maintaince" task you are running when this happen. This soulds like block!
Jan
2
revised Color syntax printing in SSMS 2012
more detail tags
Jan
2
suggested suggested edit on Color syntax printing in SSMS 2012
Dec
31
revised How to split the comma separated list in the stored procedure
more detail tags
Dec
31
awarded  Organizer
Dec
31
revised INNER JOIN Giving time out on large database
more detail tags
Dec
31
suggested suggested edit on How to split the comma separated list in the stored procedure
Dec
31
awarded  Supporter
Dec
31
suggested suggested edit on INNER JOIN Giving time out on large database
Dec
28
awarded  Teacher
Dec
28
comment Changing field length when foreign keys reference primary key field in table
there is no disable option in MSSQL
Dec
28
answered Changing field length when foreign keys reference primary key field in table
Sep
6
suggested suggested edit on Shrink database is not shrinking as much as expected on a 1.5 TB database.