Database Engineering: Database Modelling: Do I need to have an incrementing identity int/bigint as my clustered index in a SQL Server database? When you want to produce a professional...
2019-06-03
4 reads
If you have a PIVOT query and it isn’t returning the data you expect, what can you do to troubleshoot it? The thing to do is to break it...
2019-05-21
17 reads
If you have a PIVOT query and it isn't returning the data you expect, what can you do to troubleshoot it? The thing to do is to break it...
2019-05-21
2 reads
How to delete data efficiently When we delete data from a table in SQL Server, we can often find that the delete is slower than even the original insert,...
2019-05-15
331 reads
How to delete data efficiently When we delete data from a table in SQL Server, we can often find that the delete is slower than even the original insert,...
2019-05-15
2 reads
How do you know whether a database code change is going to be great, okay or awful? If you want to test a new version of SQL Server how...
2019-05-08
287 reads
How do you know whether a database code change is going to be great, okay or awful? If you want to test a new version of SQL Server how...
2019-05-08
6 reads
Reading Time: 5 minutes (just do it!)
There is a lot of confusion when it comes to designing tables in SQL Server around whether to pluralize names or not. How...
2019-05-02
14 reads
Reading Time: 5 minutes (just do it!)
There is a lot of confusion when it comes to designing tables in SQL Server around whether to pluralize names or not. How...
2019-05-02
1 reads
Reading Time: 15 minutes (it is quite hard going, but you need to know this if you need to work with the DacFx)
DacFx - Getting the data type of...
2019-04-17
27 reads
With all the changes that have happened with VMware since the Broadcom acquisition I...
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Hello, I am working with a company on their database administration. I am trying...
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers