Getting results using less T-SQL
There is usually more than one way to write a query. In this article, Edward Pollack explains a few ways to write simpler T-SQL code.
2022-05-23
There is usually more than one way to write a query. In this article, Edward Pollack explains a few ways to write simpler T-SQL code.
2022-05-23
2022-05-20 (first published: 2019-02-05)
3,170 reads
Successfully implanting change in an organization requires buy-in from leadership. Rohan Kapoor explains what’s needed to get leadership alignment.
2022-05-20
How to integrate Flyway database development with Source control, so that you can track what changes were made and who made them as well as which objects changed between versions, and how.
2022-05-20
It's an oldie but a goodie: Redgate Advocate Grant Fritchey takes us through how best to manage hybrid estates. Read on to find his expert recommendations.
2022-05-18
SQL Server has many features to keep the database secure, but you must implement them to benefit. In this article, Priyanka Chouhan describes how to do a vulnerability assessment of SQL Server.
2022-05-18
2022-05-16
10,644 reads
Indexes are critical for database performance. In this article, Lukas Vieikis explains the many types of indexes available with MySQL.
2022-05-16
Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover what we mean by Database DevOps, why you need to include the database in your DevOps initiative and the benefits its offer you, your teams, and your organization.
2022-05-16
Learn about using the Script activity in Azure Data Factory to run DDL or DML statements.
2022-05-13
20,026 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers