Phil Parkin (1/11/2016)

---

ROWVERSION (aka TIMESTAMP) is not ANSI standard, so it's implemented differently on each RDMS, but each has a similar concept. For...

You probably already know this, and you didn't specifically mention SCD or if this is a MERGE versus straight INSERT into Destination, but avoid using the SSIS Slowly Changing Dimension...

Once you gain experience with one .NET language, learn the framework and GUI, it's earier to learn another .NET language. For example, a C# developer probably could ramp up on...

rahulsahay123 (1/8/2016)

---

I am getting a data feed with date column of type integer.Format is mmddyyyy.

Values are like : 01092015

Now i want to convert this into yyyy-mm-dd ...

... I ran across a piece that referenced a slightly shorter rule, the 100 hour rule. The rule is fairly simple: "for most disciplines, it only takes one hundred hours...

This smells like healthcare claims data. If so, then "userpolicyid" is something like PayerID + SubscriberID + DependentID, and the format is not coded consistently between external sources. That's the...

Could contain? One thing you could do is add a non-persisted computed column, index that, and then use...

That's OK;...

Alvin Ramard (1/8/2016)

---

Jeff Moden (1/8/2016)

---

I especially hate it when a Developer that doesn't know, creates tables using Visual Studio or has VS auto-magically create the tables from objects because almost...

This type of behaviour would be situation normal for a Java app, but not for a Windows executable. Using SysInternals Process Explorer, see what SSMS.EXE is doing during the several...

Having the package property IsolationLevel set to 'ReadUncommitted' while selecting from a volatile table, or setting (NOLOCK) hint in the DataFlow source SELECT statement?

null

Matt Miller (#4) (1/8/2016)

---

Eric M Russell (1/7/2016)

---

... I saw was of a press conference where the upper management of VW seems to indicate that the software developers on the project...

After successfully logging in, check the SQL Server Logs for any out of the ordinary events ocurring around the same time as your initial slow login. Also, consider using SQL...

Two common and simple patterns for inserting rows into TableA from TableB where the rows don't already exist in TableA.

INSERT INTO TableA ( id, a, b, c )

SELECT id, a,...