It Depends
It depends. The mantra of many DBAs and others in IT. Steve Jones reminds us why it applies.
SSIS Variable and Parameter Analysis
Use T-SQL to analyse the usage of all variables and parameters in an SSIS project, including the identification of any unused variables and parameters.
How to Find the Estimation Cost for a Query
Discover how to estimate the cost of a query. Read on to see an example of how to extract the Estimated Cost for execution plans stored in the procedure cache.
Take our short readers’ survey and win a $50 Amazon voucher
Could you spare 3 minutes to help us out at SQL Server Central/Simple Talk? Take this short survey, tell us about who you are and why you come to Simple Talk/SQL Server Central, and you could win a $50 Amazon voucher.
DAX for SQL Folks: Part III - DAX Calculations
Introduction In response to my approach in the pop...
Open Source is Not a Career Path
A reprint from the early days of SQLServerCentral as Steve is on vacation. Here is Steve Jones' Open Source Musings from February 3, 2005.
Improve Row Count Estimates for Table Variables without Changing Code
Table variables can cause performance issues with joins when they contain a large number of rows. In SQL Server 2019, Microsoft has improved how the optimizer works with table variables which can improve performance without making changes to your code. In this article, Greg Larsen explains how this feature works and if it really does make a difference.
Testing SQL Server Stored Procedures and Functions with SQL Data Compare
Phil Factor demonstrates a cunning way to test stored procedures or functions, such as after refactoring, by storing the 'before' and 'after' results in views and then using SQL Data Compare to spot any discrepancies.
Evaluating Life at Work
It can be hard to evaluate your career and job situation, but Steve has some ideas today.
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: 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,...
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