Viewing 15 posts - 4,216 through 4,230 (of 14,953 total)
jcrawf02 (5/27/2011)
GSquared (5/27/2011)
Gianluca Sartori (5/26/2011)
jcrawf02 (5/26/2011)
Gianluca Sartori (5/26/2011)
jcrawf02 (5/26/2011)
Wow, you thought that there were too many other DBAs that were better suited than Brandie? That's not very nice...😛
Funny, but 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
May 27, 2011 at 8:42 am
ALZDBA (5/27/2011)
GilaMonster (5/27/2011)
Elliott Whitlow (5/26/2011)
Jan Van der Eecken (5/26/2011)
GilaMonster (5/26/2011)
From the posts the person has made, they are totally out of their depth. 6TB DBs, major...
- 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
May 27, 2011 at 8:37 am
Jake Shelton (5/26/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
May 27, 2011 at 8:34 am
SQLkiwi (5/26/2011)
Steve Jones - SSC Editor (5/26/2011)
I'll say that most of the better applications were self-written. It's hard for someone else to do a good job listing everything you do.
A...
- 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
May 27, 2011 at 7:23 am
Gianluca Sartori (5/26/2011)
jcrawf02 (5/26/2011)
Gianluca Sartori (5/26/2011)
jcrawf02 (5/26/2011)
Wow, you thought that there were too many other DBAs that were better suited than Brandie? That's not very nice...😛
Funny, but you know this...
- 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
May 27, 2011 at 7:19 am
vineet_dubey1975 (5/26/2011)
We are receiving CSVs files where order of column changed but is correct.
for e.g.
file1 columns0 ...
- 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
May 27, 2011 at 7:05 am
Eric M Russell (5/20/2011)
GSquared (5/20/2011)
Eric M Russell (5/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
May 27, 2011 at 6:59 am
GilaMonster (5/25/2011)
SQLRNNR (5/25/2011)
GilaMonster (5/25/2011)
Grant and I are talking Execution plans for a whole day at PASS Summit this year.You are all coming? Right?
Are these the extra breakout sessions 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
May 25, 2011 at 2:12 pm
Lamprey13 (5/25/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
May 25, 2011 at 2:06 pm
Okay. That matches what I expected.
Have you looked into OpenRowset? It can read data directly from Excel or CSV files into a staging table.
The staging table might have...
- 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
May 25, 2011 at 1:25 pm
I'd have to see the tables to really rewrite this, but this trigger has a fair number of "don't ever do that" kind of code in it.
First, you're denormalizing data...
- 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
May 25, 2011 at 12:58 pm
It looks to me like loading the data into pre-built tables with the correct column names and all that would be easier.
Is there a reason that you have to go...
- 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
May 25, 2011 at 11:33 am
As far as what you're describing in the original post, I'd probably use an Outer Apply from A to B, or to a temp table that held the aggregated data...
- 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
May 25, 2011 at 11:05 am
djackson 22568 (5/24/2011)
roger.plowman (5/24/2011)
Steve, that's a recipe for absolute disaster.
First, you're falling into the "get it out the door, we'll test it afterward" trap. Second, users will initially love it,...
- 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
May 25, 2011 at 9:39 am
The whole point of the sp_ prefix is to tell SQL Server to look in master first. It gives a slight performance improvement on applications that use the system...
- 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
May 20, 2011 at 1:34 pm
Viewing 15 posts - 4,216 through 4,230 (of 14,953 total)