Viewing 15 posts - 151 through 165 (of 1,079 total)
consider changing is_deceased NVARCHAR(2) NOT NULL to bit, and use a 1 and 0 instead.
where do you mention deceased date?
what's the purpose of "row is current", row start...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 7, 2017 at 2:39 pm
what exactly did you backup and restore?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2017 at 4:06 pm
Always ask yourself, how many people do I need to transport how far, with how much fuel, in a 1 cylinder vehicle.
If your expectations are realistic, as well as...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 3, 2017 at 8:12 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 3, 2017 at 6:54 am
Set it up using the name of the actual instance, and afterwards redirect the publisher to the AG Listener Name.
This should guide you: https://msdn.microsoft.com/en-us/library/hh710046.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 2, 2017 at 1:53 pm
You've checked everything, except network traffic and response.
I generally see the same issue when connecting from continent to another, then there's a delay in object explorer visual response.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 2, 2017 at 10:22 am
SSMS version on your workstation is pre-2012 is my guess.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 1, 2017 at 12:54 pm
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 28, 2017 at 12:01 pm
You'll save yourself and future-you a lot of headache by developing an analysis cube and reporting from it rather.
It should be faster, sleeker and less admin-overhead than dividing into...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 28, 2017 at 10:20 am
SELECT DATEADD(month, DATEDIFF(month, 0, getdate()), 0) AS StartOfMonth
Is this what you require?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 28, 2017 at 7:54 am
Your Loop will perform the required read/operation then delete the folder, you'll need to encapsulate foreach file into a foreach folder.
http://microsoft-ssis.blogspot.com/2011/01/foreach-folder-enumerator.html
Perfecting your variables will be crucial.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 28, 2017 at 7:53 am
quite difficult since we don't know what you have developed so far, but here is a good starting point on For loops when working with files.
https://www.simple-talk.com/sql/ssis/ssis-basics-introducing-the-foreach-loop-container/
Are...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 28, 2017 at 7:42 am
Are you using SSIS tasks or batch scripts?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 28, 2017 at 7:35 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 28, 2017 at 7:26 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 27, 2017 at 4:51 pm
Viewing 15 posts - 151 through 165 (of 1,079 total)