Reducing the amount of round trips between a server and client is something that can give you a great boost in performance. David Poole looks at how he solved a problem with HTML checkboxes and the challenges they solve in a programming environment. Without Dynamic SQL!
A personal article refering to the latest change from NTL broadband stopping port 1433 globally on their network. Users are no longer able to develop Microsoft SQLSever systems using ODBC or Enterprise manager.
Learn about SQL Server and the CLR. Join PASS and speaker Michael Otey, Senior Technical Editor for SQL Server Magazine and Windows & .NET Magazine and President of TECA, Inc., for the upcoming WebCast where you'll learn about the new .NET Common Language Runtime integration with SQL Server 2005. Registration Required.
Office 2003 has a new tool: InfoPath 2003, which can work with SQL Server along with numerous other data stores. It's a great way to begin working with XML, Web Services, and many of the newer technologies that are available today. Join Dinesh Askanka on his journey to learn more about InfoPath2003 in the start of another series.
SQL Server Find, a product from Genius@Work, allows you to search your databases for objects based on a variety of criteria.
Knowing which databases are being backed up is a critical thing for all DBAs to know. After reading an article on this subject, new author Santveer Singh decided to share his own techniques for checking SQL Server databases and their backup status. He shows us how to look for failed backups as well as find those databases which have not been backed up.
Upscene Productions is happy to announce a new version of
the database developer tool: "Advanced Data Generator" (version 1.1.0)
A fast test-data generator tool that comes with a library
of real-life data, presets and much more.
This new release consists of four versions:
- Pro: ADO and ODBC connectivity
- InterBase Edition
- Firebird Edition
- MySQL Edition
More info, pricing and a 30-day trial version on www.upscene.com
Error handling in SQL Server 2000 is tricky. And it isn't the most robust system in the world. Stefan Popovski started a series on error handling using @@error and xact_abort. Here's the second installment of this series looking at error handling in nested stored procedures.
Andwil, 06-Jun-2004: To celebrate the 1-year anniversary for their SASSI v2.0 professional SQL Development Environment application, Dynamic3 GmbH is offering a limited amount of SASSI license keys for FREE! To register for a free license key, visit the website now! http://www.sqlassi.net
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Comments posted to this topic are about the item Minimum Change Tracking Retention
Comments posted to this topic are about the item AI Steals Joy
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers