2021-03-25
1,014 reads
2021-03-25
1,014 reads
2009-02-02
4,549 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,924 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,407 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
266 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
385 reads
The script calculates the end and the beginning of the last, the current and the next months.
2002-04-01
982 reads
Logging is a necessity in the database world, well, the entire tech world. You...
By Rayis Imayev
(2025-July-06) Very often, real-time, high-speed streams of events come from IoT devices, social media...
By Steve Jones
It’s been a week since I flew home from London and Redgate to begin...
Comments posted to this topic are about the item The Mindset of a Database...
Comments posted to this topic are about the item Unmasking CXPACKET and CXCONSUMER in...
Hi everyone I have two db - one is test and other is archive. ...
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers