This script creates a stored procedure to shrink the transaction log in the database it is created in. The stored procedure shrinks each transaction log file in the database, to the size specified.
2002-07-14
694 reads
This script kills all the processes using a given database. It is useful for removing users from a database so it can be restored.To use this script change the server variable and the database variable at the top of the script. Notifications are written to the windows application eventlog.Use this script at your own risk. […]
2002-07-12
1,126 reads
This script will list all columns, their datatypes, and sizes from any database. It can be very useful for contractor DBAs who need to quickly scan all tables, and very helpful for developers, or when you just need a quick list of fields for a meeting.
2002-07-12
1,329 reads
This script will do a full backup and transaction log backup of all the user database on the primary server and restore it over to the secondary server. The full backup/restore runs once every day and the transaction log backup/restore runs every minutes. Just provide the name of the primary and the secondary server and […]
2002-07-12
531 reads
Hello,Here is a (another one, but improved) stored procedure that returns rowcounts for all tables in the current database, or only for @tablename, if provided. Output can be ordered by name or by number of rows.Improvement : Rowcount is right aligned and formatted with thousand separator.To use it : - open a connection on your […]
2002-07-11
331 reads
Microsoft says that you cannot add an ORDER BY to a view unless it comes with a TOP clause at the beginning of the query. Many people think that if that's true then you cannot "Order" the whole query but only the top few. However, this is not true because when you use TOP 100 […]
2002-07-11
265 reads
Alternate method for generating a rowset with all of the numbers in a specified range.
2002-07-11
431 reads
Here's how to use the derived table technique to generate an automatic script for selecting all columns in a table:
2002-07-11
537 reads
This SELECT will give you a summarized report for the options selected for ALL the databases on your SQL Server. It's compatible with versions 7 and 2000.
2002-07-11
673 reads
Here's a script that will read a text file from the Windows system into SQL Server
2002-07-11
1,134 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers