I use this script to quickly compare databases. In the past, I would generate creation scripts and compare those but that is tedious at best. This script generates a report of the metadata in an easy to read format that includes...- Table and Field Listing with types.- Foreign Key information- Primary Key and Index information- […]
2005-07-28 (first published: 2005-07-18)
593 reads
Calculates the next business day based upon the work weeklength, number of days from the start date and a list of holiday dates kept in a table called HolidayDate.Created this script for determining the next banking day from 2 days after a request for wiring funds. Can be used for things like calculating shipping dates […]
2006-01-19 (first published: 2005-07-16)
1,538 reads
A script to test your database for 2005 readiness.these features are as described by the SQL 2000 BPA, however this script will run on SL 6.5,7,2000Please note that this is not a guarantee of readiness, however it is an indication that there are issues you may have to resolve to run your databases in 2005
2006-06-02 (first published: 2005-07-12)
857 reads
Move all (or chosen) standard indexes from your primary file group to a secondary file group (hopefully located on a seperate array)excludes clustered indexes, statistics and indexes associated with a primary keywhen you run it - set the debug to 1 to identify what the script will move, set it to 0 to actually perform […]
2006-06-19 (first published: 2005-07-08)
5,477 reads
The term “Enterprise Metadata Management” has been in use since the late 1980’s when many of us worked in classic “mainframe environments” using “corporate data dictionaries” to manage our COBOL programs, Job Control Language (JCL), screens, reports, copybooks, and database schema definitions. Fast-forward to 2005 ~ has anything changed? What does “enterprise metadata management” mean today ? I recently surveyed a number of leading metadata management vendors, Global 5000 companies, and industry thought-leaders seeking their input.
2005-07-08
2,007 reads
Script lists 'First day of the week','Last day of the week','Last day of the month' and 'First day of the month'
2005-07-21 (first published: 2005-07-07)
679 reads
It is quite often that we need to find Nth (5th or 8th or 10th) maximum or minimum number of record from the record set. The solution is different in MS SQL than in Oracle because we have RowNum in Oracle. Some time ago I got the same problem with a massive table of more […]
2005-07-22 (first published: 2005-07-05)
1,066 reads
SQL Server can support many different languages through Unicode. Author Dinesh Asanka brings us a basic article on how the server supports different languages.
2005-07-04
14,484 reads
forums question came up where someone needed to search every varchar/char field in the database, and find any table/field that had a specific value (ie ip address, email, servername) we all agree that a monster scan like this is bad, but bad or not, sometimes you need to do it.it returns results that look something […]
2005-07-07 (first published: 2005-06-29)
275 reads
If you wish to Format Number to 2 decimal without rounding it then, here is the trick.This is also useful when you are dividing 2 numbers and you need answer in 2 digiits only without rounding
2005-07-25 (first published: 2005-06-23)
510 reads
By Steve Jones
This is actually inspired by an article SQL Server Central, which taught me something...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
By Vinay Thakur
As Open Source – PostgreSQL and AI is a growing and powerful DB system,...
WA:08218154393 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
WA:08218154393 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
Comments posted to this topic are about the item How Clustering can be Used...
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers