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

We also use PSExec using either Execute Process task or a WScript. However, I would suggest avoiding any workflow that involves running remote processes, because it's a weak point of...

The best tool for creating tables from a logical model is an experiened database developer who knows what a clustered index and foreign key are and how to use them....

When deleting or updating a set of rows based on IDs derived from other related tables, it can be helpful, for both performance and readability reasons, to first select the...