Code Comparison between two databases
This script compares the code (SP, Func. etc.) between two databases (say Dev and QA) and reports the objects which have differences.
2009-02-26 (first published: 2007-03-08)
631 reads
Scripts
TEXT/NTEXT Find and Replace
Find And Replace any string, in the entire table with this function. Parameterized for easy use.
2009-02-26 (first published: 2009-02-09)
894 reads
Default Trace Load of All 5 Files
The default trace keeps the last 20 meg of info, and a max of 5 files...This loads all 5 files into a table so it can be reviewed.
2009-02-25 (first published: 2009-02-07)
1,254 reads
2009-02-16 (first published: 2009-02-03)
2,636 reads
2009-02-05 (first published: 2008-05-20)
2,219 reads
Two scripts to spell out numbers in words
These SQL functions will allow you to convert decimal numbers to words
2009-02-02 (first published: 2009-01-22)
1,997 reads
Growth remaining for SQL Server 2005 databases
This script is little bit similar to the one posted for SQL Server 2000 that finds how much space you have left.
2009-01-30 (first published: 2009-01-19)
948 reads
2009-01-26 (first published: 2009-01-08)
941 reads
2009-01-23 (first published: 2009-01-14)
2,015 reads
View - Table Usage (Recursive)
Written to explore the table dependencies of a view, especially when the view queries other views.
2009-01-22 (first published: 2009-01-11)
1,251 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCP Surabaya No.Telpon 087781685647
Whatsapp 087781685647 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera...
BCA KCU JAYAPURA No.Telpon 087781685647
Komp. Pertokoan Jayapura, Whatsapp 087781685647 Jl. Pacific Permai Jl. Dr. Sam Ratulangi No.31 Blok...
BCA KCP Abepura No.Telpon 087781685647
Whatsapp 087781685647 Jl. Raya Abepura, Vim, Kec. Abepura, Kota Jayapura, Papua 99351
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers