Sites anglophones


Curious Case of SUM Function

Publié le 24 août 2017 sur sqlservercentral.com
 

How a simple SUM statement could change an output.

SQL SERVER – Puzzle – Write a Shortest Code to Produce Zero

Publié le 24 août 2017 sur journey to sqlauthority
 

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

Publié le 23 août 2017 sur brentozar.com
 

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

Publié le 23 août 2017 sur simple-talk.com
 

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

Publié le 23 août 2017 sur sqlservercentral.com
 

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

Publié le 23 août 2017 sur journey to sqlauthority
 

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!

Publié le 22 août 2017 sur sqlblog.com
 

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

Publié le 22 août 2017 sur sqlskills.com - glen berry
 

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

Publié le 22 août 2017 sur brentozar.com
 

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

Publié le 22 août 2017 sur sqlservercentral.com
 

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

Publié le 22 août 2017 sur sqlservercentral.com
 

Learn how you can load Extended Events with PowerShell, nice and fast.

SQL Authority News – Community Hub by Redgate

Publié le 22 août 2017 sur journey to sqlauthority
 

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

Publié le 21 août 2017 sur sqlskills.com - glen berry
 

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.

Publié le 21 août 2017 sur sqlblog.com
 

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

Publié le 21 août 2017 sur brentozar.com
 

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 …


Pages :