It depends on what they're planning to use CLR functions for.

Have you confirmed how many CPU are visible to SQL Server? This could be limited by licensing or configuration.

http://www.eraofdata.com/how-many-cpus-can-sql-server-use/

GilaMonster (12/22/2015)

---

Why? Parallel execution is good, it means SQL's using resources effectively to return results quickly. A parallel query is...

Remotely hacking another driver's Bluetooth component system is a way cooler and less violent way to express road rage than pulling out a handgun. 🙂

Remember the story about the 5 year old kid who accidentally discovered he could hack through XBox user authentication by padding the password field with a spaces?

http://www.cnn.com/2014/04/04/tech/gaming-gadgets/5-year-old-xbox-hack/index.html

Ivanova (12/21/2015)

---

Slightly off-topic; while working for a large financial institution, I was approached by one of the security team. He was a highly-paid and allegedly very security-savvy contractor. His request...

Ed Wagner (12/21/2015)

---

Eric M Russell (12/21/2015)

---

I think the whole concept of a 'SA' account is a bad idea, because essentially it's an account which has full access and which can...

Let me guess... the table is 100 GB, there are twenty foreign key dependencies, and they want it deployed to production before Christmas? 😛

If the new columns are required by the business and there is a 1x1 normalized relationship between them and the original table, then add then to the original table. What...

What do we mean by adding "random" columns? Do the new columns fall within the scope of the requirements, and is this essentially a 3NF table modeling design?

Perhaps what you need is a 'Derived Column Transformation' task between your Source and Destination that uses expression and leverage SUBSTRING function to build string in format YYYY-MM-DD and also...

T2512 (12/21/2015)

---

That's what i always thought, from a users perspective speed is the only factor.

During an interview I was asked apart from reducing speed, what else does a developer...

sam 55243 (12/18/2015)

---

Hi Eric,

Your solution will work however I have one query . Can I handle lock/deadlock issue with this approach. For instance if in any of the sub-procedures there...

Ed Wagner (12/19/2015)

---

Eric M Russell (12/18/2015)

---

Orlando Colamatteo (12/18/2015)

---

Eric M Russell (12/18/2015)

---

Renaming the real 'SA' account, and then creating a new (so called) 'SA' account with least privilege can be useful...

Is the transaction log competing for space with the data files or another database? Perhaps there is no need to actually shrink the log, just let it recycle.