Curious Case of SUM Function
How a simple SUM statement could change an output.
SQL SERVER – Puzzle – Write a Shortest Code to Produce Zero
Puzzle: Write a Shortest Code to Produce Zero. It has been a long time since we have puzzle on this blog. So I have decided to post this puzzle. You have to write a shortest code which produces digit 0 (zero). If you think this puzzle is easy, it …
ColumnStore Indexes: Rowgroup Elimination and Parameter Sniffing In Stored Procedures
Yazoo Over on his blog, fellow Query Plan aficionado Joe Obbish has a Great Post, Brent® about query patterns that qualify for Rowgroup Elimination. This is really important to performance! It allows scans to skip over stuff it doesn’t need, …
The SQL Server Features that Time Forgot
SQL Server has been, if nothing else, an evolving data platform, full of features that come and go like celebrity headlines. With each release, components get added, removed, enhanced, forgotten. Many shine bright and stay that way. Others burn out lon …
Installing SQL Server Agent on SUSE Linux
Manvendra Singh explains how to install SQL Server Agent on SUSE Linux server, so that you can create SQL Server Jobs to schedule repetitive work.
SQL SERVER – Learning DATEDIFF_BIG Function in SQL Server 2016
One of the T-SQL functions introduced in SQL Server 2016 is DATEDIFF_BIG function. In older versions there is a limit on the return value of DATEDIFF function. The return datatype of INT and the maximum it can have the value 2147483647. It will not ret …
PASS Summit is back! Discover the edition 2017!
The PASS Summit is back! The most important event around the world on Microsoft Data Platform will be held again in Seattle (WA) from October 31 to November 3, 2017 and it will be preceded from two « pre-conference » at October 30th and 31th.Every y …
Upgrading SQL Server– SQL Server Support Dates
One valid argument for considering a SQL Server upgrade sooner rather than later is the fact that the version(s) of SQL Server you are using in Production may be out of mainstream or even extended support. But what does that mean exactly? It does NOT m …
Register Now for Next Friday’s Free GroupBy Conference
It’s that time again! Register for free now to attend next Friday, September 1. Here’s the lineup: 8AM Eastern – Why Defragmenting Your Indexes Isn’t Helping – Brent Ozar (@BrentO – BrentOzar.com) 10AM – How to …
How to Find Out Which Database Object Got Deleted
Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.
Load Extended Events via Powershell
Learn how you can load Extended Events with PowerShell, nice and fast.
SQL Authority News – Community Hub by Redgate
It is not possible that readers of SQLAuthority.com are not aware of the amazing tools built by Redgate. We all know that Redgate builds tool which makes SQL DBA and Developer’s life easier. We can eliminate human errors and improve our …
Upgrading SQL Server– Database Compatibility Levels
One important factor to contemplate during an upgrade and migration effort are your database compatibility levels, which control certain database behaviors to be compatible with a particular version of SQL Server. Unlike the database file version (whic …
SQL 101 Learn SQL. Not too much. Mostly online.
I’ve had people ask me how to learn SQL without installing a database. This past Sunday afternoon I saw a packed class of current and aspiring data scientists learn SQL in a great class taught by Ted Petrou . You can indeed learn SQL for free wit …
SQL Server 2017: Potentially Interesting New Extended Events
You still won’t use them And I predict that Extended Events will remain as niche-only use for specific troubleshooting scenarios. Very few monitoring tools use them, and the ones that do still rely on traces and DMV queries for the bulk of their …