Efficient Table Migration to a New Schema in T-SQL
This article will explain why and how you can easily move tables to new schemas if the need arisees.
2024-10-31 (first published: 2023-11-03)
3,747 reads
Parthprajapati
- Interests: writing, SQL
An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page Allocation
Learn about the benefits of mixed extent allocation in SQL Server 2016, along with how you can check this setting or enable it in your database.
2024-01-10
1,958 reads
Understanding Maximum Server Memory in SQL SERVER
This short piece explains the value of maximum server memory and shows you how to change this.
2023-12-27
5,717 reads
What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples
Learn how to use CTEs through the use of a number of examples.
2023-10-20
10,464 reads
How to Move a Table into a Schema in T-SQL
To move a table into a schema in T-SQL, you can use the ALTER SCHEMA statement along with the TRANSFER option. Here are the steps to do this: Assuming you have an existing schema named "NewSchema" and a table named "YourTable" that you want to move into this schema: Open SQL Server Management Studio or […]
2023-09-29 (first published: 2023-09-18)
5,510 reads
How to Use SQL to Analyze the Bitcoin Blockchain
You will learn how a blockchain works and then use a SQL database to analyze data from a series of transactions.
2023-09-08
5,086 reads
2023-08-18
10,469 reads
Unlock the Power of Google Cloud SQL: Setting Up SQL Server and PostgreSQL Instances
Learn how to get started with Google Cloud MySQL and PostgreSQL databases by creating and configuring a database.
2023-05-26
1,012 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA BALAI KOTA KARIMUN TLP/WA 081717899866
Jl. Teuku Umar No.19, Tj. Balai Karimun, Kec. Karimun, Kabupaten Karimun, Kepulauan Riau 29661
BCA Multifinance Cabang Kedoya Telpn/wa (08218171891)
Telpn/wa (08218171891) Citta Graha, Jl. Panjang, RT.5/RW.1, South Kedoya, Kebonjeruk, West Jakarta City, Jakarta...
BCA KCP KARIMUN TLP/WA 081717899866
Jl. Jenderal Ahmad Yani Barat No.A7-A8, Sungai Lakam, Kec. Karimun, Kabupaten Karimun, Kepulauan Riau...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers