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
843 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
843 reads
This is an older article that was recycled for Fri, but still seems to get a decent number of views...
2007-11-04
455 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,143 reads
I had the chance to see Greg do a presentation at the PASS Summit in Denver that was based on...
2007-11-02
352 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,622 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,442 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,964 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,450 reads
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
Comments posted to this topic are about the item No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers