Hi folks,
I would like to see an enumerated list data type. It is a simple concept and MySQL has it.
(https://dev.mysql.com/doc/refman/5.7/en/enum.html)
Say you have a column to store...

Thanks Ted, Works great for a single row use.

Thanks to all for commenting and contributing ideas. I think it was many moons ago when I first used this technique. In doing a small scale test of a little...

Thanks for pointing that out TerryCatt. Yes, you can use one or the other (Sparse or Compression), but not both.

Also, for SQL 2014, data compression is not supported for In-Memory...

I don't have any performance benchmarks yet. I am likely months from getting this into a deployment.

But since MSFT claims there is no overhead on NULL and only slight on...

Hi Guys,

Thanks for your replies!

I do find articles like http://sqlmag.com/database-performance-tuning/practical-data-compression-sql-server that indicate in addition to storage savings, you may see a performance improvement. Which actually makes sense if...

It was a simple typo. 

The td. should be hd.  

Thanks for all who helped!  

Here is the full procedure:

IF OBJECT_ID('ss_HelpDetails_PostUpdates') IS NOT NULL

 DROP PROCEDURE dbo.ss_HelpDetails_PostUpdates

go

-- exec ss_HelpDetails_PostUpdates

CREATE    PROCEDURE  dbo.ss_HelpDetails_PostUpdates

AS

-- Copyright (c)

BEGIN

SET NOCOUNT ON

DECLARE @RunTime datetime

select @RunTime = getdate()

update HelpDetails

 set CreatedAt = s.CreatedAt,

  Spreading = s.Spreading,

  Damage = s.Damage,

  VirusType = s.VirusType,...

I changed the command to this:

update hdtd

 set hdtd.TechnicalDescription = stg.TechnicalDescription

 from stg_HelpDetailsTechDesc stg

 left join HelpDetails hd on stg.EventName = hd.title

 left join HelpDetailsTechDesc hdtd on hdtd.HelpDetailsID = td.HelpDetailsID and

   hd.HelpTypeID = hdtd.HelpTypeID

And...

I changed to this:

update hdtd

 set hdtd.TechnicalDescription = stg.TechnicalDescription

 from stg_HelpDetailsTechDesc stg

 Left join HelpDetails hd on stg.EventName = hd.title

 left join HelpDetailsTechDesc hdtd on hdtd.HelpDetailsID = td.HelpDetailsID

 where   hd.HelpTypeID = hdtd.HelpTypeID and   hd.HelpTypeID...

Lucky,

I tried your suggestion and still get the same error message.

Thanks ......... reiny

Awesome!          

Another question, I also want to access the data in the AgentParameters level.  I am trying this, but getting multiple rows of null values.  Is there a way to get...

Thanks a ton Ray. I don't work with XML much, so I didn't know what might be tripping it up.  Since I don't need that piece of information, I can...

As I suspected, a real bug.

Does anyone have a support agreement with MS to see if they have a patched SQLDiag available?

We have...