SQL Server Management Objects: Lessons from the Wild
Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.
2007-11-13
2,997 reads
Additional Articles
SqlCredit – Part 10: MAC Performance and Updating SqlCredit
This month's installment of "Developing a Complete SQL Server OLTP Database Project" covers MAC performance results, a summary of encryption findings, and comments on updating the SqlCredit code based on those findings.
2007-11-13
1,635 reads
Index related DMVs and DMFs - sys.dm_db_index_usage_stats
Examining statistics of indexes is useful for optimizing the performance of queries. Statistics help us determine the usage and worth of indexes - one simple method is using the index-related dynamic management view; sys.dm_db_index_usage_stats
2007-11-12
2,975 reads
Passing table valued parameters in SQL Server 2008
I have always wanted to be able to pass table variables to stored procedures. If a variable is able to be declared, it should have the functionality to be passed as necessary. I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass table variables (and the data in them) into stored procedures and functions.
2007-11-12
2,406 reads
Trustworthy Computing: Lessons Learned from Five Years of Building More Secure Software
This article discusses prioritizing code by age, using analysis tools and automation, looking at threats from multiple angles, and the importance of education
2007-11-09
1,458 reads
Update SQL Server Table Statistics for a Performance Kick
Find out how to update and tune table statistics in SQL Server to ensure data accuracy and boost performance. Learn auto and manual update commands.
2007-11-09
4,503 reads
Importing Poorly Formatted Text Files using SSIS
Importing text files is a common task for DBA's and Developers, but what happens when the text file is not properly formatted?
2007-11-08
4,463 reads
SQL Puzzle 7
After a gap of sixteen months, Lionel Clarke, the creator of the only 3-D maze game to be written in TSQL, returns with a new SQL puzzle. It is very simple. You have to move as much of the data as you can from the source tables to the destination tables.
2007-11-08
2,661 reads
Using SQL Server 2008's MERGE statement
SQL Server 2008's new MERGE statement allows you to insert, update, or delete data based on certain join conditions in the same statement.
2007-11-08
2,632 reads
Optimize tempdb in SQL Server by Striping and Splitting
Find pointers to optimize tempdb performance in SQL Server by striping and splitting across multiple files in SQL Server 2005.
2007-11-07
3,737 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers