Tags » SQL Server

SQL SERVER - Steps to Generate Windows Cluster Log?

Every now and then I sit next to DBA to learn some of their tricks. One of this recent learning is what I plan to share here. 509 more words

SQL Authority

Why you shouldn't run sp_updatestats after you rebuild your indexes

Don’t run sp_updatestats after rebuilding your indexes. The sp_updatestats will use the default sample and you could end up with less accurate stats post sp_updatestats than you had after your index rebuild. 246 more words

Sql Server

FOR JSON Clause With AUTO mode In SQL Server 2016

Hi friends, in release of SQL Server 2016 CTP2 one of the feature that introduced is JSON clause.

So first question that comes in everyone’s mind is… 287 more words

Sql Server

Integrating Other Data Mining Tools with SQL Server, Part 2.1: The Minuscule Hassles of Minitab

By Steve Bolton

…………It may be called Minitab, but SQL Server users can derive maximum benefits from the Windows version of this professional data mining and statistics tool – provided that they use it for tasks that SQL Server doesn’t do natively. 4,524 more words

SQL Server

Nuevo curso introductorio “Consulta y construcción de bases de datos relacionales” en septiembre / octubre de 2015

¿Quieres aprender cómo se consultan y construyen bases de datos?

Se ofrece un nuevo curso “Consulta y construcción de bases de datos relacionales 479 more words

Curso Introductorio

SQL SERVER - Knowing the Source Application Using APP_NAME() Function

APP_NAME() function in SQL Server returns the application name of the current session in which it is called.

When you execute the following code

SELECT APP_NAME() AS application_name… 121 more words

SQL Authority

Novedades en la instalación de SQL Server 2016 CTP2.1

Buenas, el otro día hablábamos de la nueva CTP 2.1 de SQL Server 2016. Hoy vamos a ver que hay de nuevo en el asistente de instalación y que deberemos de tener en cuenta a la hora de instalar el producto. 345 more words

SQL Server