SQL Archives - Page 98 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Server Side and Client Side Trace

December 15, 2015

I don’t know where to start, I get to learn things from the most unusual of places. Most of the learnings is based on challenging the statuesque of our understanding. During my interactions with various DBAs one of the common misunderstanding is about server side and client side trace. One…

SQL SERVER – Fix SQL Server Index Fragmentation with dbForge Index Manager

December 14, 2015

Pinal Dave

SQL

Devart, SQL Index, SQL Scripts, SQL Server

You need to know SQL Server basics to keep database performance at the highest level. This knowledge will also help you to be prepared to any potential problems. When working with files, you may discover that there is not enough free space to store the required data in the file. By default, in such situations, SQL Server locks the file and extends it (it’s called – autogrow). Let us learn about SQL Server Index Fragmentation.

Interview Question of the Week #049 – Taking Database Offline

December 13, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Scripts

Here is the conversation which I observed the other day. Question: How do we take database off-line? Answer: Well, we can run following script to take the database offline. ALTER DATABASE [mydb] SET OFFLINE WITH ROLLBACK IMMEDIATE Question: Let us assume that your boss suggest that you should wait 30…

SQL SERVER – Discussion on understanding NUMA

December 12, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL CPU

At the SQLPass conference I have had the opportunity to meet a number of you and you folks have inspired me to learn and share after every trip to this conference. This year, I was fortunate to do a number of sessions this year too. Just the preparation for these…

SQL SERVER – Connecting to Azure SQL DB

December 11, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Azure

Learning new methods of working with SQL Server can always be challenging. I found the new learning coming my way while connecting to Azure SQL DB. I was confronted with an error and I was not sure where to start. So this blog is like a travel log of my…

SQL SERVER – InMemory Tables on SQL Azure DB

December 9, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In-Memory OLTP, SQL Azure, SQL Scripts

There have been tons of enhancements in the InMemory space with SQL Server 2016. I am due to write about them in this blog. Having said that, one of my DBA friend asked me based on the Pluralsight course on SQL Server 2014 Administration – Does SQL Azure support InMemory…

SQL SERVER – Free Database Search and Dependency Analysis

December 8, 2015

Pinal Dave

SQL

ApexSQL

This article covers the main features of ApexSQL Search, a free SQL Server Management Studio and Visual Studio add-in for SQL Server database object and text searching and for dependency analysis. Let us learn about Free Database Search and Dependency Analysis.