What is the search order for Procedures prefixed sp_?
In this article, James Travis covers a common performance topic of prefixing stored procedures sp_. Does it really slow down performance?
2002-11-14
7,097 reads
Articles
A Sneak Peek at Entegra
Recently, the SQLServerCentral.com labs had the chance to get a sneak peak at Lumigents latest creation, Entegra, which is scheduled to ship in the second week in December. Entegra monitors database activity and provides a complete record of access to the data and changes to database structure and permissions.
2002-11-13
3,310 reads
Move Your Master
How often do you move your master database? Hopefully never, but this article looks at an easy technique should you need to perform this trick.
2002-11-12
10,014 reads
Worst Practice - Not Having An Archive Plan For Each Table
We're curious to see what our readers have to say about this one! How many of us have tables accruing data that won't be used and/or isn't of any value? At what point do we get rid of it to free up resources?
2002-11-11
9,238 reads
Streamlining the Database Server Recovery Process
Are you tired of manually restoring each database on a new server when the original server has a melt down? Does the manual process seem slow, and prone to keystoke and mouse click errors? Would you like to have those restore scripts automatically built, so you only have to fire them off? Well this article will show you one possible method for speeding up and reducing errors will trying to perform a restore of all databases on a server.
2002-11-05
9,031 reads
Why Secure the Database?
You're behind a firewall, you have passwords. Why spend any great amount of time on extra database security? Steve thinks there are a few reasons why in this article.
2002-11-04
4,489 reads
SQL Server Notification Services Documentation
Microsoft has released the "Books Online" equivalent for Notification Services. Browse through and take a look to see if this service is useful to you.
2002-11-01
694 reads
Loading a Series of Flat Files
Andy Jones recently faced a requirement to load several flat files on a nightly basis. In this article, Andy Jones shows you how he accomplished this and shows plenty of code!
2002-10-31
11,233 reads
SQL Server Product Support Life Cycle
Microsoft has formally clarified the support life cycles for it's products. See where your products fall in and be sure to plan for upgrades.
2002-10-30
3,333 reads
Hidden Connections
Ever have strange DTS errors after moving a package? You changed all the connection strings, but still get connection errors. Steve Jones did and tracked down one potential culprit.
2002-10-29
4,388 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers