Yet Another Deleting Duplicate Records (in-place)
Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.
2009-01-15 (first published: 2008-12-30)
1,909 reads
Pedro Sr
Synchronize the DB user SID with the Login SID
If you attach a DB on an SQL Server different from the SQL Server where the DB was initially created, you will usually come up with a situation where a login will be a DB user however, you cannot see this through the login properties screen. That happens because the name of the login exists […]
2005-04-21 (first published: 2005-04-02)
1,386 reads
Change the probability of the pseudo-random values
The usual practice, when we need some test data, is to employ the pseudo-random built-in function RAND(). We usually use it to produce a random value in some range and it produces these values with the same probabilities. Sometimes we need more "realistic" data when some values are more probable than others are. In this […]
2002-10-04
262 reads
Output all figures of the tables' usage
This store procedure outputs the tables' usage figures in a usable (I hope) format. If you create in the master database it will show the information for the database that it runs against.
2002-04-11
381 reads
Calculate End/Beginning of Last/Current/Next Month
The script calculates the end and the beginning of the last, the current and the next months.
2002-04-01
973 reads
Blogs
I like KQL and I like managing my test data – are they mates?
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
Full-Text Search in SQL Server: A Comprehensive Guide
By Rohit Garg
Introduction Full-Text Search in SQL Server is a feature that provides linguistic search capabilities...
Reading JSON Data with Python
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Forums
Subscription to Oracle DB not working after upgrading subscriber to Oracle 19c
Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...
Script to Merger duplicate indexes
Hello, I am trying to firgure out how to merge duplicate indexes using a...
using Openrowset to access delta files in ADLG2
Dears, I was told that I cannot access delta files in SQL Server Managed...
Question of the Day
The Query Traceflag
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers