What we need are a clique of popular MVPs to start applying negative peer pressure.

"You're still using SQL Server 2000 and 2005??? Ew! Seriously.. dudes, that is like.....

Another issue is when a domain group (ie: MYCORP\ProductionDBA), which is a member of SYSADMIN sqlserver group, has a new domain member added. That doesn't trigger any event or meta...

I'm thinking about setting up a pre-production instance, perhaps just Express Edition, for which to smoke test deployment scripts prior to deployment on production. So the scripts go from UAT...

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...

mjh 45389 (2/11/2016)

---

Some years ago the company I was working for then brought in a new support manager whose experience was in engineering manufacture but not IT. He devised a...

Yes, back a few weeks ago, there was a similar post concerning slow initial connections for SSMS.

Is the same issue repeatable for both virtual and physical servers?

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...

Orlando Colamatteo (2/10/2016)

---

I think...

Hugo,

My script returns the duplicate listed below, but your's appears to return none.

MemNoYMDStart YMDEndYMDStart YMDEnd

417 2001-10-01...

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...

Is your SSIS package attempting to make connection to a...

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 !=...

Also, I would expect custid to be a foreign key as well.

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...