Viewing 15 posts - 2,506 through 2,520 (of 2,883 total)
recommended is 64k due to that being the size of an extent.
An extent is 1 chunck of data that SQL requests. Having your block size and extent size...
June 7, 2017 at 2:19 pm
I believe what you are looking for is the view catalog.object_parameters.
But that will give you the parameters for each DTSX, not for each project. If you want it for...
June 7, 2017 at 2:04 pm
June 7, 2017 at 9:05 am
June 7, 2017 at 8:16 am
June 6, 2017 at 9:36 am
Just send them the memory requirements for SQL Server.
From the MS website:
All other editions: At least 4 GB and should be increased as database size increases to...
June 6, 2017 at 8:37 am
That was an easy one. I am a little confused why 1% of the people picked bigint though? Thinking that has to be a rounding error.... right?
June 6, 2017 at 8:19 am
My job title is DBA, but I do both DBA work and developer work (both database and software).
It really depends on what the company is looking for. I've read...
June 6, 2017 at 8:13 am
Oh, one other piece of advice - Run the upgrade on a TEST environment first so you can see how it all works and test all of your reports.
I'd...
June 6, 2017 at 8:10 am
tcronin 95651 - Monday, June 5, 2017 1:17 PM2012 NFTS
Then you should be able to extend the partition inside disk manager.
Where I...
June 5, 2017 at 1:38 pm
June 5, 2017 at 1:24 pm
tcronin 95651 - Monday, June 5, 2017 11:33 AMdisk manager not cutting it looking at diskpart
Disk Manager is essentially a GUI for...
June 5, 2017 at 1:12 pm
The 3 variables @dtEffective, @dtCurBus, and @dtsCstBasStart are being used within the...
June 5, 2017 at 1:06 pm
Also, make sure your backups are good before you do an upgrade. Nothing worse than having a failed upgrade and no rollback plan.
And I agree, upgrading to 2016...
June 5, 2017 at 11:47 am
June 5, 2017 at 11:43 am
Viewing 15 posts - 2,506 through 2,520 (of 2,883 total)