One thing I have gotten wrong before, or not elaborated on before in presentations on mirroring, although Roman Rehak mentioned...
2010-12-16
2,289 reads
How many times have you walked up to a SQL Server that has a performance problem and wondered where to start looking?
2010-12-16
5,016 reads
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...
2010-12-15
3,713 reads
Changes are inevitable and like many other things in life your application will change over time. The question is how to upgrade an already deployed Data Tier Application to a newer version; what are the different methods available for upgrade and what considerations should you take?
2010-12-15
2,360 reads
In this webinar, MVP and noted author, Grant Fritchey shows you how to better keep track of what is happening on your instances by gathering information on performance from SQL Monitor and then using that to interpret the impact on your databases. Dec 14, 2010.
2010-12-14 (first published: 2010-12-07)
2,243 reads
Sharon PruittIn the lead in to this post, I talked about how the plan cache can...
2010-12-14
938 reads
This article explores the causes and remedies for applications failing due to too many open connections to SQL Server.
2010-12-14
3,775 reads
This challenge involves evaluating mathematical expressions presented using Roman Numerals and return the result of each expression.
2010-12-13
1,690 reads
Of the big four DML statements in SQL Server, the DELETE is the one least written about. This is odd considering the extra power conferred on the statement by the addition of the WITH common_table_expression; and the OUTPUT clause that essentially allows you to move data from one table to another in one statement.
2010-12-13
6,506 reads
For years we’ve been told you should use Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in...
2010-12-13
3,196 reads
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Comments posted to this topic are about the item Four Rules for Adding AI...
Hello, the title says it all. Is the SQL Server 2025 section missing?
I am not sure which is the best way to proceed. I have parent...
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers