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

Interview Question of the Week #052 – Print String in Reverse Order

January 3, 2016

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

Last week, I attended the last interview of the year. One of my co-interviewer asked a coding question to the candidate. In this type of question, the candidate is given one hour with SQL Server with a help file. The computer does not have internet candidate can use all the…

SQL SERVER – FIX: SQLServerAgent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022)

January 1, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Error Messages

Getting error and finding the cause is something which I like. And off late over the blogs I have shared a number of such incidents that have helped me figure out stuffs all by myself. Of course, I do my research and more often than not make things complicated because…

SQL SERVER – Are You Suffering from Unknown SSAS Performance Challenges? – Notes from the Field #109

December 31, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore, SSAS

[Note from Pinal]: This is a new episode of Notes from the Field series. We build our business application with zeal and enthusiasm. We believe it will do well for many years but it is not the case always. After a while performance started to go down and everything is not…

SQL SERVER – Unable to Start SQL Browser

December 29, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

My laptop is exposed to the internet and I have a passion to learn new software. Due to this, sometimes, I download some random software (unknowingly malware) on my machine and end up in infecting my laptop with a virus. These are never intentional. I think I have written earlier…

Geometry Datatype – Line String Behavior Enhancements

December 28, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

When I did the session at SQLPass about the 42 tips, I had included an interesting behavior I got when working with Geometry data types. When I was doing a session at a large SI location, one of the application developers walked up to me to say they were getting…

SQL SERVER – Script: Remove Spaces in Column Name in All Tables

December 26, 2015

Pinal Dave

SQL Tips and Tricks

SQL Column, SQL Scripts, SQL Server

Long time ago I have written blog to rename column name.
SQL SERVER – How to Rename a Column Name or Table Name
One of the reader asked me if I can provide a script to remove space from all column names for all tables in a database? My first reaction was – “Are you sure you want to do that? There are chances that after changing the name of the column, the application code might break. If the table has been referred in stored procedure or functions or other objects”

SQL SERVER – Getting to understand SQL Server Activity Monitor in SSMS

December 25, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

This site is flooded with blog posts around SQL Server Management Studio’s Activity Monitor capability. In fact, we have written few special case scenarios on how to use the same. In this blog post, I might not want to rehash the same, but take a stance on how I explained…