Planning to Increase Cost Threshold for Parallelism – Like a Smart Person!
Planning to Increase Cost Threshold for Parallelism
When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s...
2018-02-27
1,167 reads
Planning to Increase Cost Threshold for Parallelism
When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s...
2018-02-27
1,167 reads
What are Orphaned Users
“Orphaned Users” is a common issue in SQL Server where a Database User is no longer associated...
2018-01-11 (first published: 2018-01-03)
24,514 reads
The @@SERVERNAME Global Variable
The system global variable @@SERVERNAMEcan be used to return the name of the machine the SQL Server...
2017-12-19 (first published: 2017-12-07)
4,838 reads
Join Eitan Blumin in the next video of his DocumentDB Tutorials. This time learn how to work with the documents...
2016-02-18 (first published: 2016-02-11)
2,098 reads
When I was about 7 years old and got my first computer during the early nineties,
I said “This is...
2016-01-31
854 reads
Performing a transaction log backup every 15 minutes has its advantages. But it also has disadvantages. Ever tried to restore...
2015-09-03 (first published: 2015-08-25)
2,587 reads
In my previous post in the series, I provided a short explanation on how to register your very first Azure...
2015-07-02 (first published: 2015-06-28)
2,265 reads
In my first post in the series, I provided a basic introduction to Microsoft’s new product: Azure DocumentDB, and how...
2015-06-22
860 reads
This is a basic introductory post about Microsoft’s new product: Azure DocumentDB, and how it compares to SQL Server.
What is...
2015-05-11
1,299 reads
Introduction
Many times I happen to find myself in a situation where, as a DBA, I need to write some long...
2014-08-11 (first published: 2014-08-04)
11,001 reads
The first version of my accounting assistant could not find a single purchase of...
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Too Many Choices
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
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