This uses info in backup tables to display growth of datafiles (LDF and MDF) and actual datagrowth (backupsize) over a period of time. Replace parameter values with name of your database and date from when you want info displayed. Results are best viewed in grid.
2003-08-20
404 reads
This function takes a pattern to be searched for, a string that the pattern will be removed from and a flag to determine whether all instances of the pattern should be removed.This is sort of an expanded version of a function I wrote to remove multiple spaces from a string.
2003-08-20
189 reads
SQL 2000's sp_MSForEachDB and sp_MSForEachTable are useful procedures for performing operations against multiple objects; however, they aren't always extremely efficient, because internally they use cursors to do their work.These 2 sprocs, sp_ForEachDB and sp_ForEachTable, perform many of the same tasks as their Microsoft-shipped twins, but run faster because they dynamically build the SQL string without […]
2003-08-19
2,289 reads
This script is similar to Column_Gitter. I noticed this script and wanted to present the same output without the use of cursors. Both scripts work well and produce the same results. This little utility comes in handy if you do a lot of SQL coding. Given a table name, it'll return four results: The names […]
2003-08-14
101 reads
This script returns a description of the database with references to all tables in the database with keys listed. If the column description has been filled out the listing includes that text.If you want to get a report on the structure of each database, just add this script to each database, and then use a […]
2003-08-14
826 reads
2003-08-14
211 reads
This function is similar to the ISNUMERIC native function, but tests for a valid integer. ISNUMERIC can return false positive results when testing for a valid integer. For example this select returns a value of 1 (true):select isnumeric('3d8')For 6.x and 7.0, you can easily convert it to a procedure.
2003-08-14
3,060 reads
These four scripts list concise information about all Default, Check, Unique, Foreign Key, and Primary Key constraints for the database in which they are run. With minor column modifications, they could easily be unioned to provide a single list. The usual caveat applies about directly accessing system tables. They may change in future versions and/or […]
2003-08-14
1,121 reads
Very simple and straightforward script that creates a temporary table and fills it with prime numbers from 1 to the upper bound you specify. May be useful for educational purposes or even some cryptography applications.
2003-08-14
155 reads
This VBScript script lets you display the available disk space in each one of your administered DB servers.You have to call it with ONE argument: the filename of an archive that contains a list of known servers over which you have administration permissions. If you program VBScript, you can put alarms when any drive goes […]
2003-08-13
430 reads
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers