2021-03-25
1,016 reads
2021-03-25
1,016 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,409 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
983 reads
By Daniel Janik
Boost Your Azure Fabric Pipelines: Don’t Overlook This Crucial Spark Setting Are your Azure...
By Kevin3NF
The SQL Server installer has gotten better: tempdb configuration, MAXDOP, and even max memory...
By Rohit Garg
In the fast-paced world of IT, Database Administrators (DBAs) are the unsung heroes who ensure that...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Monitor SQL Server using Zabbix
Hi We have databases with data stored for over 20 years, this is required...
You're troubleshooting a connectivity issue between a client application and a remote SQL Server instance. The client receives a "provider: TCP Provider, error: 0 - No such host is known" message. You verify that SQL Server is running and reachable on the server. The SQL Server instance is configured with a named instance and uses dynamic ports. Which of the following steps is most likely to resolve the issue?
See possible answers