Yes, Table Variables and Temp Tables both use the tempdb
Pinal Dave recently wrote a blog post called SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth...
Architecture Principles
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
Dissecting SQL Server Execution Plans
A review of MVP Grant Fritchey's "Dissecting Execution Plans". This is one book that you'll want on your bookshelf.
Using a Certificate Signed Stored Procedure to Execute sp_send_dbmail
Learn how to create a certificate signed stored procedure to solve common permissions problems using sp_send_dbmail. MVP Jonathan Kehayias brings us a short tutorial that discusses your options and code to show you how to implement certificate security.
Architecture Principles
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
Architecture Principles
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
Architecture Principles
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
Tally Table - Character Date Validation
Tally (or numbers) tables are one of my favorite query writing tools. Such a simple premise that can be applied...
Tool to help you analyze SQLDIAG and PSSDIAG output
SQLDIAG or PSSDIAG are excellent tools used to collect and analyze data in order to identify possible performance root causes. The issue is that the output produced by such utilities is sometimes convoluted, hard to read and hard to understand. In this tip, I will show you a tool that you can use to read and analyze the data collected by these tools.
How can we standardize SQL Server Data Deployments?
Some change requests, such as deploying a new stored procedure or trigger, are relatively easy to manage whereas others, such as data deployments, tend to thwart all attempts at standardization. And yet, there must be a way, and Rodney Landrum believes that DBA-developer co-operation lies at the heart of it.
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers