Indexed Views – Performance Panacea or Plight

Indexed View(s)
An indexed view is a view where the result set from the query (the view definition) becomes materialized in lieu of the virtual table result set of a standard (non-indexed) view. Many times we see that an indexed view would be created to help improve performance. Far too often, an indexed view is created without consideration for the […]

By |January 28th, 2016|SQL, SQL Group|2 Comments

Disk Space and SQL Server

Disk Space in SQL Server
One of the frequently required job functions of the database administrator is to track disk space consumption. Whether this requirement comes from management or from a learning opportunity after a production outage, the need exists.

As a hard working DBA, you want to make sure you hit all of the notes to make […]

By |January 21st, 2016|SQL, SQL Group|2 Comments

SQL Black Box Recorder

Across many professions and industries there is often a need to have some sort of device that “audits” everything that happens with a device or process. We are probably all quite familiar with the infamous black box recorders used by the passenger airline and train industries. It is also quite possibly fairly common knowledge that […]

By |January 12th, 2016|Extended Events, SQL, SQL Group|0 Comments

FreeCon, October 27, 2015 Seattle

The company that I work with, SQL Solutions Group, is conducting a free community event. The week of the PASS Summit, on Tuesday, we will be hosting a day of free training. This is an event for all data professionals who happen to be in the Seattle area the days leading up to Summit but […]

The post FreeCon, October 27, 2015 Seattle appeared first on Wayne Sheffield.

By |September 23rd, 2015|SQL, SQL Group|Comments Off on FreeCon, October 27, 2015 Seattle

What Sessions are Deployed?

As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying to figure things out for yourself. It may even be very common to feel the icy pain of the development cold shoulder (intentional or not) as you go about doing your duties to protect the […]

By |September 1st, 2015|Extended Events, SQL, SQL Group|0 Comments

Defaults In msdb Database

Today is a day to discuss defaults. It started with the day being TSQL Tuesday and having a topic of “Say No to Defaults.” You can read more about that from the invite – here. I already participated in the party but did also want to discuss defaults a little bit more. That said, this article […]

By |July 15th, 2015|SQL, SQL Group|0 Comments

Interview Trick Questions

Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want to dive into a something a little more fun.

Anybody that has interviewed for a job has most likely run into the trick question. Some interviewers like to throw out multiple trick questions all in an […]

By |May 21st, 2015|SQL, SQL Group|0 Comments

Quick Permissions Audit

Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out who has access to what.  In addition, they may need to know by what means people have access within your databases.

When that need arises, it is frequently adequate to just perform a quick audit and […]

By |May 13th, 2015|SQL, SQL Group|0 Comments

Automating DBCC DBTABLE – obtaining the disk Sector Size

I was recently reading this msdn article on Ghost Records, and it mentioned that you could get the number of ghost records on a page with DBCC DBTABLE… and it also mentioned that you need to be sure that you enable Trace Flag 3604 in order to see the results. So, two things immediately jumped […]

By |April 28th, 2015|SQL, SQL Group, SQL Server|2 Comments

Upgrading From SQL Server Profiler

You may recall an article I had written a couple months back describing how to use Extended Events to perform your SQL Server Profiler duties. If not, you can read all about it here.

In that article, I showed one common use-case for SQL Server Profiler and how to achieve the same result via Extended Events. […]

By |April 22nd, 2015|SQL, SQL Group|0 Comments