mosborne (4/30/2013)

---

Yea, the real world aspect, is if they are 'that' good, they will move onto either high priced consulting or higher level job which kind of moves away from...

There are a lot of DBAs who don't have people skills, a university degree, or even socks, but they are amoung the best at what they do.

Well, monitoring and disaster recovery are perhaps the two most important DBA skills. People skills is what would differentiate an exceptional DBA who loves their job, gets invited to lunch,...

I tend to take several mini-vacations a year, like a four day weekends to section hike the Apppalachian trail or immerse myself in a home improvement project.

Krishna1 (4/28/2013)

---

Dear All

I was doing bcpin with 20 million records. I stoped it in between. Then tries to delete the table form the DB. It took long time hence stoped...

Run a sample procedure call in a SSMS Query window with the 'Include Actual Execution Plan' option enabled. This will reveal the relative cost of each query within the stored...

It's OK to let things get a little chaotic while you're away on vacation. You don't want to be one of the guys who take off for a week and...

I've seen clustered tables with a key that was so poorly implemented, I wish the developer had just left it as a heap. A heap will perform better and require...

There there are plenty of user defined functions posted on the web that will parse a string into a resultset of keywords, compare two strings, etc. They may provide the...

girl_bj0619 (4/23/2013)

---

i tried this but i get this error:

The target of a MERGE statement cannot be a remote table, a remote view, or a view over remote tables.

merge to linked...

Karan_W (4/23/2013)

---

I am using SSIS 2008. The task is following.

1: Execute a storted proc and using the output create a CSV file.

2: this CSV file need to be copy to...

I hope it never gets to the point where corporations can claim ownership of gene sequences (whether they be natural or engineered) in our body. That would make procreation look...

If you're struggling with a group of users, or a 3rd party application, that insists on connecting to the server via the SA "system administrator" account, then there is a...

Below is what I think to be a simplified version of what you're attempting to accomplish. It involves making a single indexed scan / delete against the transactional and master...

SQL Server 2012 has introduced some significant changes in services and features like availability options, Semantic Search, FileTables, ColumnStore indexes, to name a few. For a DBA or BI developer,...