1,094 reputation
1613
bio website binyoga.blogspot.com
location
age
visits member for 3 years, 6 months
seen 2 days ago

Oct
30
answered How to List out all the tables on the SQL server which do not have a Clustered index?
Jul
2
awarded  Curious
Jun
25
awarded  Popular Question
Jun
22
awarded  Yearling
May
9
comment Why is my plan guide not being used?
Thanks, @Rob - that helped.
May
9
accepted Why is my plan guide not being used?
May
6
comment Why is my plan guide not being used?
@AaronBertrand Thanks a lot. Yes I suggested that change too and they will make it in next release.
May
6
awarded  Custodian
May
6
reviewed Approve Why is my plan guide not being used?
May
6
asked Why is my plan guide not being used?
Mar
31
comment SQL server 2012 restore wizard freezes
I have seen the restore wizard hang when an incorrectly formed backup files was selected in the past. Do a RESTORE HEADERONLYand RESTORE VERIFYONLY see if it works. Also, use T-SQL like @marko suggested.
Dec
18
awarded  Famous Question
Jun
22
awarded  Yearling
Jun
16
awarded  Enlightened
Jun
16
awarded  Nice Answer
Apr
15
comment Approach for a 2,000 table migration
I may not be able to answer it but other might need more details in order to answer. Which RDBMS? SQL Server/Oracle/MySQL? Which platform are you migrating to?
Apr
4
accepted Need help in converting this cursor to a set based operation
Apr
4
comment Need help in converting this cursor to a set based operation
Wow, completed in 4 min. Thanks a ton!!
Apr
4
asked Need help in converting this cursor to a set based operation
Apr
1
comment Can you create an unrecoverable SQL Agent back log?
Can you please share more details? I guess you've created a SQL Server job that runs multiple times a day and it is involved in a deadlock. Can you tell us what you job does? what frequency it runs? How did you find about the deadlock?