Viewing 15 posts - 2,866 through 2,880 (of 6,035 total)
It seems you're just getting started as a DBA administering SSIS and already looking for general advice on how best to approach it. So, that's good. At this point maybe...
February 11, 2016 at 2:19 pm
mjh 45389 (2/11/2016)
February 11, 2016 at 12:11 pm
Yes, back a few weeks ago, there was a similar post concerning slow initial connections for SSMS.
February 11, 2016 at 11:55 am
Is the same issue repeatable for both virtual and physical servers?
February 11, 2016 at 9:54 am
They ten years was their estimate to replace the entire system. It shouldn't take even one year just to upgrade their network and patch security holes. Typical of most government...
February 11, 2016 at 7:15 am
Orlando Colamatteo (2/10/2016)
Hugo Kornelis (2/10/2016)
True. And one might debate whether or not an interval that ends before it even starts is able to overlap with other intervals or not.
I think...
February 11, 2016 at 7:06 am
Hugo,
My script returns the duplicate listed below, but your's appears to return none.
MemNoYMDStart YMDEndYMDStart YMDEnd
417 2001-10-01...
February 10, 2016 at 1:21 pm
Install the free tool SQL Sentry Plan Explorer. Also, to further trick out your SSMS, while you've got the hood up, add your DBA scripts collection to the 'Code Snippets...
February 10, 2016 at 1:12 pm
Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Named Pipes Provider: Could not open a connection to SQL Server [2]. ".
Is your SSIS package attempting to make connection to a...
February 10, 2016 at 12:16 pm
This will give you what you want.
SELECT A.MemNo
FROM zzz_Overlapping A
JOIN zzz_Overlapping B
ON B.MemNo = A.MemNo
AND ((A.YMDStart BETWEEN B.YMDStart AND B.YMDEnd)
OR (A.YMDEnd BETWEEN B.YMDStart AND B.YMDEnd))
WHERE B.YMDStart !=...
February 10, 2016 at 11:32 am
Also, I would expect custid to be a foreign key as well.
February 10, 2016 at 10:39 am
There is no need to index foreign keys by default. So long as employees(empid) is indexed, which it should be since the empid column is the primary key of employees...
February 10, 2016 at 10:38 am
I'm assuming the goal here is to consolidate multiple OLTP databases into one OLTP database, and each existing line of business application will (at least for now) continue it's own...
February 10, 2016 at 7:22 am
Matt Miller (#4) (2/9/2016)
Eric M Russell (2/9/2016)
...That's scary, though potentially not a problem. A number of states publish voter data as public records. A few might have restrictions on the...
February 10, 2016 at 6:53 am
David.Poole (2/9/2016)
Data is like fissile material. Once it gains critical mass it's...
February 9, 2016 at 1:47 pm
Viewing 15 posts - 2,866 through 2,880 (of 6,035 total)