Deferred-drop tipping point
I was intrigued by the deferred-drop feature that has been inside SQL since SQL Server 2000 SP3 after watching one...
2014-05-31
1,747 reads
Blog Posts
Building The SQLSaturday Orlando Marketing Plan-Part 15
After doing some local exploring of the idea of delivering certificates of completion I don’t think it’s enough of a...
2014-05-30
1,246 reads
Configuring SQL Server Database Mail Feature
You can send e-mail from within stored procedures, functions, and triggers by using SQL Server Database Mail. You can also...
2014-05-30
1,477 reads
Database capacity planning and management
As part of the planning and research before implementing new SQL Server, you must determine the amount of space needed...
2014-05-30
4,887 reads
Do you apply SQL Server Cumulative Updates?
I think Steve Jones makes a great point here with respect to cumulative updates:
“This is one reason I’ve been hesitant...
2014-05-30 (first published: 2014-05-28)
6,865 reads
Friday Followup For May 30, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-05-30
991 reads
Implementing Checkpoints – To restart SQL Server Integration Services packages from the point of failure
An SQL Server Integration Services package often includes tasks that can take a long time to run. If the package...
2014-05-30
1,280 reads
MDX #41–Remove employees with less than $100,000 sales
Table of contents
Need to remove employees who have zero sales amountCreate a calculated measure with the IIF() function The NON...
2014-05-30
1,484 reads
Quick Tips–SQL Prompt Qualifying Columns
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-05-30 (first published: 2014-05-28)
1,718 reads
SQL #54–Casting numbers with white spaces as Integer will fail
Table of contents
IsNumeric() funciton is too forgivenUse Pattern Matching with LIKE keywordLIKE keyword in T-SQL doesn’t support regular expressionReplace white...
2014-05-30
1,533 reads
Blogs
TempDB Internals – What’s New (Sql Server 2016 to 2025)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
A Wellbeing Day at Redgate
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
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