SQL Server 2005 comes with a built-in answer to this problem: the Database Engine Tuning Advisor. Combining a simple user interface with a deep knowledge of SQL Server, this utility can help you tune your databases for peak performance.
Commenting seems to be the bane of every programmer, database or otherwise. Sachin Dedhiya brings us a look at brings some standards to how you should comment your code in a SQL Server database.
Once again the SQLServerCentral.com staff is putting on a Tuesday night reception. Read how you can attend this November in Seattle.
The Database Tuning Advisor (DTA) is an improvement over the old Index Tuning Wizard. Learn how to access the advanced features of DTA from the command line with a custom configuration.
SQLServerCentral.com is offering Integration Services training at our new training center. Sign up today and learn from Brian Knight, MVP and SSIS Guru.
Lightweight and adaptable, but with proper emphasis on the design phase, the ICONIX methodology can help you avoid Constant Refactoring After Programming...
Training is an important part of anyone's life in technology, especially if you are a SQL Server DBA or developer. With the release of 2005, the entire paradigm of working with SQL Server has changed and you need to be working on your own personal knowledge base. Steve Jones takes a look at how you can get training and shake the funding loose as well.
A seemingly never-ending battle in online database forums involves the question of whether or not database application development should involve the use of stored procedures.
For those of you using Analysis Services, Yaniv Mor takes a look at some of the manageablity tools with SQL Server 2005. The way you work with Analysis Services and your cubes has changed dramatically and this is a good overview to get you started.
Better late than never, here's a look at the May issue of the SQL Server Standard, now available as a PDF.
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
By Steve Jones
This is kind of a funny page to look at. The next page has...
A while ago I blogged about a use case where a pipeline fails during...
I have a table I didn't design that has tons of repeating groups in...
Comments posted to this topic are about the item Writing as an Art and...
Comments posted to this topic are about the item String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers