Varchar(Max) and ADO
Another note from a friend. They decided to upgrade a large varchar column to varchar(max) and subsequently found strange behavior...
2007-11-05
835 reads
Another note from a friend. They decided to upgrade a large varchar column to varchar(max) and subsequently found strange behavior...
2007-11-05
835 reads
This is an older article that was recycled for Fri, but still seems to get a decent number of views...
2007-11-04
453 reads
Just saw the announcement that there will be two back to back TechEd's next year. Both will be held in...
2007-11-03
343 reads
For quick and dirty work, sometimes Access is the best way to work with SQL Server. Andy Warren brings a basic tutorial on how you can link Access to your SQL Server tables to easily and quickly manipulate data.
2007-11-02 (first published: 2006-01-25)
27,134 reads
I had the chance to see Greg do a presentation at the PASS Summit in Denver that was based on...
2007-11-02
351 reads
This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.
2007-11-01 (first published: 2001-05-07)
24,616 reads
Picked this up from the local Net group here in Orlando. INETA is actually pretty helpful when it comes to...
2007-10-31
1,415 reads
Sometimes its the little things that seem to take forever! We've had a text only logo up for a while,...
2007-10-31
1,440 reads
If exists is a well known way to improve performance because it returns as soon as it matches a single...
2007-10-30
1,954 reads
After a few meetings of oPASS this year the numbers I use are 2 slices of pizza and 2 drinks...
2007-10-29
1,448 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers