SQL Server returns numeric values always in a internal format. The conversion of numeric values into a language specific format is usually part of the client. With this User Defined Function, you can do thison your backend. The function expects 3 parameters: The numeric value, the requested language and the number of decimals (will be […]
2004-07-13 (first published: 2004-07-02)
369 reads
Do you ever need to look for a given user's permissions for security reasons or move the permissions for that user from test environment to production? This is a script, which will generate print statements, which can be use to view/grant, the permissions of all dbo objects, which the given user has, which is not […]
2004-07-08 (first published: 2004-01-16)
895 reads
My first stab at a script, I have a dev server will 60 + db'sI wanted to db size + log size in a more centralised location.
2004-07-07 (first published: 2004-01-09)
717 reads
This script will generate and populate a table variable with a stipulated number of unique 8 randomly generated character alphanumeric values. This can be useful in situations where one has to allocate passwords or unique id to users. It accepts one input parameter "@HowMany int" representing the number of these alphanumeric values to generate; default=500.Usage: […]
2004-07-06 (first published: 2004-01-09)
3,533 reads
Many DBA's have a Maintenance plan running that creates a backup every night and a transaction log backup every hour.Restoring them to another server (for whatever reason) can be a tedious job. That is why I wrote this T-SQL script.It will read the contents of a backup directory created by the maintenance plan and create […]
2004-06-25
926 reads
This script will allow you to find all instances of a column name, or partial column name, in all user tables in the database in which it is run. This is sometimes helpful during upgrades, etc. There is no error checking in this script. You can modify it to add, if needed.Run this by simply […]
2004-06-21
207 reads
This script will help in removing the duplicate values from a table.
2004-06-15
327 reads
This SP gets all the table names with the column names and data types, datalength. All the existing constrains on the table and column levels along with the Primary and foreign keys and table references
2004-06-01
263 reads
Captures all SQL Logins at the server level with password and spid unchanged into a sql script. Nothing fancy just needed it to do a server move and load into QA.
2004-05-25
2,080 reads
If we give SP_HELP , we'll know to which File Group the table belongs.If we give SP_HELPFILEGROUP , we'll know the logical and physical file names along with other information that belong to the given File Group. But have you ever tried that, given a file group, how to find all the tables that belong […]
2004-05-10
148 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers