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...
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...
May 27, 2011 at 8:37 am
Jake Shelton (5/26/2011)
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...
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...
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 ...
May 27, 2011 at 7:05 am
Eric M Russell (5/20/2011)
GSquared (5/20/2011)
Eric M Russell (5/19/2011)
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...
May 25, 2011 at 2:12 pm
Lamprey13 (5/25/2011)
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...
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...
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...
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...
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,...
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...
May 20, 2011 at 1:34 pm
Viewing 15 posts - 4,216 through 4,230 (of 14,953 total)