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...
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?
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.
The Low End
Today Steve Jones talks about those products we consider "low-end." Products like Access or VB. Are they a problem for us?
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...
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.
How Do You Work When You are Not at Work?
Things have evolved since the days of essential pagers and landline connections. Or have they? Brad ponders how the nature of remote working is evolving, and invites you help others learn from your experiences.
iPads for Christmas
A contest from Red Gate and Steve Jones could get you a copy of SQL Monitor and an iPad for Christmas. Steve Jones talks about how you can enter, and perhaps win an iPad for yourself this holiday season.
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.
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.
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers