How to delete a lot of data from a SQL Server database
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,...
The...
2019-05-15
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,...
The...
2019-05-15
Solomon Rutzky dives into how big a table value constructor can be in terms of rows: On 2019-05-08, a helpful individual, Michael B, commented on my answer saying that the...
2019-05-14
Let’s assume that you have lots of tables that need to be dropped according to some...
2019-05-13
Introduction This tutorial includes information about SQL (DDL, DML) that I have gathered during my professional life. This is the minimum you need to know while working with databases....
2019-05-12
What is the maximum number of rows for the Table Value Constructor? And, do different uses of it behave differently?… Continue reading Maximum Number of Rows for the Table...
The...
2019-05-09
2019-05-09
1,221 reads
Itzik Ben-Gan resumes his blog series on T-SQL bugs, pitfalls, and best practices, treating an issue with correlated column references in subqueries.
The post T-SQL bugs, pitfalls and best practices...
2019-05-08
Watch this week’s episode on YouTube. SQL Server Spool operators are a mixed bag. On one hand, they can negatively impact performance when writing data to disk in tempdb....
The...
2019-05-07
A few years back I started running regular SQL workshops in my workplace. Teaching beginners the basics of querying databases with SQL, as well as more advanced topics for...
The...
2019-05-07
Starting with SQL Server 2016, Microsoft provided a STRING_SPLIT function. It is a table-valued function that splits a string into rows of substrings, based on a specified separator character....
2019-05-07
We value your privacy. This policy explains what personal data we collect and why. What...
This came up one day at my work when a developer was using it....
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
I spotted this in the release notes for CU17 in SQL Server 2022: KB3616559...
I migrated DB server from 2017 enterprise to 2019 enterprise. After the migration, every...
Comments posted to this topic are about the item How Much AI Code Would...
I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?
See possible answers