Measuring Query Execution Time: What Is Most Accurate
Probably the single most important factor when deciding which query to tune, or actively tuning a query, is how you...
2018-08-28 (first published: 2018-08-13)
2,749 reads
Employee Agreements & Contracts: Anti-Patterns (31 minute video)
When you take a new job in software engineering or in IT, within the paperwork there often lurks an employee agreement: a contract between you and your employer. In...
2018-08-13
29 reads
The New SQL Provision Dashboard
As much as I liked the ability to quickly and easily build development and test databases with SQL Provision, I...
2018-08-31 (first published: 2018-08-13)
2,639 reads
Top 5 Reasons You Should Be Excited About Power BI Composite Models
In July there were many exciting new features that were released to Power BI, but perhaps the most eagerly awaited...
2018-08-28 (first published: 2018-08-13)
3,017 reads
Fastest Way to Find Row Count of All Tables From All Databases in SQL Server
There are many times you as DBA or Developer needs to get all row count from all tables or row...
2018-08-13
8,299 reads
Warning: Expect Delays
Imagine you are driving somewhere – to work, to the mall, wherever – and you encounter a massive traffic jam. Wall-to-wall, bumper-to-bumper,...
2018-08-24 (first published: 2018-08-12)
2,042 reads
SQLSaturday Baton Rouge thank yous
Hello everyone who was at #SQLSatBR this year!We had a huge early morning wave of attendees this morning that inundated our sponsors just like a cooling rain inundated us in...
2018-08-12
15 reads
Database Protection in the Cloud Era
The Cloud is a fun and exciting place to be. Exciting as it may be, even in the cloud, protection...
2018-08-10
300 reads
Money Ball: Fantasy Football Kicks Off Tonight - Jeff's Degenerates
You might think that this blog post is out of place here but I'm hoping use some of the data...
2018-08-10
312 reads
Taking the Linux plunge – Update
It’s been a couple of weeks now since I took the plunge and bought myself a Dell XPS 13 running...
2018-08-10
312 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
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