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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 21, 2011 at 7:23 am
Brandie Tarvin (7/21/2011)
Or do you just keep in...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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....
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 21, 2011 at 6:51 am
Steve Jones - SSC Editor (7/19/2011)
GSquared (7/19/2011)
Freddie-304292 (7/19/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 21, 2011 at 6:22 am
Different queries, different plans. Simple as that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 20, 2011 at 6:37 pm
I use SSIS for that kind of thing.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 19, 2011 at 3:07 pm
Viewing 15 posts - 3,706 through 3,720 (of 14,953 total)