969 reputation
1510
bio website binyoga.blogspot.com
location
age
visits member for 2 years, 10 months
seen Apr 16 at 6:25

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?
Feb
13
awarded  Notable Question
Nov
28
answered sql server instance using maximum cpu usage
Nov
22
answered Use of Shrink after rebuilding Indexes in sql server 2005
Oct
11
awarded  Popular Question
Sep
16
comment Linked server issue
Here is a kb article
Sep
16
comment Linked server issue
There is a microsoft connect item for a similar issue here with some workarounds
Sep
6
comment Shrink database is not shrinking as much as expected on a 1.5 TB database.
One possibility I can think about is to move the tables you care about to a new data file and drop the one with unimportant tables. I am sure other folks on this forum will have better ideas, so lets wait for them.
Sep
6
answered What is the easiest way to move data from Oracle to SQL Server?
Sep
5
comment Login to SQL Server 2k8 R2 SP1 via Active Directory Group
Can you post what kind of error the user received? you might want to take a look at this link and correlate your error with it- blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx
Sep
3
comment Writing select result to a csv file
+1 for import/export wizard. I forgot that option.