Some Undocumented Stored Procedures
This article examines some of the undocumented stored procedures that exist in SQL Server 7.0
2001-09-28
7,716 reads
Articles
Optimizing SQL Server Performance by using File and Filegroups
A look at files and filegroups in SQL Server 7.0, including some optimization tips.
2001-09-27
8,995 reads
Using AWE Memory in SQL Server 2000
Learn how to take advantage of AWE memory to boost the performance of SQL Server 2000.
2001-09-27
1,009 reads
IQ Reference Review
Tired of lugging all those reference books around? Check out this site that is sure to find a permanent home in your favorites list.
2001-09-26
2,357 reads
Review : Rent A Geek Book with IQReference
If your bookshelf looks like most in the technology field, you tons of tech books. This new product by IQ Destination allows you to virtually rent books.
2001-09-26
2,538 reads
Update: Funny Windows Error
Thanks to all of you who have sent us your funny SQL Server and Windows errors. Here are a few more contributed by Sergei Yakovlev.
2001-09-26
161 reads
2001-09-26
3,387 reads
The Sysadmin Price List
Implement this and I guarentee your tech support call volume will drop!!! (Or you'll soon be retiring)
2001-09-25
2,801 reads
Introducing IQReference
IQReference is an online reference platform using well known, published materials. Read about this exciting and benefical product.
2001-09-24
3,160 reads
Managing Spatial Information with SQL Server
You already know how to use SQL Server to manage your core business data, now learn how to leverage this knowledge to manage your "spatial" data.
DATE: September 25, 2001
TIME: 2:00pm ET, 6:00pm GMT
DURATION: 40 minutes, including questions & answers at the end
With SpatialWare for SQLServer, you now have the ability to manipulate spatial objects and store them inside of SQL Server allowing you to share information across the enterprise.
2001-09-24
52 reads
Blogs
DATEADD Truncates the Number Parameter: #SQLNewBlogger
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
Our SQL Server is Slow! What Do I Do First?
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Using SQLFluff
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Eliminate a function by writing out the code is now throwing an error
/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...
SQL Server Migration - Redirecting Old Instance Connections to New AG Listener
Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a...
Question of the Day
A Strange Choice
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci See possible answers