Review of Transact SQL Desk Reference
Looking for a good (or another) TSQL reference? This might be the one. Bruce took a good look at it and points out both the good and the bad.
2004-02-17
5,449 reads
Articles
Quest Releases TOAD for SQL - Freeware!
Quest Software has recently released TOAD for SQL Server, a freeware version of its highly popular Oracle tool - TOAD
2004-02-17
837 reads
Changing Databases Using XML
Need to apply changes to customer (or internal) databases in a calm, controlled manner? Dinish proposes an alterative to standard scripts that uses XML and a small VB app.
2004-02-16
5,687 reads
Contest!
We've run contests from time to time over the past couple years and had a lot of fun doing it. This time we're trying something new, partnering with Red Gate. Lots of good prizes on this one!
2004-02-16
309 reads
Review of Lumigent Log Explorer v4
Chris (one of our regulars!) installed Log Explorer and took it for a test drive. Written up in our standard review format this will give you a very quick overview of what the product does.
2004-02-13
8,843 reads
An Introduction to Database Models
Frank returns this week with a good non academic overview of the different types of database models and some of the features/problems that are native to each.
2004-02-12
11,187 reads
Microsoft SQL Server 2000 Analysis Services Performance Guide
Analysis Services is slowly gaining in popularity and many of you might get drawn into setting up a server or developing a system based on this technology. Microsoft has released a performance guide to help you take performance into consideration from the beginning.
2004-02-11
1,221 reads
Optimize Your Applications
This article demonstrates that one way to optimize the data access portion of your app is to do the query once and cache the results. This is not advanced caching just something to get you started thinking about the possibilities.
2004-02-10
7,866 reads
SQL Server 2000 Best Practices Analyzer Beta
Microsoft has released a new tool to analyzer your SQL Servers and see how they conform to their list of common best practices. Give it a try and let us know what you think.
2004-02-10
3,515 reads
Viewing the Hierarchy of Stored Procedures
In this short article that follows up on an earlier one that discussed dependency issues we have some code that will generate simple treeview type view of the relationships between procs. Mostly code, more so than usual, but we thought you might find the idea useful!
2004-02-09
7,043 reads
Blogs
Catching Up On SQLOrlando
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers