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

SQLAuthority News – Presented 3 Technical Session at Great Indian Developer Summit 2015

May 2, 2015

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Great Indian Developer Summit is my favorite technology event and I have been extremely happy to present technology sessions here for over 5 years. Just like every year, this year, I presented three technology session on SQL Server 2014. This time the event was at two locations. First one is Bangalore and the…

SQL AZURE – How to Disable and Enable All Constraint for Table and Database

May 1, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Azure

Recently I wrote blog to enable and disable all constraints in the database SQL SERVER – How to Disable and Enable All Constraint for Table and Database. One of my reader told me that this trick of sp_msforeachtable doesn’t work in Azure SQL Database (WASD). It is interesting that a lot…

SQL SERVER – Recovering from Snapshots – Notes from the Field #078

April 30, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, Snapshot, SQL Backup and Restore, SQL Scripts

[Note from Pinal]: This is a 78th episode of Notes from the Fields series. What do you do when data is deleted accidentally or you are facing disaster? Well, there are plenty of the things, you can do, but when in panic quite often people make mistakes which just intensify the disaster. Database snapshot…

SQL SERVER – Script: Knowing Data and Log Files Are On the Same Drive

April 29, 2015

Pinal Dave

SQL Tips and Tricks

GIDS, SQL Log, SQL Scripts, SQL Server

Last week it was wonderful to spend time at the GIDS conference to meet all the enthusiastic developers. Had fun preparing for the session and the number of people who walked to me and say they read this blog makes me really humble and motivated to write more. I love attending and presenting at these conferences because I get an opportunity to meet people and at many times able to answer real world problems. Let’s learn Script: Knowing Data and Log Files Are On the Same Drive.

SQL SERVER – Finding Tables with Primary or Foreign Keys

April 29, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts

If you want to know if a table has a primary key or foreign key, you can find out this in many ways. Let us create these tables CREATE TABLE product_master ( prod_id INT PRIMARY KEY, prod_name VARCHAR(100), price DECIMAL(12,2) ) GO CREATE TABLE product_details ( prod_id INT, sales_date DATETIME,…

Interview Question of the Week #017 – Performance Comparison of Union vs Union All

April 26, 2015

Pinal Dave

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

SQL Union clause, Union

Here is what I just learned from email. One of the very prestigious organization asks one of their candidate following questions – Question: If you have options to use Union or Union All – which one of the option will use keeping performance as a top most requirement for the query. Answer: Though…

SQL SERVER – Generate Different Random Number for Each Group Using RAND() Function

April 25, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Random

You know that RAND() function in SQL Server generates a random float value 0 through 1 (excluding 0 and 1). Let us create the following dataset CREATE TABLE #random(no INT) INSERT INTO #random(no) SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT…