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
456 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,144 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,624 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,966 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
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers