If we eliminate cows as a source for green-house gas emissions then next up will be human produced gas emissions... particularly that of west coast vegetarians.

Will Vegetarian Humans...

Whatever user requested to see the data pivoted into this cross-tab format should do it themselves within the reporting tool.

Create a Matrix (Report Builder and SSRS)

https://msdn.microsoft.com/en-us/library/dd207149.aspx

Office Excel 2010 Tutorial: Pivot...

What you've described is a terrible application for a traditional Row-Store / B-tree indexed table, but a ColumnStore index can help mitigate this type of dynamic access pattern. If this...

I often use a datetime stamp as the leading column in a clustered and/or primary key. Many types of entities are naturally unique within the context of time, and also...

Brad Allison (11/30/2016)

---

This topic is very timely and interesting as just yesterday I heard that the Breitbart company now wants to capitalize on working with data within the White House...

David.Poole (11/28/2016)

---

What puzzles me is that developers aren't much better at data modelling. Surely you have to be pretty good to come up with a decent object model in...

I'm thinking that Thanksgiving is a British holiday inherited by the US, since Jamestown and Plymouth were British colonies at the time the first Thanksgiving was celebrated.

One day we'll have a device that can scan a person's DNA and produce a unique and repeatable 16 byte hash code. No name, social security number, date of birth,...

web designers building databases...

interns defining business requirements...

database administrators interfacing with clients...

executive management playing golf ...

everybody supervising themselves...

These folks who think their T-SQL snippets constitute an "original" work are self-deluded.

Byte me!

-- (c)2016 Eric Russell - All Rights Reserved

SELECT GETDATE()

If the above advice doesn't work, then close SSMS, right click on SSMS shortcut, and then choose "Run as Administrator".

Idera has a collection of free tools, one of which is an Extended Event Profiler. I havn't gotten around to using it yet, but it sounds like what you're looking...

I just started a SQL Profiler trace on my (local) instance and then did the "New Database.." dialog. There are quite a few things that SSMS does in the background,...

Just recently, the Standard edition of SQL Server 2016 SP1 is inheriting most (or maybe all?) of the Enterprise edition features it has traditionally excluded. Hopefully, backup encryption is feature...

When users create a new database, are they specifying a non-default file location or growth size?