Category: News

PayPeriod II

PayPeriod Matching lesson learned.

Jason BrimhallPosted on February 13, 2010Categories News, ProfessionalTags script, ScriptsLeave a comment on PayPeriod II

Relationships

This month Rob Farley is hosting TSQL-Tuesday #3. The topic is Relationships and he has left it wide open for interpretation so long as it can be tied to the theme and SQL Server. At […]

Jason BrimhallPosted on February 8, 2010July 3, 2019Categories News, ProfessionalTags Relationships, TSQL Tuesday2 Comments on Relationships

Log is Filling Up

Paul Randal transaction script.

Jason BrimhallPosted on February 4, 2010July 3, 2019Categories News, ProfessionalTags Scripts, SQL, Transaction LogLeave a comment on Log is Filling Up

Key Discovery III

Recursively traverse system views to build a Hierarchical Perspective into the database.

Jason BrimhallPosted on February 1, 2010July 11, 2019Categories News, Professional, Scripts, SSCTags Documentation, FK Hierarchy, Foreign Key, Hierarchy, Primary Key, Scripts, SQL2 Comments on Key Discovery III

I just found out that Michelle Ufford (@sqlfool) has updated her Index Defrag scripts. Right now she is looking for Beta testers. Anybody that is interested could find more info at: http://sqlfool.com/2010/01/index-defrag-script-updates-beta-testers-needed/

Jason BrimhallPosted on January 26, 2010Categories News, Professional, ScriptsTags clustered index, defrag, Index, ScriptsLeave a comment on SQLFool IDX Defrag Scripts

Tweeting – I took the Dive.

In a previous post, I questioned how much Twitter could really do for me. After some comments made, and some other blog posts that I have read – I decided to take the dive. Andy […]

Jason BrimhallPosted on January 25, 2010July 17, 2019Categories Blogging, News, Professional1 Comment on Tweeting – I took the Dive.

Indexes Out the Window II

In Part I, I discussed some of the peculiarities and troubleshooting done in relation to a peculiar execution plan. In this post, I will discuss some of what I did to further tune the query. […]

Jason BrimhallPosted on January 25, 2010January 25, 2010Categories News, ProfessionalTags clustered index, Execution Plans, Index, SQL1 Comment on Indexes Out the Window II

Indexes Out the Window

I ran into a peculiarly puzzling situation with a query I have been tuning of late. The query runs some aggregations and performs a range scan based on a date value passed to the query. […]

Jason BrimhallPosted on January 22, 2010Categories News, ProfessionalTags clustered index, Execution Plans, Index, SQL1 Comment on Indexes Out the Window

PayPeriod Matching

Recently I was asked to alter a report to pull different more meaningful data. The particular report was pulling data from the datawarehouse. It had been recently modified to use a stored procedure (and subsequently […]