Author: Database Journal

Feed: Database Journal. Author: Gregory Larsen. Table Variables have been known to run slowly when the table variable contains lots of rows. This is because when a batch is compiled the table variable has yet to be populated with any rows, and therefore the optimizer uses an estimated row count of 1 for table variables. This occurs because table variables don’t have statistics. Having an estimated row count of 1 works well for operators that have small row counts, like a NESTED LOOP operator for a join operation. Operators that perform well for small numbers of rows do not always ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . By Gregory A. Larsen A TSQL code snippet is a set of code that performs a task that can easily be placed in your TSQL code using SQL Server Management Studio (SSMS). Snippets are a great way to jump start creating a fragment of TSQL code for common types tasks, like creating a table, a stored procedure, a trigger, and index, etc. In this tip I will show you how to create and register a new snippet with SSMS. To create a new snippet, you first have to create a file that ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . By Gregory A. Larsen A TSQL code snippet is a fragment of code that can easily be placed in your TSQL script using SQL Server Management Studio (SSMS). Snippets of code often contain some text that you need to modify to work for your purpose. The insert process makes it easy to identify and modify the text of that snippet.  At a Glance Open a Query window. Insert your snippet. Create your table. Save time with a script. By using a snippet, you can insert a block of code into an existing ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . By Gregory A. Larsen If SQL Server Management Studio is your primary tool for writing your TSQL, then you need to learn keyboard shortcuts to be more efficient.  Keyboard shortcuts are a combination of one or more keys that when entered together perform some task, that would normally take a mouse click, or multiple commands to accomplish.   There are many different types of categories of keyboard short cuts, toolbar, menu, window management and cursor movement to name a few. F5 – Executes TSQL script  CTRL+N – Opens a new query window ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Have you ever been testing a query in SQL Server Management Studio (SSMS) and you really didn’t want to see all the rows of output coming back in the result window? Well, if you have then there is a way to turn off those distracting results when you run your query. You might ask why would you want to do that? One reason is that you might want to do some performance testing and the results of the query themselves are not important. By discarding the results of your query, you are ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Standby databases have been both bane and boon to DBAs. The boon is the ability to quickly recover from a Primary database failure by failing over to the Standby essentially allowing the business to "pick up where they left off" when the unthinkable happens. The bane, many times, is errant transactions which compromise the production data on the Primary side. Given that, in most Standby or Data Guard installations, the lag period between Primary and Standby is no more than the time it takes to switch logs, this can be far too ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . The #1 priority of a DBA is to make sure they can recover a database should it become corrupted.  To recover a database, you need to make sure you have backups. Is knowing you have a backup process that is scheduled to run enough to make sure you have backups? No! I've actually experienced a situation where my backup jobs were running every night, but were not creating the backups correctly. Worse yet, I wasn't notified. Therefore, as a DBA you need to check periodically to make sure you have backups. I ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . By Gregory A. Larsen Table Variables have been known to run slowly when the table variable contains lots of rows. This is because when a batch is compiled the table variable has yet to be populated with any rows, and therefore the optimizer uses an estimated row count of 1 for table variables. This occurs because table variables don’t have statistics. Having an estimated row count of 1 works well for operators that have small row counts, like a NESTED LOOP operator for a join operation. Operators that perform well for small ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . SQL*Plus and PL/SQL have been at odds for years -- cases abound where how a task is performed using SQL*Plus differs from how that same or similar task is completed in PL/SQL. Additionally there are data types available in PL/SQL that have been unavailable in SQL*Plus. Oracle version 21c provides a way to use some of the PL/SQL data types in SQL*Plus type definitions, with the caveat that the PL/SQL types will not be persistent. What does this mean and how does one go about using this new-found treasure trove of types? ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Azure offers diverse backup capabilities, spanning a wide range of on-premises and cloud-based workloads. These capabilities include a number of options to perform backups of SAP HANA running in Azure virtual machines (VMs). The purpose of this article is to provide an overview of these options. Traditionally, these options could be grouped into two main categories. The first one relied on Azure Backup while the other comprised third-party Marketplace offerings. Azure NetApp Files, which became generally available at the end of May 2019, could be potentially viewed as third category. While this ... Read More