Max Worker Threads for SQL Server Always on Availability Group databases
July 26, 2019This article gives an overview of the Max Worker Threads for the SQL Server Always On Availability Group databases.
Search Results for: INSERT
Comparing VARCHAR(max) vs VARCHAR(n) data types in SQL Server
July 26, 2019I have seen that SQL developers use varchar(max) data while designing the tables or temporary tables. We might not be sure about the data length, or we want to eliminate the string or binary truncation error.
Configuring email notifications in Azure SQL database
July 24, 2019In this article, we will review how to configure email notifications in the Azure SQL single database or elastic pool.
Understanding Log Sequence Numbers for SQL Server Transaction Log Backups and Full Backups
July 22, 2019This article explores the SQL Server Transaction log backups and log sequence number (LSN) in combination with the Full backups.
SQL Server Lead function overview and examples
July 16, 2019This article explores the SQL Server Lead function and its usage with various examples.
SQL DROP TABLE statement overview
July 16, 2019This article gives an overview of the SQL DROP TABLE statement to remove one or more tables from a database.
Understanding the SQL Decimal data type
July 15, 2019This article aims to walk you through the SQL Decimal data type and its usage with various examples. We will also see how we can exercise this data type in SQL Server to help make SQL developer’s job easier.
Memory-Optimized TempDB Metadata in SQL Server 2019
July 10, 2019Introduction In-memory technologies are one of the greatest ways to improve performance and combat contention in computing today. By removing disk-based storage and the challenge of copying data in and out of memory, query speeds in SQL Server can be improved by orders of magnitude.
Difference between SQL Truncate and SQL Delete statements in SQL Server
July 8, 2019We get the requirement to remove the data from the relational SQL table. We can use both SQL Delete and SQL Truncate statement to delete the data. Understanding differences between these commands helps SQL developers to handle their data well. Additionally, this is a very common question asked in SQL beginner’s interviews.
Azure SQL Data Sync – Replicate data and schema changes between Azure SQL databases
July 5, 2019In this article, we will review how to configure the sync group to replicate data between Azure SQL databases using Azure SQL Data Sync.
Overview of SQL RANK functions
July 3, 2019We perform calculations on data using various aggregated functions such as Max, Min, and AVG. We get a single output row using these functions. SQL Sever provides SQL RANK functions to specify rank for individual fields as per the categorizations. It returns an aggregated value for each participating row. SQL RANK functions also knows as […]
DELETE CASCADE and UPDATE CASCADE in SQL Server foreign key
July 3, 2019In this article, we will review on DELETE CASCADE AND UPDATE CASCADE rules in SQL Server foreign key with different examples.
SQL Server training
July 2, 2019This one-stop SQL page is a complete tutorial for both beginners and advanced SQL users to help them learn and enhance their SQL Server skills. SQL Server Basics This is an index of links that organize and catalog basic topics in SQL Server like a particular operation or data type. The topic categories include DDL […]
Optimizing SQL Server index strategies
July 2, 2019Index strategies overview This article is about techniques for optimizing the SQL Server indexes strategy. It is an appendix of the SQL index overview and strategy article in which I covered different areas like what indexes actually do, how to create them, and I briefly mentioned some index design guidelines. Furthermore, I also presented an […]
SQL View – A complete introduction and walk-through
July 1, 2019In relational databases, data is structured using various database objects like tables, stored procedure, views, clusters etc. This article aims to walk you through ‘SQL VIEW’ – one of the widely-used database objects in SQL Server.
Understanding the SQL Server CASE statement
June 28, 2019SQL Server CASE statement is equivalent to the IF-THEN statement in Excel.
Data Manipulation Language (DML)
June 27, 2019In this page, we will explore the useful Data Manipulation Language (DML) commands such as Insert, Update along with examples. Add Column SQL Add Column operations Aggregate Functions How to use Window functions in SQL Server ALL AND ANY SQL Server universal comparison quantified predicates (ANY, ALL, SOME) Approx_Count_Distinct The new SQL Server 2019 function […]
Overview of the SQL Count Distinct Function
June 26, 2019This article explores SQL Count Distinct operator for eliminating the duplicate rows in the result set.
Get details of SQL Server Database Growth and Shrink Events
June 25, 2019It is essential for the DBA to need to ensure the SQL Server database performance. Performance tuning is an open-ended task, and you need to ensure the monitoring of various database parameters.
Clustered Index vs. Heap in SQL Server
June 21, 2019Summary There are few topics so widely misunderstood and that generates such frequent bad advice as that of the decision of how to index a table. Specifically, the decision to use a heap over a clustered index is one where misinformation spreads quite frequently.
A step-by-step walkthrough of SQL Inner Join
June 21, 2019Organizations are generating and analyzing unmatched volumes of data with each passing minute. In this article, we will demonstrate how we can employ SQL Inner Join to query and access data from multiple tables that store this incessantly growing data in the SQL databases.
EXEC SQL overview and examples
June 18, 2019In this article, we will review on EXEC SQL statement in SQL Server and explore a few examples.
Isolation levels behavior in SQL Server Always On Availability Groups
June 18, 2019In my previous article, Data synchronization in SQL Server Always On Availability Groups, we explored the internal data synchronization for both Asynchronous and Synchronous data commit mode. In the following image, on the secondary replica, we can see two important processes.
Vulnerability Assessment and Advanced Threat Protection in Azure SQL Database
June 17, 2019In today’s time where data breaches are highly expected to happen, there is a high need to ensure sensitive data in the Azure SQL databases is secured and which is why data security implementation is gaining momentum across each community. We covered one of the features of Advanced Data Security here in Advanced Data Security […]
Three Standard SQL Unit Tests you can write against any Stored Procedure
June 14, 2019This article talks about the three standard SQL unit tests which can be written against any stored procedure ultimately becoming SQL unit testing object to meet internal or external business specification.