How to Delete Large Amounts of Data in Microsoft SQL Server
A short look at some of the options for deleting lots of data from a SQL Server table.
2024-10-07
7,595 reads
Articles
Introducing the PASS Data Community Summit Keynotes from Microsoft, Redgate, and a Community Star
After meeting the stellar pre-con speakers and exploring the 5 learning pathways at #PASSDataSummit 2024, we’re excited to reveal the keynote lineup. Each day will kick off with inspiring keynotes from Microsoft, Redgate, and a special community-driven session led by industry experts. Don’t miss out on these insightful sessions designed to energize and empower you throughout PASS Summit 2024.
2024-10-07
Uniqueness, Keys, and Identity
If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as the founding principle of all Western thought. It says that: “To be is to be something in particular; to be nothing in particular or anything in general, is to be nothing at all.”
2024-10-07
Display More Than 8000 Characters (SQL Spackle)
SQL Server MVP Jeff Moden shows us a quick and dirty bit of SQL Spackle to display the content of VARCHAR(MAX) and NVARCHAR(MAX).
2024-10-04 (first published: 2011-01-27)
24,324 reads
Storing and Retrieving the Initialization and Configuration Data for Applications
All developers hit the problem of how and where to store and set their configuration, profile, or initial data. A long time ago, it was generally decided that simple text files containing key/values were best, stored with the application. After all, you are relying on being able to entice busy people to get the permanent settings right for their requirements, folks who are generally not interested in your elegant computer science constructs. Not only that, but the settings must be parsed very quickly and efficiently, otherwise a process that uses the tool will slow to a crawl.
2024-10-04
Why customers love SQL Prompt
SQL Prompt has long been a customer favorite thanks to its ability to boost productivity. Discover how fellow database professionals are leveraging SQL Prompt to accelerate their coding speed and improve code quality.
2024-10-04
Exploring Time Travel and Row Level Concurrency: Data Engineering with Fabric
Learn how updates and concurrency can work in Fabric with Delta Parquet data.
2024-10-02
1,341 reads
Casino night is back at PASS Summit 2024!
Back by popular demand, casino night from SQL Server Central will return to PASS Summit this year. Casino night will take place on November 5 after the welcome reception. Tickets will be allocated at random via a lottery.
2024-10-02
Microsoft Fabric and PySpark: Coding tricks to improve your solutions
PySpark has some unconventional syntaxes which provide power to the development process, making it easier.
2024-10-02
Converting Old Running Total Code to Window Functions
This article looks at the old style of calculating a running total and how to convert that to code that uses a window function.
2024-09-30
2,592 reads
Blogs
T-SQL Tuesday #199 Invitation: Back to on-prem?
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
Error Deploying GraphQL in Fabric: dm_exec_describe_first_result_set
A while ago we suddenly had an error while trying to deploy one Fabric...
Forums
BCA KCU PLUIT | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit, Penjaringan, North Jakarta...
BCA KCU PANAKKUKANG | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi Selatan 90231...
Fuzzy String Matching in SQL Server 2025
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers