Viewing 15 posts - 4,546 through 4,560 (of 7,168 total)
The 1TB in 30 minutes example was leveraging parallelism within SSIS. If you're using a foreach loop then you're making SSIS single-threaded. Since you have a varying number of files...
April 10, 2012 at 9:29 am
SQLKnowItAll (4/10/2012)
The other option is to do this in separate queries starting with checking col 3 and moving data left. Then column 2.
That's the ticket, but only one query...
April 10, 2012 at 9:10 am
jwhisman (4/9/2012)
opc.three (4/9/2012)
April 10, 2012 at 8:41 am
Lynn Pettis (4/9/2012)
Actually, the inner rollback rolls back all open transactions.
Right...what I was thinking is the COMMIT in the outer proc would be called when @@TRANCOUNT was 0.
April 9, 2012 at 5:24 pm
This is a very small amount of info to go on....but I'll take a guess. It looks like your inner proc is not raising an exception whenever it rolls back...
April 9, 2012 at 5:13 pm
Lynn Pettis (4/9/2012)
Need the sample data in a format that is readily consumable. A series of INSERT INTO statments fits that bill.
+1
@Half Bubble
SSMS Tools Pack can help.
April 9, 2012 at 4:52 pm
SELECT LEN('SELECT w.ID,
w.[Rdc],
w.[Pby],
...
April 9, 2012 at 4:47 pm
L' Eomot Inversé (4/9/2012)
Jeff Moden (4/8/2012)
April 9, 2012 at 4:45 pm
sqldba_newbie (4/9/2012)
thanks for detail explanation. Dumb question, how do i know size of my sql query?
Using your sample code from earlier the bold string-literal is the 'query' argument:
SELECT *
FROM...
April 9, 2012 at 4:40 pm
sqldba_newbie (4/9/2012)
opc.three (4/9/2012)
April 9, 2012 at 4:04 pm
Computers are either joined to a domain or they are not. You can either check the computer, or check Active Directory to see if the computer is part of the...
April 9, 2012 at 3:55 pm
An alternative to using OPENQUERY is to use the EXECUTE...AT syntax to also force the query to execute on the remote server. OPENQUERY is a bit more flexible in that...
April 9, 2012 at 3:48 pm
sanj_love89 (4/7/2012)
2012-04-07 10:40:29.41 Logon Error: 17806, Severity: 20, State: 2.
2012-04-07 10:40:29.41 Logon SSPI handshake failed with...
April 9, 2012 at 3:25 pm
Keeping the same server name would cover you, but in my experience that is an option less so than it is an option.
Ideally I try to use something like Cisco's...
April 9, 2012 at 3:17 pm
I am thinking of a data flow that goes like this:
1. OLE DB Source from ServerA.Database1 selects customerIDs where name/address is null
2. OLE DB Destination to ServerB.tempdb table with customerID
3....
April 9, 2012 at 1:44 pm
Viewing 15 posts - 4,546 through 4,560 (of 7,168 total)