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,908 reads
Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.
2009-01-15 (first published: 2008-12-30)
1,908 reads
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,383 reads
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
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
The script calculates the end and the beginning of the last, the current and the next months.
2002-04-01
973 reads
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
I have a PowerShell script that I use to automate the backup of Analysis...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers