SQL Scripts Archives - Page 261 of 318 - SQL Authority with Pinal Dave

SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle

December 10, 2008

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

In the recent time of recession my company is able to continue its progress and we are hiring. It is very surprising to me that many developers who have experience with SQL Server could not get following simple question right. There were nearly 40 candidates I interviewed but none of…

SQL SERVER – Interview Questions – Difficult SQL Puzzle

December 7, 2008

Pinal Dave

SQL Puzzle

Database, SQL Scripts, SQL Server

Today at my organization, we had nearly 30 interviews scheduled of DBA and .NET developers. Let us see a difficult SQL puzzle.

SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008

December 5, 2008

Pinal Dave

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

Best Practices, Data Warehousing, Database, DBA, MVP, Openday, SQL Backup and Restore, SQL Download, SQL Scripts, SQL User Group, SQLAuthority Author Visit

Ahmedabad SQL Server User Group Meeting was organized on November 29, 2008 at famous C.G. Road in Ahmedabad. We had great response and wonderful back to back technical sessions. The highlight of whole meeting was participation of UG President Jacob Sebastian – SQL MVP from New York. Meeting started with…

SQL SERVER – Interesting Observation – Use of Index and Execution Plan

November 30, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, SQL Index, SQL Scripts

Previously I wrote article about SQL SERVER – Interesting Observation about Order of Resultset without ORDER BY and I have received tremendous response from my readers by emails and comments. Readers demanded that I should have written little more for the same subject. As I really liked the subject myself…

SQL SERVER – Interesting Observation about Order of Resultset without ORDER BY

November 24, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts

Today I observed very interesting little thing about SQL Server and I felt that I should share this with my readers. I ran following two queries and found that I am getting different result-set. When I carefully observed I found that actually the result was same but order of the…

SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database Including Schema

November 22, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Scripts, SQL Stored Procedure

I love active participation from my readers. Just a day ago I wrote article about SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database. I just received comment from Jerry Hung who have improved on previously written article of generating text of Stored Procedure. DECLARE…

SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database

November 20, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Cursor, SQL Scripts, SQL Stored Procedure

SQLAuthority Blog reader YordanGeorgiev has submitted very interesting SP, which uses cursor to generate text of all the Stored Procedure of current Database. This task can be done many ways, however, this is also interesting method. USE AdventureWorks GO DECLARE @procName VARCHAR(100) DECLARE @getprocName CURSOR SET @getprocName = CURSOR FOR SELECT s.name…