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

Geometry Datatype – Line String Behavior Enhancements

December 28, 2015

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…

SQL SERVER – Error and Fix for Msg 1907 Cannot recreate index The new index definition does not match the constraint being enforced by the existing index

December 22, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

ColumnStore Index, SQL Error Messages

This particular blog post is around usage of Clustered ColumnStore Indexes and how one of my customer in a recent conversation brought this up to my notice. They were on SQL Server 2012 and were upgrading to SQL Server 2014 and were very much interested in the usage of Clustered…

SQL SERVER 2016 – New T-SQL Functions – COMPRESS – DECOMPRESS

December 21, 2015

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server, SQL Server Security

With every release of SQL Server, Microsoft has been adding enhancements to the product. Earlier I have written below blogs talking about new features/enhancements. Now I will write about features for SQL Server 2016 which are COMPRESS – DECOMPRESS.

Interview Question of the Week #050 – Query to Retrieve Second Highest Salary of Employee

December 20, 2015

Pinal Dave

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

There are some questions which never gets old and I keep on seeing them again and again every time I participate in the interview to help hire qualified Developers and DBA. Here is another popular question which I often see. Question: Write a query to retrieve Second (or Nth) highest…

MySQL – Date and Time Related System Functions

December 19, 2015

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

MySQL supports lot of functions to get current date and time. The following are some of the system functions. There are two functions to get current date SELECT curdate(),current_date(); There are two functions to get current time SELECT curtime(),current_time(); There are two functions to get current date along with time…