Viewing 15 posts - 46 through 60 (of 14,953 total)
Document your servers, including provisioning (prod/QA/test/dev), version, patch-level, etc., in a table. I have a database called "DBA" that I use for that kind of thing.
Comes in useful pretty...
- 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
June 15, 2016 at 8:57 am
This can turn into a complex question. The rule-of-thumb that I try to follow on things like this is: The more clever the solution has to be, the worse...
- 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
June 15, 2016 at 8:54 am
Jeff Moden (6/14/2016)
GSquared (6/14/2016)
Jeff Moden (6/10/2016)
Eric M Russell (6/10/2016)
Eric M Russell (6/7/2016)
They're asking the wrong type of questions for a job interview.
I'm not saying that string manipulation is a bad...
- 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
June 15, 2016 at 7:37 am
Two data flow tasks. Each with a "check for the file" step, or a "for each" loop for the file type.
Keep it simple.
- 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
June 15, 2016 at 7:28 am
I just tested a Calendar table version against the UDFs defined here.
Calendar table was consistently about 10X faster.
- 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
June 14, 2016 at 1:38 pm
I've used that plan (or variations on it) many times.
Just keep in mind that the table may have locks, etc., on it that will cause this to bomb.
If possible, set...
- 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
June 14, 2016 at 12:13 pm
There's an easy way to use For XML Path to turn a set of rows into a list. For some reason, this site isn't letting me post a sample...
- 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
June 14, 2016 at 12:08 pm
Lowell (6/14/2016)
aww nevermind, i didn't notice the IS NOT...
- 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
June 14, 2016 at 11:59 am
I wouldn't do this in an SQL function. I'd put it as a column in a Calendar table and have it pre-calculated and queriable.
Use Calendar tables for this kind...
- 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
June 14, 2016 at 11:06 am
I queried your sample Fields XML. It seems pretty straightforward.
I took out the rs namespace from the sample, and added a root so it would be well-formed, but 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
June 14, 2016 at 11:04 am
Eric M Russell (6/14/2016)
GSquared (6/14/2016)
And here's the trick question: You have two tables, A and B, and you...
- 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
June 14, 2016 at 9:41 am
For this, I'd use a many-to-many table with a HierarchyID datatype column that allowed each person to be in multiple hierarchies.
Or will you have depths greater than about 400 nodes?...
- 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
June 14, 2016 at 9:16 am
I do ask trick questions. One of my standard tech-screening questions is:
And here's the trick question: You have two tables, A and B, and you want all the rows...
- 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
June 14, 2016 at 9:14 am
Jeff Moden (6/10/2016)
Eric M Russell (6/10/2016)
Eric M Russell (6/7/2016)
They're asking the wrong type of questions for a job interview.
I'm not saying that string manipulation is a bad question. It's just...
- 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
June 14, 2016 at 9:07 am
I'm not sure I understand exactly what you're doing, but it sounds like you could use a Sequence object and just Concat() it onto the end of the string and...
- 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
June 14, 2016 at 8:58 am
Viewing 15 posts - 46 through 60 (of 14,953 total)