Sites anglophones


The DBA’s Essential Index Monitoring and Maintenance Tasks

Publié le 15 février 2016 sur sqlservercentral.com
 

Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success.

GROUPBY vs SUMMARIZE in #dax #powerbi #powerpivot

Publié le 15 février 2016 sur sqlblog.com
 

If you are using Power BI Desktop or Power Pivot in Excel 2016, you should learn when and how you can use GROUPBY instead of SUMMARIZE. The SUMMARIZE function is very powerful and internally very complex, so it’s easy to find scenarios where you …

SQL SERVER – Showplan Additions for ColumnStore Indexes

Publié le 15 février 2016 sur journey to sqlauthority
 

The last time when I wrote about ColumnsStore FAQ, one of the readers had an interesting question. The question was around how to identify the traits of using a column store inside an execution plan. The very thought got me thinking. I was thinking whe …

Using Apache Zeppelin on SQL Server

Publié le 14 février 2016 sur sqlblog.com
 

At the beginning of February I started an exploratory project to check if Apache Zeppelin could be easily extended in order to interact with SQL Server and SQL Azure. In the last week I’ve been able to have everything up an running. Given that I …

Interview Question of the Week #058 – What is the Difference Among DECIMAL, FLOAT and NUMERIC?

Publié le 14 février 2016 sur journey to sqlauthority
 

Question: What is the Difference Among DECIMAL, FLOAT and NUMERIC? Answer:  The basic difference between Decimal and Numeric : They are the exact same. Same thing, different name. The basic difference between Decimal/Numeric and Float : Float …

SQL SERVER – FIX: Error: 18456, Severity: 14, State: 58. Login failed for user

Publié le 13 février 2016 sur journey to sqlauthority
 

One of the most common and searched SQL Server failure is around “Logins”. Login failed for user has always been tricky and interesting to troubleshoot. I don’t think there is a silver bullet to easily troubleshoot the same. With ever …

Your Data’s Rate of Decay

Publié le 12 février 2016 sur sqlmag.com
 

Did you know that data has a half-life? That is the amount of time it takes for the information in your database to go bad. How? Because contact data is always changing. SQL Server Pro Guest Blogs read more

[Video] Office Hours 2016/02/10

Publié le 12 février 2016 sur brentozar.com
 

In this week’s Office Hours Q&A, the whole team shows up – but Doug is the invisible man. We answer questions about hot-add CPU and memory, whether to sync jobs across Availability Group replicas, and how you get a single query to …

Moved to the Cloud?

Publié le 12 février 2016 sur sqlservercentral.com
 

Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the …

Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

Publié le 12 février 2016 sur sqlservercentral.com
 

If you’ve ever wondered if you can do better than an INDEX SCAN when you do a LIKE « %string% » search, read on…

SQL SERVER – Huge Transaction log (LDF) for Database in Availability Group

Publié le 12 février 2016 sur journey to sqlauthority
 

One of my blog readers posted on Facebook: Hi Pinal, We are using AlwaysOn availability group for our production database. The database is fairly large in size as its around 260 GB.  The database transaction log file grows around 2.5gb every day. …

Logical Query Processing: The FROM Clause and Joins

Publié le 11 février 2016 sur sqlmag.com
 

Last month I provided an overview of logical query processing. I explained that this term represents the logical interpretation of a query. I provided a sample database called TSQLV4, two sample queries that I referred to as simple sample query and com …

The Top 4 Job Tasks DBAs Forget

Publié le 11 février 2016 sur brentozar.com
 

It’s easy to get caught up in daily incidents, tickets, and special projects. Like a good scout, though, a core task in a DBA’s job is to be prepared. You have to set time aside in your schedule to: 1. Practice responding to corruption. Gai …

SQL Server 2016 Row Level Security Block and Filter Predicates Example

Publié le 11 février 2016 sur sqlservercentral.com
 

Rajendra Gupta takes a look at the additional enhancements made to Row Level Security in SQL Server 2016 CTP 3.1 and explores the new features with examples.

Redgate Cloud Research

Publié le 11 février 2016 sur sqlservercentral.com
 

Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the …


Pages :