Get details of SQL Server Database Growth and Shrink Events

SQL Shack

Overview of Default trace in SQL Server Starting from SQL Server 2005, SQL Server captures a few critical events in the default traces. […]. It is essential for the DBA to need to ensure the SQL Server database performance. Performance tuning is an open-ended task, and you need to ensure the monitoring of various database parameters. DBAtools Monitoring Reports

Faster remainders when the divisor is a constant: beating compilers and libdivide

Daniel Lemire

In some instances, libdivide can even be more efficient than compilers because it uses an approach introduced by Robison (2005) where we not only use multiplications and shifts, but also an addition to avoid arithmetic overflows. Not all instructions on modern processors cost the same. Additions and subtractions are cheaper than multiplications which are themselves cheaper than divisions. For this reason, compilers frequently replace division instructions by multiplications.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Joining the SpeedCurve team

Speed Curve

I started coding web pages in about 2005 and began my web development career in Moscow, Russia, joining a biotech startup.

Performance Tuning Re-indexing and Update Statistics – A Case Study

SQL Server Performance

Reporting Server Configuration Details: SQL Server Version: SQL Server 2005 […]. Recently we started experiencing a very strange issue in our production reporting environment where the Re-indexing and Update Statistics operation suddenly began taking more than 2 days to complete and was thus causing blockage in the database which in turn caused impairment in application performance. General DBA Performance Tuning index re-indexing Update Statistics

Deprecated features to take out of your toolbox – Part 1

SQL Performance

The system table sys.sysprocesses was replaced way back in SQL Server 2005 by a set of dynamic management views (DMVs), most notably sys.dm_exec_requests

The day that I gave the founder of Tesla a ride in my Lotus Elise in return for a ride in his…

Adrian Cockcroft

The Lotus Elise wasn’t imported by Lotus until 2005, so I had one of just a handful of these cars in the USA for several years. The day that I gave the founder of Tesla a ride in my Lotus Elise in return for a ride in his T-Zero prototype My Elise at a track day?—?Laguna

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

As ​​ the ​​ administrator of a SQL Server 2005 installation, ​​ you will find that ​​ visibility into ​​ the ​​ SQL Server ​​ I/O ​​ subsystem ​​ has been ​​ significantly increased. ​​ SQL Server ​​ copy-on-write actions are used to maintain snapshot databases in SQL Server 2005.

The Amazing Evolution of In-Memory Computing

ScaleOut Software

Software platforms for distributed caching, such as ScaleOut StateServer ®, which was introduced in 2005, hide internal mechanisms for cluster membership, throughput scaling, and high availability to take full advantage of the cluster’s scalable memory without adding complexity to applications. From Distributed Caches to Real-Time Digital Twins.

The Amazing Evolution of In-Memory Computing

ScaleOut Software

Software platforms for distributed caching, such as ScaleOut StateServer ®, which was introduced in 2005, hide internal mechanisms for cluster membership, throughput scaling, and high availability to take full advantage of the cluster’s scalable memory without adding complexity to applications. From Distributed Caches to Real-Time Digital Twins.

15 Remote Working Tips From Experience

Testsigma

According to an article published by smallbizgenius , in 2019, the number of people who work from home has increased by 140% since 2005. Remote work has been steadily gaining popularity for some years now. Now, most of the population is working from home. For most of the companies that had not adapted work from home before, this time has been an eye-opener. Many companies including the big ones like Twitter, Barclays, Mondelez are allowing employees to continue work from home indefinitely.

Why Waits Alone Are Not Enough

SQL Performance

Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006. "Waitstats helps us identify performance-related counters. But waits information by itself isn't enough to accurately diagnose performance problems.

Back-to-Basics Weekend Reading - A Decomposition Storage Model

All Things Distributed

in 2005. Traditionally records in a database were stored as such: the data in a row was stored together for easy and fast retrieval. Not everybody agreed that the "N-ary Storage Model" (NSM) was the best approach for all workloads but it stayed dominant until hardware constraints, especially on caches, forced the community to revisit some of the alternatives.

Fundamentals of table expressions, Part 5 – CTEs, logical considerations

SQL Performance

T-SQL supports it starting with SQL Server 2005. This article is the fifth part in a series about table expressions. In Part 1 I provided the background to table expressions. In Part 2 , Part 3 , and Part 4 , I covered both the logical and the optimization aspects of derived tables.

C++ 105

Data Mining Problems in Retail

Highly Scalable

Retail is one of the most important business domains for data science and data mining applications because of its prolific data and numerous optimization problems such as optimal prices, discounts, recommendations, and stock levels that can be solved using data analysis methods.

Retail 135

NServiceBus now supports Microsoft Extensions DependencyInjection

Particular Software

StructureMap and Castle Windsor were released in 2004, Spring.NET in 2005, and more after that, each with their own unique API, some more opinionated than others. The history of dependency injection (DI) containers in.NET is almost as long as.NET itself. And yet each of these libraries fulfills a fairly simple task: a place to hold on to dependencies so that objects can get them when they need them.

Overlooked T-SQL Gems

SQL Performance

Since the inception of the OUTPUT clause for modification statements in SQL Server 2005, it turned out to be a very practical tool whenever you wanted to return data from modified rows. My good friend Aaron Bertrand inspired me to write this article. He reminded me of how sometimes we take things for granted when they seem obvious to us and don't always bother checking the full story behind them.

C++ 87

Top 8 Best Backend Frameworks

KeyCDN

Features Simple and fast routing engine Comes with its own CLI Powerful template system (Blade) Good documentation CakePHP CakePHP is one of the first PHP frameworks to be released back in 2005. There are a myriad of options available when choosing which backend framework you want to work with. Although each backend framework comes with its own set of pros and cons, there are also a few other factors you’ll want to take into consideration before making a final decision.

Does SQL Server 2016 Require Trace Flag -T8048?

SQL Server According to Bob

Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. Various changes from automatic soft NUMA to CMemThread partitioning have muddied the water around the trace flag –T8048 messaging. Prior to SQL Server 2016 the trace flag –T8048 is used to upgrade (only) NUMA partitioned, CMemThread objects to CPU partitioned based objects.

Azure 40

An Album for Each Year - 2012 Version - All Things Distributed

All Things Distributed

2005: Fiona Apple , Extraordinary Machine. I might have picked Fiona Apple again, but she already has a 2005 spot. All Things Distributed. Werner Vogels weblog on building scalable and robust distributed systems. An Album for Each Year - 2012 Version. By Werner Vogels on 22 December 2012 06:00 PM. Permalink. Comments (). About 5 years ago I joined a challenge to list "a favorite album for every year of your life."

Dynatrace lists on the NYSE

Dynatrace

From our origins in 2005, we quickly established ourselves as a leader in APM. Dynatrace news. Today marks a special moment for Dynatrace as we list on the New York Stock Exchange under the symbol “DT.” This event marks a significant moment in time, but we are not just focused on today, it is the foundation that we have built for success tomorrow that is even more exciting. I’m proud to share this moment with our 2,000+ Dynatracers.

SQL 2016 – It Just Runs Faster Announcement

SQL Server According to Bob

“SQL Server 2016 running on the same hardware as SQL Server 2014, 2012, 2008, 2008 R2 or 2005 uses fewer resources and executes a wide range of workloads faster. SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence.

AWS EC2 Virtualization 2017: Introducing Nitro

Brendan Gregg

It's amazing to recall that it was even possible to virtualize x86 before processors had hardware-assisted virtualization (Intel VT-x and AMD-V), which were added in 2005 and 2006. Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud.

Service Workers can save the environment!

Dean Hume

Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. The title of this article might seem like clickbait - but bear with me. Using service workers can actually reduce the amount of energy that users that visit your website consume. I may have lured you in with the false pretence of saving the environment….but

Service Workers can save the environment!

Dean Hume

Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. The title of this article might seem like clickbait - but bear with me. Using service workers can actually reduce the amount of energy that users that visit your website consume. I may have lured you in with the false pretence of saving the environment….but

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

CSA ISO/IEC 9945-1:2005 (R2009) 3.375 Synchronized I/O Data Integrity Completion. Refer to the ISO documentation on file integrity for complete details: CSA ISO/IEC 9945-1:2005 (R2009) 3.376 Synchronized I/O File Integrity Completion. Overview. SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2.

Linux Load Averages: Solving the Mystery

Brendan Gregg

The oldest change in the entire Linux repo dates back to 2005, when Linus imported Linux 2.6.12-rc2, and this change predates that. Load averages are an industry-critical metric – my company spends millions auto-scaling cloud instances based on them and other metrics – but on Linux there's some mystery around them. Linux load averages track not just runnable tasks, but also tasks in the uninterruptible sleep state. I've never seen an explanation.

The 2-second Website

MachMetrics

Obviously, you don’t need to make your website look like it’s from 2005. If you asked the average internet user how slow a website would need to load before they gave up and left, they might say something like 8 or 10 seconds.

XPath in Javascript: Predicates and Compounds

Tim Kadlec

Let’s say you have a calendar of events, and all you want to retrieve all the events that occurred between 2005 and 2007. Getting all the year spans where the value is between 2005 and 2007 is easy. 2005]. >=2005 and. ’ operators versus the ‘ ’ operators because we want to also return values in the years 2005 and 2007. Welcome to the second part of my look at XPath and how it can be used in Javascript.

Code 40

Inspired Design Decisions: Bea Feitler, An Unstoppable Creative Force

Smashing Magazine

The result was a cover which went on to win the New York Art Director's Club medal and was placed at number fifteen in the American Society of Magazine Editor’s 2005 list of Top 40 Magazine Covers. Inspired Design Decisions: Bea Feitler, An Unstoppable Creative Force. Inspired Design Decisions: Bea Feitler, An Unstoppable Creative Force. Andrew Clarke. 2019-10-03T14:30:59+02:00. 2019-10-03T13:18:03+00:00.

Are Microservices to Ecosystems as Core Competencies were to Conglomerates?

The Agile Manager

The ecosystem strategy takes this even further, combining unrelated capabilities under one roof (eBay buying Skype in 2005, SAP developing HANA in 2010, Facebook buying Oculus in 2014), often justifiable if only because digital commerce is still in its infancy and nobody is really sure what's going to work and what's not. As far back as the 19th century, industrial firms pursued vertical integration strategies.

No Server Required - Jekyll & Amazon S3 - All Things Distributed

All Things Distributed

I have regenerated all pages since 2005, the pages before that can be found in the "/historical" section. All Things Distributed. Werner Vogels weblog on building scalable and robust distributed systems. No Server Required - Jekyll & Amazon S3. By Werner Vogels on 17 August 2011 11:40 AM. Permalink. Comments (). As some of you may remember I was pretty excited when Amazon Simple Storage Service (S3) released its website feature such that I could serve this weblog completely from S3.

AWS 87

Death to Captchas

Tim Kadlec

Back in 2005, the W3C pointed out that third party services had demonstrated that most captcha services could be defeated with 88%-100% accuracy by using some simple OCR. A brief exchange on Twitter led me to think about one of the things I most definitely do not love about the internet—captchas.

Hats Off To Opera

Tim Kadlec

Acid 2 came around in April of 2005 and tested for support for things like HTML, CSS2.x Well that didn’t take long. It was just announced today that Opera’s developers have received the first 100 ⁄ 100 test score on the new Acid 3 test. There is apparently a small rendering glitch they still need to take care of, but this is really incredible progress considering the test was just formally announced on March 3rd.

Digital Squalor

The Agile Manager

A contract from 2005 between one firm and another is a binding legal document in the context of that relationship. In the not too distant past, storage was limited and expensive. As recently as 1980, 1 megabyte of disk storage cost $200. But this is no longer the case. Today, you can buy 8,000 megabytes (a.k.a. 8 gigabytes) for $1.