Execution Plan for a User Defined Function
When you execute a multi-statement user-defined function you may see an execution plan that looks something like this:
It appears as...
2012-03-30 (first published: 2012-03-26)
8,333 reads
Blog Posts
Liveblog for #SQLBits X Day 1 Keynote
Welcome to the show! I’ll be liveblogging today’s keynote here at SQLBits X in London.
There’s no need to refresh your...
2012-03-30
1,613 reads
Re-blog – March 23 – March 29
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-30
1,872 reads
Select : Lock or No Lock?
Here is a post I happen to find today: why select command is not blocked by update command?
http://blog.csdn.net/zjcxc/article/details/4383113
First, I...
2012-03-30
2,986 reads
Spring SQL Server Connections / DevConnections
I returned late last night from the Spring DevConnections event, delivering three sessions in the SQL Server Connections conference. I...
2012-03-30
2,683 reads
SQL Saturday #130 Jacksonville Schedule Posted
SQL Saturday Jacksonville is just under a month away (April 28) and I’m happy to announce the we recently released...
2012-03-30
1,660 reads
SQL Server Upgrade error: It is not possible to change the SQL Server features to be upgraded in this release. Validation errors. There are no features selected for upgrade.
On a recent project I was asked to “upgrade” a licensed SQL Server 2008R2 Standard Edition to SQL Server 2008R2 Enterprise Edition....
2012-03-30
6,725 reads
Start Building Your Next Network
Take a look at your network right now and while it probably has some diversity, I bet it’s tied pretty...
2012-03-30 (first published: 2012-03-25)
1,554 reads
Stress Thoughts-Part 4
Recently I suffered through a frustrating and contentious meeting, and that was stressful. I needed a walk, a few minutes...
2012-03-30
1,611 reads
An Amusing New Chapter of My Career
Starting next week, that’s the first week of April, this will be my new office. Well, not really, but I’ll be working for the company that hosts this coaster,...
2012-03-29
11 reads
Blogs
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers