Viewing 15 posts - 16 through 30 (of 237 total)
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...
February 9, 2015 at 7:45 am
Hany Helmy (12/30/2014)Wow :w00t: 41% didn`t know about the "Extra comma in column list" will not prevent you from creating a table.
Hany Helmy (12/30/2014)
Why would you expect people to know this?...
January 20, 2015 at 6:15 am
Emil Bialobrzeski (12/10/2014)
1+1+1+1+1+1+1+1+1+1+1+1x0+1 = ?
most of the answers was 1. So saying Simple may apply differently to others...
December 10, 2014 at 6:41 am
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...
October 28, 2014 at 7:14 am
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...
October 22, 2014 at 6:32 am
October 20, 2014 at 7:35 am
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....
September 23, 2014 at 1:53 am
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.
August 7, 2014 at 8:11 pm
Daniel Matthee (8/2/2014)
But since this is string parsing it will be intense on the sql server. So i recommend to rather change the...
August 2, 2014 at 3:42 am
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...
July 30, 2014 at 1:46 am
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...
July 29, 2014 at 8:28 am
I would suggest tweeting it with #SQL or other related hash tags, bound to get some responses.
May 19, 2014 at 8:12 am
May 19, 2014 at 8:08 am
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,...
May 19, 2014 at 7:44 am
LutzM (10/4/2011)Since [ is a meta-character in wildcard expressions, you'll need to wrap it with another set of brackets:SELECT PATINDEX('%[%',mytextfield)
Interestingly, that same pattern doesn't work for the closing square bracket...
April 21, 2014 at 6:57 pm