Do IF statements cause recompiles?
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
Articles
Upgrading Data Tier Applications in SQL Server 2008 R2
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
SQLServerCentral Webinar Series #6: Gathering and Interpreting Server Metrics including SQL Monitor
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,224 reads
Can You Dig It? – Parallelism in the Plan Cache
Sharon PruittIn the lead in to this post, I talked about how the plan cache can...
2010-12-14
938 reads
Monitor User Connections in SQL Server
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
TSQL Challenge 45 - Evaluate mathematical expressions presented using
This challenge involves evaluating mathematical expressions presented using Roman Numerals and return the result of each expression.
2010-12-13
1,681 reads
The DELETE statement in SQL Server
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
What’s Going on with SQL Server Service Account Changes?
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
Hierarchies in SQL
One very common structure that needs to be handled in T-SQL is the hierarchy. One of our prominent members of the community discusses how you can handle hierarchies in SQL Server.
2010-12-10 (first published: 2009-01-28)
33,846 reads
Put Your Thinking Caps On
Three contests from Red Gate Software are coming next week. Get a hint about what might be coming and set a reminder on your calendar.
2010-12-10 (first published: 2010-12-08)
1,541 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers