It’s all about the use cases
There is no better way to see the art of the possible with the cloud than in use cases/customer stories...
2018-03-05
323 reads
There is no better way to see the art of the possible with the cloud than in use cases/customer stories...
2018-03-05
323 reads
All the execution plans are estimated plans. All of them. There fundamentally isn’t any such thing as an “Actual” plan.
Where...
2018-03-14 (first published: 2018-03-05)
1,833 reads
My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases...
2018-03-05
304 reads
One of the joys of working with SQL Server is the descriptive and meaningful error messages, right?
https://vignette.wikia.nocookie.net/batmantheanimatedseries/images/a/a7/DiD_39_-_Joker_Vision.jpg/revision/latest?cb=20160610021326
Exhibit A - the 33206:
Error:...
2018-03-13 (first published: 2018-03-05)
16,982 reads
Determine Free Space In SQL Server DatabaseIn our previous section we have discussed about Using Stored Procedures in SQL Server For Better Performance and know various advantages of using...
2018-03-05
32 reads
Determine Free Space In SQL Server Database
In our previous section we have discussed about Using Stored Procedures in SQL Server...
2018-03-05
49,885 reads
Foreign key constraints put the “relation” into relational databases. They enforce integrity by requiring that a key value referencing another...
2018-03-05
483 reads
One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database. Pricing Azure SQL Database is different from traditional SQL...
2018-03-05
25 reads
One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database....
2018-03-05
636 reads
One of my friend sent an email with the requirement to load balance the traffic coming from application to secondary SQL Server replicas in always on availability group. Read-only...
2018-03-05
26 reads
As for me, I'll keep writing whenever time permits. I don't expect every post...
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...
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