SQL Tips and Tricks Archives - Page 91 of 536 - SQL Authority with Pinal Dave

SQL SERVER – System Objects Not Visible in SQL Server Management Studio

June 8, 2016

SQL Server, SQL Server Management Studio, System Object

There are so many settings in SQL Server Management Studio that it can sometimes make someone nervous. Once of my client sent me email telling that something is not right with their SQL Server 2016 installation. Here is an email which I received:

Hi Pinal,
One of the developer has installed SQL Server 2016 on our development environment. I already had SQL Server 2014 running on the server. I am seeing a strange behavior in SQL Server Management Studio. When I connect from SSMS 2014, I am seeing system views as you can see below.

SQL SERVER – Vertical Select Mode feature in SQL Server Management Studio

June 6, 2016

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server 2012, SQL Server Management Studio

During last SQL Bangalore user group meeting, Balmukund presented a surprise session of tips and tricks with SQL Server Management Studio. Even though I was not able to attend the event due to travel abroad, I contacted Balmukund to share what he presented.

He was kind enough to give me a list. One of the things which I didn’t know was the usage of vertical block select mode. I have been using block select mode to cut the text by selecting it. This needs a mouse and I found that there is no keyboard shortcut.

SQL SERVER – Maintain Carriage Return (Enter Key) in SQL Server 2016 Management Studio While Copy and Paste

June 3, 2016

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server 2016, SQL Server Management Studio, SQL String, SSMS

With every new release some of the default behavior can surprise because you are so much used to them. But when they don’t behave the same, it baffles to when some of these changes were introduced. In pursuit of finding such behavior, while I was working with SQL Server 2016 Management Studio, I was surprised to see a behavior which didn’t seem to be right. You can also try it too.

SQL SERVER – SSMS Tip: How to Get Larger Fonts for Results in Grid Output

May 31, 2016

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio

A couple of weeks back, I was at the GIDS (Great Indian Developer Conference) speaking on my favorite topic of performance. Often as a speaker I make sure I attend a couple of sessions from friends or from people in the industry to learn something completely new. It is easier to learn from someone who has done all the hard work of doing research compared to investing that time all by yourself to learn the nuances of the topic. Let us learn about SSMS Tip.

SQL SERVER – Why DBAs Need to Know about Kerberos – Notes from the Field #126

May 26, 2016

Pinal Dave

SQL Tips and Tricks

Notes from the Field, SQL Function, SQL Server Security

Not everyone knows about Kerberos. Many think it is a two headed dog from mythology, well that is true but when we talk about database,

SQL SERVER – What is Trace Flag – An Introduction

May 23, 2016

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, TraceFlags

Last week I published below blog where I talked about a trace flag. Backup Randomly Failing with Error 112 (There is not enough space on the disk.) One of the reader commented, whether he needs to enable trace flag every time SQL Server is restarted?

SQL Server 2016 – Introducing AutoGrow and Mixed_Page_Allocations Options – TraceFlags

May 21, 2016

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server 2016, TraceFlags

I have been playing around with SQL Server 2016 for a while now and I have seemed to have learnt a number of interesting options when playing around with the new version. One of the readers after reading – SQL Server 2016 – Enhancements with TempDB asked me if the option of TraceFlags of 1117 and 1118 not available when working with user defined normal databases. This was a valid and appropriate question for sure. I was not sure where to start. Let us see traceflags related to AutoGrow and Mixed_Page_Allocations.