Procedure to Create New Filegroups and Files
Problem
For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial...
2018-04-03
68 reads
Problem
For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial...
2018-04-03
68 reads
Problem
For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial...
2018-04-03
305 reads
Why Projects Fail...Free Session, Free Beer and Free Food
Mark Williams and myself will delivering a seminar called #Not the GDPR news in...
2018-04-03
327 reads
After demo building and testing features out within Azure SQL Database I like to delete the databases to save costs....
2018-04-03
379 reads
I woke up early on Tuesday with a hundred things to do and plenty of energy to match my task list. By noon, I’d made a loaf of bread,...
2018-04-03
60 reads
Watch this week’s episode on YouTube.
In this week’s video with Power BI expert Eugene Meidinger, we’re in the kitchen learning...
2018-04-10 (first published: 2018-04-03)
2,044 reads
Watch this week's video on YouTube
In this week's video with Power BI expert Eugene Meidinger, we're in the kitchen learning about Power BI.
Power BI has two languages available for...
2018-04-03
26 reads
Watch this week's video on YouTube
In this week's video with Power BI expert Eugene Meidinger, we're in the kitchen learning about Power BI.
Power BI has two languages available for...
2018-04-03
15 reads
(last updated: 2018-04-09)
In answering a recent question on DBA.StackExchange related to why some characters work for parameter names and others...
2018-04-03
592 reads
This post talks about having primary replica jobs. That is, jobs that will only run on the primary replica of...
2018-04-02
1,043 reads
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
The first version of my accounting assistant could not find a single purchase of...
Comments posted to this topic are about the item Pay for Performance, which is...
Hi I have this slow query that is pulling data from a linked server....
Comments posted to this topic are about the item Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers