Viewing 15 posts - 3,706 through 3,720 (of 14,953 total)
Funny! An editorial about being reasonable about rules, and the title violates the rules (spelling). 😛
Now that I've finished making fun of Steve, I guess I wreely nede to...
July 21, 2011 at 7:23 am
Brandie Tarvin (7/21/2011)
Or do you just keep in...
July 21, 2011 at 7:14 am
hor_netuk (7/21/2011)
I know times are hard, but a job alert email subscription delivered me the attached vacancy today. For the record, I won't be applying. 😛Hornet
Steve Jobs gets paid...
July 21, 2011 at 7:10 am
Nah. Same problem, just step two on it.
The SSIS FTP object uses a file connection to manage what it uploads. In the file connection, make the connection string...
July 21, 2011 at 7:07 am
Yeah, I've always thought FTS was pretty crippled because you can't materialize the matching string from it.
It would be MUCH more useful if you could query a function from the...
July 21, 2011 at 7:03 am
It's not a recursive query, it's what's called a "correlated subquery". Correlated subqueries reference a value in the outer query.
The subquery tests if a value exists that matches the...
July 21, 2011 at 6:58 am
I have to agree that Merge, by itself, isn't a good reason to spend money on an upgrade.
It's one of many good reasons to upgrade, but it's low on the...
July 21, 2011 at 6:55 am
geo123abram (7/20/2011)
GSquared (7/19/2011)
Do you mean something like this?
DECLARE@VB VARBINARY(100) = CAST('This Is My String' AS VARBINARY(100)),
@Sub VARBINARY(100) = CAST('Is' AS VARBINARY(100));
SELECT CHARINDEX(@Sub, @VB);
Actually, no....
July 21, 2011 at 6:54 am
It's not giving you a failed login error, but a login timeout error. That usually means the service isn't available for the connection type you're using.
Are you connecting via...
July 21, 2011 at 6:53 am
sqlapprentice (7/20/2011)
It turned out for mount points there are two 'security' tabs that you can set up access rights for different accounts.
Please see attachment "old_security_tabl.jpg": the first 'security' tab...
July 21, 2011 at 6:51 am
Steve Jones - SSC Editor (7/19/2011)
GSquared (7/19/2011)
Freddie-304292 (7/19/2011)
July 21, 2011 at 6:22 am
Different queries, different plans. Simple as that.
July 21, 2011 at 6:20 am
Since you can create an SSIS package by running through the Export Wizard, I really can't say it's complex or difficult to build.
Building a text file export by going into...
July 20, 2011 at 6:40 pm
First part, on FTS on a binary file, there's an example of it here: http://www.codeproject.com/KB/architecture/sqlfulltextindexing.aspx
The materialization is more complex, but is mostly just string manipulation. For example, CharIndex will...
July 20, 2011 at 6:37 pm
I use SSIS for that kind of thing.
July 19, 2011 at 3:07 pm
Viewing 15 posts - 3,706 through 3,720 (of 14,953 total)