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,547 reads
Brian Knight
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
233 reads
Funny SQL Server Error Messages
This is the funniest error message Brian Knight has ever seen in SQL Server.
2001-09-18
7,269 reads
Death of the Production DBA
If you see a priest outside your cubical, beware! He could be trying to read you your last rites. If he hasn't showed up yet, don't worry, he'll be over shortly because the production DBA is dead or will be shortly.
2001-09-10
9,662 reads
Review: Loading Sample Data with DataTect 1.6
So, you've created a database and application and want to see how it operates with a substantial load of data In this product review of Datatect 1.6, you can learn how this third-party product could help you benchmark you database with a lot of sample data.
2001-08-15
3,921 reads
Database Growth Monitor
The script will monitor the growth of the databases on your server. It is really meant to just get you started on a more detailed solution.
2001-08-08
5,345 reads
Kill All Users in A Given Database
This script will kill all users in a given database. Before disconnecting, it can optionally send the user a NET SEND Message giving them a warning to disconnect. To run, simply call it like usp_killusers 'dbname'. Make sure the @dbname parameter is not the master database.
2001-08-08
4,511 reads
Quickly Enable/Disable Triggers and Constraints
When loading data, nothing can be more frustrating than having to deal with stubborn constraints and triggers. This is especially true when you know your data is fine but the constraints are too prohibitive for a mass initial load. Here's a technique I use to disable the constraints and triggers temporarily during a mass load. […]
2001-08-08
3,096 reads
Optimizing DTS Data Loads
In this article, Brian Knight shows you the different ways to load data in DTS and how to optimize the Data Pump task for data loads. He also examines performance numbers on other data loading tasks in DTS.
2001-08-02
7,492 reads
FAQ : Why can't I see my text field's data when using ADO?
In this FAQ of the week, you'll see one of the most common bugs that programmers run into when programming using ADO against a SQL Server.
2001-07-06
36 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers