Sites anglophones


Should I Type * or 1 With the EXISTS Logical Operator

Publié le 24 avril 2017 sur sqlservercentral.com
 

In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM…)). They are « * », « 1 » and even « TOP 1 1 » or « TOP 1 * ». The aim of this article to give a good explanation which option is the best.

24 Hours of PASS (May 2017) – Data Security and Data Quality Edition

Publié le 24 avril 2017 sur sqlblog.com
 

Why can we say that SQL Server is the least vulnerable database system for the last seven years? Find it out from May 03 to 04, 2017 at the 24 Hours of PASS « Data Security and Data Quality » edition.  This series of one hour sessions will …

SQL SERVER – FIX : Msg 8115, Level 16, Arithmetic Overflow Error Converting IDENTITY to Data Type INT

Publié le 24 avril 2017 sur journey to sqlauthority
 

One of my friends who is a SharePoint expert told that he is getting overflow error while doing check-in on the document. He was confident that the error is related to SQL and that’s why he contacted me. I used profiler and found the table which …

Why SELECT HOST_NAME() Returns Empty String? – Interview Question of the Week #119

Publié le 23 avril 2017 sur journey to sqlauthority
 

Question: Why SELECT HOST_NAME() Returns Empty String while connected from certain .net application? Answer: This is a very popular question I have observed in the recent time. Before I answer this question, I have to be honest here. When I was as …

SQL Server vNext: query_store_wait_stats

Publié le 22 avril 2017 sur brentozar.com
 

The missing link Back when the Query Store first got announced, I was amazed. The amount of information it gathered and persisted between reboots was such a big improvement over the plan cache, plus being able to force plans was really cool. I was alwa …

SQL SERVER – FIX: Msg 3132, Level 16 – The Media Set has 2 Media Families but Only 1 are Provided. All Members Must be Provided

Publié le 22 avril 2017 sur journey to sqlauthority
 

This blog is a response to a comment on our blog. Have you ever encountered below error related to media set? Msg 3132, Level 16, State 1, Line 15 The media set has 2 media families but only 1 are provided. All members must be provided. Msg 3013, Level …

Generating HTML from SQL Server Queries

Publié le 21 avril 2017 sur simple-talk.com
 

Can you produce HTML from SQL? Yes, very easily. Would you ever want to? I certainly have had to. The principle is very simple. HTML is really just a slightly odd dialect of XML that imparts meaning to predefined tags. SQL Server has built-in ways of o …

SQL Server 2017: Unpublished Gems

Publié le 21 avril 2017 sur brentozar.com
 

Sneaky, sneaky, sneaky Release notes never seem to tell the full story, do they? At some point, you have to take matters into your own hands and go hunting for, as Paul Harvey would say, “The Rest Of The Story”. So what did I find? New stuf …

SSIS Training–SQLSkills Immersion Event on Learning SSIS (IESSIS1) 2-6 Oct 2017

Publié le 21 avril 2017 sur sqlblog.com
 

I’m honored to deliver the Immersion Event on Learning SQL Server Integration Services – IESSIS1 – in Chicago next week (24-28 Apr 2017). The April class sold out! Paul and Kimberly tell me there are already folks on the waiting list …

Stairway to Columnstore Indexes Level 2: Columnstore Storage

Publié le 21 avril 2017 sur sqlservercentral.com
 

To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore …

SQL SERVER – Service Pack Error – Index (Zero Based) Must be Greater Than or Equal to Zero and Less Than the Size of the Argument List

Publié le 21 avril 2017 sur journey to sqlauthority
 

Recently I came across an issue where I was not able to fix directly. My client reported below error in Skype, which is related to a service pack.  Overall summary: Final result: The patch installer has failed to update the shared features. To det …

SQLskills SQL101: Using DDL Triggers

Publié le 20 avril 2017 sur sqlskills.com - glen berry
 

Over the past couple of months, SQLskills has embarked on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that we often see done incorrectly, technologies used the wrong way, or wh …

SQLskills SQL101: Restoring to an earlier version

Publié le 20 avril 2017 sur sqlskills.com - paul randall
 

As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that we often see done incorrectly, technologies used t …

SQL Server vNext: Quick Rundown

Publié le 20 avril 2017 sur brentozar.com
 

ICYMI Playing with SSMS in the lab Microsoft released CTP 2 of SQL Server vNext (well, yesterday today, but who knows when this thing will hit?). There’s some great new stuff in the Engine in this release that I’m just crazy about getting t …

New course: Understanding and Using Azure SQL Database

Publié le 20 avril 2017 sur sqlskills.com - paul randall
 

And to coincide with our new training class on Azure, we’ve just published a new Pluralsight course on Azure too! Tim’s latest Pluralsight course – SQL Server: Understanding and Using Azure SQL Database – and …


Pages :