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,...

Steve Jones - SSC Editor (4/18/2013)

---

patrickmcginnis59 10839 (4/18/2013)

---

I have to admit, I...

Steve Jones - SSC Editor (4/18/2013)

---

Eric M Russell (4/18/2013)

---

I was serious about the "employment at-will" contract, if that's an option in your country or state. It can include provisions for...

GilaMonster (4/18/2013)

---

Where I live, even asking a candidate to sign an at-will contract can get the company hauled up before the labour board and fined heavily, severance pay or no...