-->
Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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.… Read more

0 comments, 97 reads

Posted in A Discussion of SQL Server-Related Topics on 22 March 2017

Working with SQLSaturday SpeedPASSes

SQLSaturday SpeedPASSes

I’ve been working with running SQLSaturdays in the Richmond, VA area for several years now. It seems that every year, I end up blogging something new. Frequently, this ends up being a script of some kind to help me out. This post follows this theme by introducing a… Read more

0 comments, 35 reads

Posted in A Discussion of SQL Server-Related Topics on 9 March 2017

Identifying a row’s physical location

While you may not need to worry about the physical location of a row very often, every so often the need comes up. In a few of my earlier posts (here), I have needed this information to prove a point. This post shows how to identify a row’s… Read more

0 comments, 32 reads

Posted in A Discussion of SQL Server-Related Topics on 8 March 2017

Automating DBCC PAGE – Part 3 (Is a Clustered Index physically sorted on disk?)

In several of my last few blog posts, I’ve shared several methods of getting internal information from a database by using the DBCC PAGE command and utilizing the “WITH TABLERESULTS” option to be allowed to automate this process for further processing. This post will also do this, but in… Read more

0 comments, 31 reads

Posted in A Discussion of SQL Server-Related Topics on 22 February 2017

T-SQL Tuesday #87 – Beware the Shiny New Toys

Today is yet another T-SQL Tuesday – the monthly blogging party started by Adam Machanic (b|t) to get everyone in the SQL Server blogosphere together and to blog about a topic. Today’s party is hosted by none other than Matt Gordon (b|t),… Read more

0 comments, 30 reads

Posted in A Discussion of SQL Server-Related Topics on 14 February 2017

Automating DBCC PAGE, part 2 – determining object names on pages

In a prior blog post, I demonstrated how using DBCC PAGE can be automated by using the “WITH TABLERESULTS” option. In this post, we will continue with another look at how this can be done.

On a nice wintry day, your city ended up being covered in several feet… Read more

0 comments, 29 reads

Posted in A Discussion of SQL Server-Related Topics on 18 January 2017

T-SQL Tuesday #86: Enhancement Requests

On the second Tuesday of each month, the SQL Server universe all comes together to blog about a topic. Known as T-SQL Tuesday and started by Adam Machanic (Blog | @AdamMachanic), this month’s T-SQL Tuesday topic is hosted by friend and fellow MCM Brent Ozar. The theme… Read more

0 comments, 29 reads

Posted in A Discussion of SQL Server-Related Topics on 10 January 2017

Windows Virtual Accounts and SQL Server

How SQL Server uses Windows Virtual Accounts and local groups

Managed Service Accounts (MSAs) and Virtual Accounts were introduced in Windows 7 / Windows 2008R2 (link). Installations of SQL Server 2012 and newer will utilize the Virtual Accounts. SQL Server 2008 / 2008R2 installations use a combination of… Read more

0 comments, 38 reads

Posted in A Discussion of SQL Server-Related Topics on 28 December 2016

Automating DBCC Page

Way back in 2006, Paul Randal documented DBCC PAGE on his Microsoft blog at http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/10/625659.aspx. In his post, you will notice that in order to return the output from DBCC PAGE to the screen, you need to enable trace flag 3604 first. The above blog post shows a few… Read more

0 comments, 29 reads

Posted in A Discussion of SQL Server-Related Topics on 21 December 2016

T-SQL Tuesday #85: Backup and Recovery

It’s that time of the month… the time when all of the T-SQL bloggers have a party and blog about a specific topic. Unfortunately, it’s been a few months since I’ve written a T-SQL Tuesday post. I’m hopeful that I can use this post to get back in the groove… Read more

0 comments, 30 reads

Posted in A Discussion of SQL Server-Related Topics on 13 December 2016

Persisting DBCC output data

Most of the DBCC commands return their results as textual output, even if you have SSMS configured to return result sets to a grid. This makes examining the output a manual process that is prone to errors. It sure would be nice if there was a way to return the… Read more

0 comments, 29 reads

Posted in A Discussion of SQL Server-Related Topics on 16 November 2016

The SQL Saturday Crazy Train hooks up a caboose!

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. And if there are a lot of questions, you may… Read more

0 comments, 414 reads

Posted in A Discussion of SQL Server-Related Topics on 20 July 2015

How do different types of functions compare performance wise?

A while back, I wrote a blog post showing the differences (including performance) between Inline Table-Valued Functions (ITVF) and Multi-Statement Table-Valued Functions (MSTVF). Since then, whenever I speak about ITVFs / MSTVFs, I’m frequently asked about how Scalar Functions (SF) perform. My stock answer has always been that they perform… Read more

1 comments, 449 reads

Posted in A Discussion of SQL Server-Related Topics on 16 July 2015

The Murder Train is pulling into Iowa City

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. And if there are a lot of questions, you may… Read more

0 comments, 336 reads

Posted in A Discussion of SQL Server-Related Topics on 11 May 2015

T-SQL Tuesday #61 – The Wrap-Up

Earlier this month, I hosted the 61st occurrence of the monthly TSQL-Tuesday blogging party. With a topic of “Giving Back”, it had a great turnout (27 party-goers). As I read through all of their posts, I noticed that many are planning to give back in pretty predictable ways… Read more

2 comments, 919 reads

Posted in A Discussion of SQL Server-Related Topics on 31 December 2014

TSQL Tuesday #61: How I plan on Giving Back

A little over 5 years ago, Adam Machanic (B|T) had this great idea of getting everyone in the SQL Community to all blog about a specific topic on the second Tuesday of the month. This monthly “blogging party” has a host, aka party organizer, that decides… Read more

0 comments, 443 reads

Posted in A Discussion of SQL Server-Related Topics on 9 December 2014

T-SQL Tuesday #61 – Giving Back

The Season of Giving

The annual PASS Summit (otherwise known as the #SQLFamily reunion) is over. Here in the United States, we have just finished celebrating Thanksgiving, where the average person consumes more calories in two hours than what they need for a week. And we are entering the season… Read more

23 comments, 6,079 reads

Posted in A Discussion of SQL Server-Related Topics on 2 December 2014

The Murder Train is making a stop in Salt Lake City

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. Recognizing this, last year my friend Jason Brimhall and I… Read more

0 comments, 395 reads

Posted in A Discussion of SQL Server-Related Topics on 16 October 2014

The Murder Train chugs into Denver!

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. Recognizing this, last year my friend Jason Brimhall and I… Read more

0 comments, 417 reads

Posted in A Discussion of SQL Server-Related Topics on 13 August 2014

T-SQL Tuesday #57: SQL Family and Community

Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. T-SQL Tuesday… that wonderful monthly blogging party started by Adam Machanic (Blog | @AdamMachanic). The intent is to get the entire SQL Community together on a monthly basis to blog about…

Read more

0 comments, 428 reads

Posted in A Discussion of SQL Server-Related Topics on 13 August 2014

Older posts