Viewing 15 posts - 3,211 through 3,225 (of 9,720 total)
The misconception would be mine, then. This is sample code supplied to me by the vendor receiving the file. It seems pretty generic and the person who gave it to...
April 25, 2014 at 10:49 am
Then what are you averaging by?
April 25, 2014 at 8:56 am
As far as I can tell, it's reading in chunks because that's how it transmits. It's part of the multiform / data-part thing. But again, I got this code from...
April 25, 2014 at 8:26 am
I just posted an issue with a VB Script Task (SSIS) and would appreciate the thoughts of anyone with experience.
My in-house Dev is telling me I can't do this...
April 25, 2014 at 7:58 am
Nevermind. I finally got my google-fu working (needed to look for "orphaned file", not "phantom file"). The solution is here: http://connect.microsoft.com/SQLServer/feedback/details/482820/orphaned-log-file-can-not-delete-log-file-sysfiles1-duplicate-namesnd%20259164%20(Denali)
April 25, 2014 at 6:15 am
As Megha said, grab the count of your files.
--You only need one DECLARE statement
-- and you can assign the values within that statement too.
-- Saves on typing
DECLARE @current_date DATETIME...
April 25, 2014 at 5:44 am
If you need to do this as a Stored Procedure, all you have to do is get a Linked Server from the other server, then do a LEFT OUTER JOIN...
April 25, 2014 at 5:31 am
If you have the money to invest in high availability options, you should. Clustered servers, mirrored instances, etc. are all good options for mission critical databases. And, as Grant said,...
April 24, 2014 at 5:13 am
Pat, you misunderstood my problem. We had all the timeouts maxed out or set to 0 for no timeouts. Despite this, we were having problems with the timeouts.
I'm not sure...
April 23, 2014 at 11:59 am
Jeff Moden (4/22/2014)
ChrisM@Work (4/22/2014)
April 22, 2014 at 10:47 am
ChrisM@Work (4/22/2014)
Does anyone around here know anything about output lists from index seek operators, by any chance? Don't all raise your hands at once, you might drop your rod...
What are...
April 22, 2014 at 6:53 am
qew420 (4/21/2014)
...
I can check the missing Indexes but again only counting the # of records .. system...
April 22, 2014 at 4:36 am
*THAT* is a filleted fish?
Ummm, would you take it the wrong way if I begged you to keep your day job and forget about opening that restaurant? @=)
April 22, 2014 at 4:28 am
It doesn't matter that everything was good until Replication was added. When you added Replication onto the server, you added an extra load plus you added a whole bunch of...
April 22, 2014 at 4:22 am
Hey, run this script on the Subscriber and see if you're getting lots of small waits or some (or lots) of long waits. Post the results, please.
select * from...
April 21, 2014 at 10:55 am
Viewing 15 posts - 3,211 through 3,225 (of 9,720 total)