Using OFFSET for Paging
Paging is a common query that developers will use when retrieving results from a table. Often an application may want to display 10 or 20 results, knowing there might be 100 or more. The first request could be using just the top 10, with subsequent req …
SQL Productivity with SQL Prompt
The post SQL Productivity with SQL Prompt appeared first on SQLServerCentral.
Updated sys.dm_os_waiting_tasks script to correctly parse nodeId
I realized that I’d fixed an issue with my sys.dm_os_waiting_tasks script to correctly parse out the parallelism nodeId from the resource_description column (as newer versions include more info after the nodeId=X info) but I never blogged th …
New Pluralsight exam prep course: SQL Server: Understanding Database Fundamentals (98-364)
Tim’s latest Pluralsight course has been published: SQL Server: Understanding Database Fundamentals (98-364). It’s just over 2 hours long, and from the course description: It is very common for databases to be part of a compa …
Other Data People are Getting Ahead of You.
The next time you need to look for a job, I’ve got some bad news for you. A lot of other people are gonna stand out from the crowd and get way, way ahead of you in the line. They’ve learned how to save their companies money. They’ve l …
SQL SERVER – Using NEWID vs NEWSEQUENTIALID for Performance
I really like my work as every single day I get to see different SQL Server and new interesting problems to solve when I work with Comprehensive Database Performance Health Check. Recently, while working with a client we noticed that they have a huge i …
Splitting a SQL Server Table Over Multiple Files
The post Splitting a SQL Server Table Over Multiple Files appeared first on SQLServerCentral.
57% of Your Bosses Are Cheap. (Well, maybe 100% of your boss in particular.)
You know what I’ve noticed about companies? Some companies buy tools for you, but they just don’t have a training budget. They believe they hired you to solve problems, and you should have come with the knowledge to get your job done …
SQL Server Performance Tuning Recorded Class – 40% Discount for 4 Days
I have been blogging on SQLAuthority.com for almost 13 years. Well, to be honest, I will be completing the 13th year on November 1, 2019. I did my very first blog post on November 1, 2006, and since that day, I have been pretty much blogging every sing …
Oops, I deleted that data
We all have these days as a DBA, hopefully they are few and far between for most of us. This morning I walked into the office and found a stack of emails saying that a developer had responded to a support ticket and modified the values in one of …
Planning for SAP HANA Deployments in Public Cloud Environments
The post Planning for SAP HANA Deployments in Public Cloud Environments appeared first on SQLServerCentral.
Understanding Auctions
In spite of the fact that they don’t get much attention in basic economics classes, we live in a world where we are subject to auctions almost constantly. It’s not just getting something on eBay or other auction sites, but it’s how ma …
Recreating Databases from Scratch with SQL Change Automation
The post Recreating Databases from Scratch with SQL Change Automation appeared first on SQLServerCentral.
Your Data Career is Stuck in a Rut.
You haven’t really grown as a data professional this year. You’re kinda floating along in your database career, reading blogs, attending webcasts now and then. Maybe you’ll hit a SQL Saturday this year, but … you don’t re …
SQL SERVER – Getting Second Row from Table
The other day during one of my old clients sent me an email about if I know any trick to get the second row from the resultset. I know why he was asking this question as I had worked with him before Comprehensive Database Performance Health Check.Let u …