There's a quick 'n' dirty way of doing this which resembles the technique used by Des, whose set-up script I have copied (thanks!):

IF OBJECT_ID('tempdb..#Required', 'U') IS NOT NULL

...

It's required...

There is no 32-bit version. You need a 64-bit system to install SQL Server 2016. Check the system requirements page.

pavan.msbi558 (9/30/2016)

---

Hi All,

when i trying to install sql server 2016.iso file i am getting below error . Please give me solution for this issue

sql server media is not supported on...

quinn.jay (9/30/2016)

---

John Rowan (9/30/2016)

---

All you need are the .dtsx files. If you need to open them in a solution for editing, create a new project in Visual Studios, start...

PiMané (9/30/2016)

---

Hi,

I've a table with 1.000.000 rows where active records and inactive records are kept, since the user can search on both status (only 5% or less of the time...

quinn.jay (9/29/2016)

---

John Rowan (9/29/2016)

---

The solution files are only needed for development. Once you've built the package into it's .dtsx file, the solution is really not needed. Your job...

Here's a slightly different version:

DECLARE @DOB DATE = '20000101';

DECLARE @AgeYears TINYINT = DATEDIFF(YEAR, @DOB, GETDATE());

SELECT Age = (CASE WHEN @AgeYears <= 13 THEN 'Age less than 14'

...

If you right-click on a project in SSISDB, and select 'Versions' you will see a list of previously deployed project versions (the maximum number of versions displayed will depend on...

Just got a spam e-mail that starts with this:

"I am the only Daughter of my late parents Mr and Mrs Nelson Smith. My father was a highly reputable business magnet...

Re1 (9/29/2016)

---

Hi,

I am facing an issue with CozyRoc Table difference. It is passing Unchanged rows (same in both old and new) records into Updated rows (appear in both old...

See link.

I'm interested. Can you explain why, please, in a bit more...

GilaMonster (9/28/2016)

---

You have the latest SSMS...

GilaMonster (9/28/2016)

---

It does (try it, you'll end up with @@TRancount of 1), because of deferred compile.

When the batch is parsed, the...