Not anymore dude ! I am assuming you are talking about 12K USD per year and not month. It's getting expensive there in India. To live like a king you...

With 7+ yrs of total experience and 3 yrs of SQL DBA experience in SQL 2005, you can certainly command a hike of 30% from your current salary. Again depends...

Thanks a million Erik!

Thanks Erik. You have been very helpful with my XML questions.

Yet another question slightly off topic, is there a way to validate XML schema within SSIS ? The requirement is...

Thanks Erik, that was a very good explanation. Really appreciate your help so far. So depending on the Day light savings i'll need to add 3 or 4 hours to...

Thanks Erik. Our computers are running at the GMT Time zone (GMT-08:00) Pacific Time (US & Canada). I still don't understand how does it default to previous day 9 PM....

Ah i see so thats the offset, thanks Eric for the quick reply, however i do not understand how it does it convert it to 9PM always. Could you please...

Hello all,

I have a similar requirement of importing an XML file to SQL Server db. XML Source is the way to go for. But i have a question, some of...

Make sure in the Job step advanced properties you have set the 'On Failure quit the Job reporting failure' option.

Regards

Amol

Thanks for the brilliant explanation Matt. Really appreciate it.

So that means the autogrowth doesn't matter when the recovery model is set to SIMPLE. Is it?

I also want to...

Yeah we changed the recovery model from FULL to SIMPLE and seems to have made the server perform better. I want a more detailed explanation as to why it occurs.

Thanks...

Thanks Paul, it worked.

Hello,

I had the exact same requirements of embedding " " for C:\Program Files in expression builder in SSIS.

I implemented the above solution and it worked like a charm.

Thanks,

Amol

Hi,

I have had same issues, try using

SET FMTONLY OFF;

EXEC dbo.my_stored_procname

This should work.

Also i found something useful on the net.

http://sqlserverpedia.com/blog/sql-server-bloggers/ssis-stored-procedure-metadata/

Hope this helps.

Thanks,

Amol

Doing large updates in one batch will surely lead to blocking because of the fact that SQL Server will do lock escalation from row locking to page/table locking since that's...