Forum Replies Created
Viewing 15 posts - 166 through 180 (of 377 total)
-
Reply To: Downside to running a query in parallel
thank you everyone. What recommended settings for parallelism should I set SS to? Clearly the defaults are not recommended.
-
Reply To: Can SSIS run C/C++ Script?
thanks everyone!
-
Reply To: SSMS
Ant-Green wrote:Yes expected.
The download site also states that v19 will not uninstall or change v18 in anyway.
The SSMS 19.x installation doesn't upgrade or replace SSMS versions 18.x or earlier. SSMS...
-
Reply To: Size of DB Log File
thank you everyone for your feedback.
I found this setting for the DB:
Look at that max size! so huge! If I change that to say 1GB max then...
-
Reply To: Size of DB Log File
Ant-Green wrote:For the data, do you do deletes of the data? Are the tables all have a clustered index? Are any of them heaps?
Database design can play a strong factor...
-
Reply To: Size of DB Log File
Ant-Green wrote:OK, so lets tackle the log problem first. As you say its a hobby and no criticality if something went wrong with the DB, then you could most likely...
-
Reply To: Size of DB Log File
Ant-Green wrote:Seems a little excessive, a 600GB log for a 17.5GB data space.
But without knowing the workload we cannot give you a definitive answer. But something caused the log to...
-
Reply To: What is wrong with this query?
ScottPletcher wrote:The problem in your original statement is that your calc -- CHARINDEX('^',RIGHT(UNDERLYING_SYMBOL, LEN(UNDERLYING_SYMBOL) - CHARINDEX('^', UNDERLYING_SYMBOL))) -- involves only numeric values, so the result is numeric. Since it's being...
-
Reply To: How to speed up this?
water490 wrote:thank you everyone for your replies. very helpful
i am going to disable that component and see how it affects SSIS run time. i will do this for the next...
-
Reply To: How to speed up this?
thank you everyone for your replies. very helpful
i am going to disable that component and see how it affects SSIS run time. i will do this for the next few...
-
Reply To: How to speed up this?
frederico_fonseca wrote:Sql server edition (express, standard, enterprise) - developer --- if you are using this for Production usage you CAN NOT use developer license - if it is only for...
-
Reply To: How to speed up this?
frederico_fonseca wrote:those files you are getting.... can you answer the following.
- how many files per load
- how many rows per file (max, min and average size)
- how often you get...
-
Reply To: How to speed up this?
frederico_fonseca wrote:why are you dropping and recreating the indexes? what are you trying to accomplish with it?
(for Phil - OP has DROP_EXISTING = ON so indexes are there already while...
-
Reply To: How to speed up this?
Phil Parkin wrote:Are you saying that this proc runs slower in SSIS than it would if you were running it from SSMS?
Have you determined which statement is the slow one (I...
-
Reply To: Move DB
frederico_fonseca wrote:and what have you googleed and read on the documentation about moving datafiles? there are plenty of examples and documentation is rather clear on what to do.
Internet has a...
Viewing 15 posts - 166 through 180 (of 377 total)