databasejournal.com databasejournal.com

Improve Database Allocations through Instant File Initialization

As a Database Administrator, you need to consider setting up your environment to do instant file initialization. This article explains what instant file initialization is, why it is important, and shows you how to set it up. Additionally, we demonstrate how not setting it up can adversely affect your database performance. As a Database Administrator, you need to set up your SQL Server environment as optimally as possible. ...

databasejournal.com databasejournal.com

Collecting Performance Metrics Using SQL Server DMV

If you cannot afford a third-party tool that can capture database performance metrics or don't want to roll your own solution, then using T-SQL to collect some performance metrics for SQL Server may be your solution. . What method do you use to determine how well your server is performing overtime? Do you know what your batch request per Second looks like over the last 30 days, or year? Can you track your page life expectancy over...

databasejournal.com databasejournal.com

Tips for Using Common Table Expressions

Greg Larsen explores using multiple Common Table Expressions (CTEs), the MAXRECUSION option, how to use a CTE within a cursor, and what you cannot do within a CTE. I introduced you to Common Table Expression (CTE) in my last article. In that article, I covered the basic syntax of a CTE and provided a couple of examples of using CTEs. This article will be an extension of that article. This article explores using multiple CTEs, the...

databasejournal.com databasejournal.com

Introduction to Common Table Expressions

A Common Table Expression (CTEs) is an expression that returns a record set that can be referenced within the scope of a single INSERT, UPDATE, DELETE, INSERT or CREATE VIEW statement. Greg Larsen describes how to define a CTE and then provides some simple examples that demonstrate how to use a CTE. With the introduction of SQL Server 2005, Microsoft introduced Common Table Expression, which is commonly called CTE. A CTE is an...

databasejournal.com databasejournal.com

Encryption Primer for SQL Server Data

As a database developer or DBA there is not a lot you can do about a legitimate user sharing confidential data. However, you can minimize the risks of someone breaking into our database and browsing around to find confidential information. This article explores how you can use SQL Server features to encrypt your confidential data. More and more frequently, you hear about some company that has leaked confidential data to someone that...

databasejournal.com databasejournal.com

The Dos and Don'ts of Database Indexing

It always seems like the creation of indexes on a database are always the last thing developers and database designers think about when designing a database. Indexes are almost an afterthought. Developers seem to only place indexes on tables after they notice one of their queries are running slow. In addition, many times that does not happened until they place their applications into production. In my prior article, Database Indexing...

databasejournal.com databasejournal.com

Getting Acquainted with SQL Server 2008's Resource Governor

With the introduction of SQL Server 2008 came some new features. One of those new features is Resource Governor. With this new feature, you can control resource allocations based on rules. In this article I will explain how to setup resource governor, how to use it and the limitations associated with this new resource allocation tool. What is the Resource Governor? The Resource Governor is new technology that was incorporated into...

databasejournal.com databasejournal.com

Database Indexing Development Lifecycle...Say What?

This is the first article of a series where I’ll be exploring Indexing Guidelines. Having appropriate indexes on your database is critical in making sure your application is retrieving records quickly. However, having too many indexes can also slow down your application. In this series of articles, I hope to help you understand how to determine what columns you should consider for indexes, and how those columns should be used...