.jpg)
.png)
.png)
.png)
June 15, 2016
SQL tip #5: Be prepared for SQL 2016
Did you know that in SQL Server 2016 you can now specify the location of the tempdb files during setup?
This means less reconfiguration of your SQL Server environment post installation. If you forget to create the folders prior to the installation, don’t worry, you can create the folders for tempdb during the installation.
Try it out next time you install SQL Server 2016.
Related Posts
.png)
May 4, 2016
SQL tip #1: Store SQL DB files in Azure storage
Did you know that you can configure an Azure SQL VM (or on premise machine) to store SQL data (.mdf) and log (.ldf) files in Azure storage?
April 27, 2016
SQL tip #2: Remove unnecessary SQL components from an Azure VM
Did you know that when you first request a SQL Azure VM it comes with everything installed? This includes Analysis Services, Integration Services, Reporting Services, etc, even if you don’t want to use them.
May 25, 2016
SQL tip #3: consider a table variable
Most developers know the # preceding a local temporary table very well, as temporary tables are really useful when you need to keep some stuff in a place for a moment while you do something else. But you may not know there are quite a lot of processes that go into making this table, or that these can really inhibit the reuse of execution plans. So a harmless #temp may be bloating your memory or putting extra pressure on your TempDB and you might not even know about it.
June 8, 2016
SQL tip #4: using output clause to return changed items
Did you know that you can use the output clause to return updated or inserted rows without having to select them again?
June 30, 2016
SQL tip #6: Scripting multiple SQL objects
Sometimes we need to script multiple SQL objects, either for deployment, documentation or quick search, eg to find SSIS package name.