Why use a Date Dimension Table in a Data Warehouse
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you...
2016-06-06 (first published: 2016-05-29)
7,112 reads
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you...
2016-06-06 (first published: 2016-05-29)
7,112 reads
SQLSaturday events are a pleasure to be a part of whether it involves speaking or volunteering. Volunteering definitely takes more...
2016-04-23
634 reads
Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice...
2016-03-16
566 reads
Next Meeting
Thu, Mar 24 2016 12:00 Central Daylight Time
Dustin Ryan presents What's New in Power BI
RSVP:https://attendee.gotowebinar.com/register/8425155555275941377
WHAT'S NEW IN POWERBI...
2016-03-16
537 reads
I will be speaking with other SQL Server experts for SQLSaturday #461 in Austin on Jan 30th, 2016. This is...
2016-01-18
469 reads
Microsoft continues to improve indexes and options for additional performance enhancements. One I see frequently is the need for a...
2015-12-03 (first published: 2015-11-26)
3,286 reads
Please join Idera tomorrow for a #SQLChat on Twitter. The December #SQLChat will take place Tuesday, December 9 at 11...
2015-12-02
497 reads
I started using a product called SQL Diagnostic Manager from Idera about 10 years ago at a Home Health company....
2015-11-05
499 reads
Yes, it is that time of the year again. You know, when all the nut case and normal SQL Server...
2015-10-19
510 reads
On Wednesday morning, Conner Cunningham from Microsoft was the keynote speaker for IT/DevConnections in Las Vegas. His talk focused on...
2015-09-17
412 reads
By Steve Jones
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into...
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Building a RESTful API with...
Comments posted to this topic are about the item The Journey to PostgreSQL (or...
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers