chrisn-585491 (12/29/2016)

---

On the flip side there's even more great open data sets to build analysis skills on. Everything from census to the stars, if you want some real data to...

2016 contained many epic watershed moments illustrating how the holy trinity of Social Media, Big Data, and Internet Enabled Consumer Devices are vulnerable to abuse. Overall, it was a very...

If the baseline for comparison is throwing one's laptop across the room in a fit of rage, then your solution is probably more like 10x faster. It would also be...

I've never heard it or asked it during an actual interview. Someone else on the team had suggested using it once for...

The following is an example of Lowell's suggestion about implementing a computed column (ie: NonSignedProductCode). You can then create an index on that column and use it for searching.

Whether...

The LEN() function returns the number of printable characters. It excludes trailing spaces, and for numeric and date columns it will count the number of characters in the default string...

David.Poole (12/27/2016)

---

The BBC used to reuse tapes because the media used to cost a fortune. Every now and again someone finds a copy of an ancient TV program hidden...

If you want to insure that your family photos are passed down forever to your grand children, then consider DNA digital data storage. It's a special gift that will always...

mcfarlandparkway (12/27/2016)

---

Hello,

how to write a query - to exclude the field that starts with ING

select * form table where...

Doctor Who 2 (12/27/2016)

---

Eric M Russell (12/27/2016)

---

Did you download it from a MSDN subscription or from Visual Studio Dev Essentials members?

I think there is a feature in the SQL Server...

Outside of an ETL staging environment, the routine usage of RegEx expressions would indicate something is amiss in the data model design or data quality.

I would import the records from the .csv file into a user table (not a temp table), and then create a primary key on DriverMD5 column. The other table, the...

Did you download it from a MSDN subscription or from Visual Studio Dev Essentials members?

I think there is a feature in the SQL Server installation called 'Edition Upgrade' where you...

Distributing tables vertically (ie: ServerA contains a subset of data for current year and ServerB contains archive data same tables) can be an effective scale-out solution (depending on the access...

Apps that pull data across VPN, like SSMS or SSIS, can be impacted by network latency.

One thing you can do is poll SYS.DM_OS_WAIT_STATS for network related wait states during...