Which provider are you using in the linked server? Probably better not to use the generic ODBC provider, but if you're already using the DB2 specific one it could be...

Toreador (1/2/2015)

---

Why would you expect people to know this?...

Xavon (12/10/2014)

---

paul.knibbs (12/10/2014)

---

Emil Bialobrzeski (12/10/2014)

---

i saw lots of people on social sites having problems with:

most of the answers was 1. So saying Simple may apply differently to others...

Primary key creates a clustered index by default, only if there is no existing clustered index. It's often the case that you want a clustered index on something other than...

Well you could do it with security. The application is either using a SQL login, a single AD login or service account, or it's passing through end user credentials. Deny...

KoldCoffee (10/18/2014)

---

using Adventureworks2008R2 database I'd like to illustrate syntax I ran into and am unfamiliar with and I want to know if it's a mistake that SSMS doesn't catch.

SELECT TOP...

Great article.

Speaking of scientific method, the most frustrating part about profiling and measurement on databases is how inconsistent it is because there are so many variables you can't control for....

You should probably have started that in a new thread, your question will get lost if you tag it on to the end of an old thread like this.

Anyway, assuming...

Daniel Matthee (8/2/2014)

---

So this can easily be done in SQL.

But since this is string parsing it will be intense on the sql server. So i recommend to rather change the...

dabello88 (7/29/2014)

---

thanks for the reply!

I google split function and found the following function that gets me on my way but I'm having trouble trimming it so I only get the...

dabello88 (7/28/2014)

---

What up Guys,

First time posting a question here. I'm not entirely sure how to solve. I have the following string I need to parse in SSRS so that it...

I would suggest tweeting it with #SQL or other related hash tags, bound to get some responses.

Alan.B (5/18/2014)

---

Your update query should be fine and, no, it does not matter if you include the table in the FROM or table operator clauses (e.g. JOIN & APPLY).

With...

Good article, and very important.

I noticed some queries only today being executed by very experienced analysts doing awful non-sargable sins like joining a date column to a datetime column,...

Interestingly, that same pattern doesn't work for the closing square bracket...