Viewing 15 posts - 16 through 30 (of 1,161 total)
Whether or not this is a valid licensing scenario (I agree with Grant - find out from MS or a reseller), the costs of licensing a whole 40 cores of...
July 31, 2014 at 3:54 am
The package upgrade wizard only upgrades the package, not the config file.
In this case, your config file is specifying a provider name that's no longer the correct version, so it's...
July 28, 2014 at 9:08 am
I think you'd still have a 2GB max size that you can manipulate through XQuery, wouldn't you?
July 28, 2014 at 6:12 am
SSIS source tasks support multiple output buffers. 80 tables sounds pretty extreme, but you could, in theory, add 80 output buffers into a data flow into 80 destinations with a...
July 28, 2014 at 5:36 am
There's a basic tutorial here:
http://sql31.blogspot.co.uk/2013/03/how-to-use-script-component-as-data.html
Basically, most of your code goes into CreateNewOutputRows() and you just call Output0Buffer.AddRow() as you iterate through the XMLReader...
July 28, 2014 at 5:13 am
C# XML serialisation should be quickest if implemented correctly.
How have you implemented it? It sounds like you might be doing individual inserts for each row via a database connection...
July 28, 2014 at 4:48 am
murnilim9 (7/24/2014)
Hey ... I just applied OLA'script in my testing server and it works fine 🙂 but in his example of "EXEC stored proc such as :
EXECUTE dbo.IndexOptimize
@databases...
July 25, 2014 at 6:29 am
It can work either way. Usually, the child packages would be set to either inherit a variable from the parent, or they'd all be set to pick up the value...
July 24, 2014 at 9:59 am
What's the DDL for memorytable?
If you're making it durable, then you may be bottlenecking on I/O - either for transaction logging, or for the sequential write out to data...
June 13, 2014 at 7:57 am
There's no straight forward answer to that.
I think for the majority of regular OLTP use cases, running on identical hardware, without code changes to utilise new features, it's going...
June 13, 2014 at 3:52 am
Fundamentally, as long as this product correctly interfaces with VSS and the VDI (which I'm sure eVault does), it is possible to restore the mdf and ldf file via the...
June 6, 2014 at 10:19 am
Ed Wagner (6/6/2014)
Koen Verbeeck (6/6/2014)
Ed Wagner (6/6/2014)
Koen Verbeeck (6/6/2014)
Select on an Oracle view with all the of...
June 6, 2014 at 7:45 am
What makes you think you've ruled out the plan cache? This sounds like a classic case of parameter sniffing to me.
If you add a WITH RECOMPILE hint to the...
May 30, 2014 at 6:30 am
In regards to the original issue, are you just doing this so they have logical names when browsing in SSMS? If so, you can use the Registered Servers functionality and...
May 30, 2014 at 6:16 am
Jeff Moden (5/28/2014)
bvarnell 55573 (5/28/2014)
For ease of telling the story, "ServerA" is when I connect to the server by...
May 30, 2014 at 6:10 am
Viewing 15 posts - 16 through 30 (of 1,161 total)