Re the server specs, they are referenced as...

RAM: 76GB

OS: Windows Server 2008 R2 - 64 bit

Even without the O/S specified, above 3GB will be 64bit; 76GB...

My primary ETL background is SSIS and DTS before that. So I'm a big fan of using it to shunt complex data sets around, including dreaded VB.NET transformations.

I've had...

We are working on automated provisioning of everything and private cloud. That everything includes Windows, SQL, AIX, DB2, SAP etc...

But, the weeks of process for approvals before hand are...

No doubt trolling for a 'laugh', but funnily enough I've designed & supported SQL systems that have processed ~$500M in transactions and that underpin global corporate processes.

Likewise my company used...

Like the other commenters, I've worked with developers who also liked to say no or go off the rails completely on a technology track which was not allowed or...

2 monitors is definitely better, though I'd like to try 3!

I've a 27" and 24" screens, both 1920* resolution, but it still never seems enough with the vast quantity of...

Even working on a 'small' set of data with 1 table of 15 million rows, the fact it was doing lots of user string pattern matching throughout the data and...

We have been looking at SAP HANA - their in memory column store database. The demonstrated performance for a 6TB database was phenomenal - for reading... but we've...

Re your post, SQL dev licensing under MSDN has all of the features of enterprise. I run partitioning and testing on a pro workstation which I used to justify...

I have to agree with the previous comments, I'd use package configurations before ever considering subst etc for production data loads... what happens when you have a wide range...

There does appear to be huge emphasis on degrees from managers, yet I have people working below me with very heavy degrees who dont have a good career path.

I did...

I'm having problems posting to this site - it keeps losing or overwriting my posts :'(

To iwg - my prev post got mangled too!  We don't share LUNs between RDBMS...

Re the post below on RAID 10... if it's critical, put a SAN in!  Our current IBM DS8000 systems have 384 drives, new ones will have 640!  Everything is written...

Dinesh,

Have your triggers got cursors in them to process the multiple records in the inserted/deleted tables?

If not, the following should help, had to convert my triggers for mass updates via...