Viewing 15 posts - 2,296 through 2,310 (of 2,857 total)
Geeze, I seem to be bad at offering advice today, eh?
I apologize for the misinformation I provided.
That being said, and back to the OP, I don't...
August 21, 2017 at 10:42 am
Right... forgot that developer only went free with future versions.
With express, does that let you do SSIS? I can't remember and it has been a very long time...
August 21, 2017 at 9:10 am
I think that you need to use Visual Studio 2008 (with the SQL Server Data Tools installed) and that should allow you to create SSIS pacakges to run against a...
August 21, 2017 at 8:33 am
Pretty sure Express doesn't include the advanced things like SSIS. It should be part of the install (Integration Services). I actually thought that SQL Server Agent didn't work with express...
August 18, 2017 at 3:25 pm
Not sure if I'm helping or not, but I know where I work, we have a separate job for cleaning up the history. My preference is to have a maintenance...
August 17, 2017 at 10:25 am
OH... you could likely sum it over a partition then, no?
It is the t.MktDiff column that you are trying to sum up... what if you change the line:
August 16, 2017 at 11:20 am
August 16, 2017 at 9:21 am
After it is...
August 16, 2017 at 8:34 am
Do all of your parameters need to be unique? That is, is could you reduce the number of parameters by reusing some?
If not, could update the parameters as...
August 15, 2017 at 4:24 pm
Can you post DDL and sample data for TRValue and TRProp?
We'll need more info in order to help. But best guess is that it isn't actually skipping it, it...
August 15, 2017 at 4:18 pm
I'm sure there are some free tools, but I recommend RedGate's SQL Compare for that task.
I used it when we were upgrading a system recently and found it...
August 15, 2017 at 11:12 am
My personal preference is to not fill the disk. Start the database out at a reasonable size.
Filling the disk means you may get a surprise one day when it...
August 14, 2017 at 4:41 pm
I think (but can't be sure without seeing the data) is that you'd want to add an extra clause to your WHERE in the nested selects. You would want to...
August 14, 2017 at 4:15 pm
To me, your solution sounds more like a workaround to me. Or did running that once fix the log growth issue?
I'm just thinking that to me, your solution...
August 14, 2017 at 10:58 am
Depending on how they need to share the data, you could have a new database per city.
likely not an ideal solution, but it is another option.
a new...
August 8, 2017 at 3:46 pm
Viewing 15 posts - 2,296 through 2,310 (of 2,857 total)