Viewing 15 posts - 1,171 through 1,185 (of 5,685 total)
SQL Kiwi (9/14/2012)
Gianluca Sartori (9/14/2012)
If that happens, I'll run away and hide as far as I can.Uh, wait... isn't that New Zealand?
C'mon Paul, get the guest room ready! 😀
According...
September 14, 2012 at 5:24 pm
I think I'll just chill out in the threads I'm already in after reading a few that I've bypassed due to time. "Much ado about nothing" is something I...
September 14, 2012 at 4:31 pm
rena24 (9/14/2012)
So, before I insert my Data in a Table I run the vb.code above and I recreate the file with the...
September 14, 2012 at 2:49 pm
Ah, the old mainframe data sort issue. I HATE THEM. However, the solution isn't rediculously hard... as long as you're not loaded to SQL yet.
This takes a bit...
September 14, 2012 at 2:41 pm
jtc900502 (9/14/2012)
Currently the users are not accessing the SPs. They have tried to pull data into excel (MS Query) using the physical tables but had a...
September 14, 2012 at 2:07 pm
There's no good way out of this mess, unfortunately. What do you do when a row's identifier is repeated but contains different data in the rest of the columns?...
September 14, 2012 at 1:59 pm
GilaMonster (9/14/2012)
Lynn Pettis (9/14/2012)
Nothing like having two people obviously in over their heads this week.Which 2 are you thinking about?
Installing SQL 2012, dropping filegroups? Or are there more?
Then there's 3......
September 14, 2012 at 1:52 pm
jtc900502 (9/14/2012)
Is it insane to have SSIS to use a Stored Procedures to do incremental loads into DW, if the frequency is like every 5 minutes?
In a simple answer, no....
September 14, 2012 at 12:53 pm
I agree with the theory. The practice, on the other hand, is a lot harder to implement.
"Can you slap me together a quick prototype? I need to see...
September 10, 2012 at 12:43 pm
tmoleary (9/7/2012)
September 10, 2012 at 12:36 pm
Lynn Pettis (9/7/2012)
Evil Kraig F (9/7/2012)
September 7, 2012 at 6:14 pm
SQLRNNR (9/7/2012)
Lynn Pettis (9/7/2012)
September 7, 2012 at 6:08 pm
tmoleary (9/7/2012)
MainDocumentAndAddendaActualPlan.sqlplan is from the first queryMainDocumentAndDiagnosesActualPlan.sqlplan is from the second query
MainDocumentAddendaAndDiagnosesEstimatedPlan.sqlplan is from the third query
Starting with these, the first problem is the 286 billion row estimate going into...
September 7, 2012 at 5:41 pm
apache626 (9/7/2012)
September 7, 2012 at 3:58 pm
In addition to Sean's recommendation, if you're allowing the linked server to 'passthrough' the existing credentials, doublecheck you're not running into what's known as the 'double-hop' issue for kerberos. ...
September 7, 2012 at 3:55 pm
Viewing 15 posts - 1,171 through 1,185 (of 5,685 total)