While working on a SSIS package, I found that SSIS allows creating two different tasks (same or different task types) with different scopes. Follow these steps to verify it for yourself: 1. Create a new SSIS Package 2. Add a new Execute SQL Task and na

While dropping a table present in a different database, you can use the fully qualified Table Name ("DatabaseName.SchemaName.TableName" format) and drop the table as shown below. DROP TABLE AdventureWorks.HumanResources.Department GO While the above

While querying few compatibility views and catalog views I noticed something peculiar. After doing some research, I fould the following: 1. Use of Schema Name is optional while querying Compatibility Views Example: Following three statements return the

Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the columns w

While using Internet Explorer, if you want to open a link in a new tab or to close a currently opened Tab, then simply hover over the link/tab and press the scroll Wheel of your scroll mouse. This technique for closing tabs working in many other applica

Here are few online tools for formatting the T-SQL Queries: http://www.dpriver.com/pp/sqlformat.htm http://www.tsqltidy.com/ http://extras.sqlservercentral.com/prettifier/prettifier.aspx Note: Please read the disclaimer/privacy statement on the res

Here is a quick way to view the properties of a file or folder in Window. 1. Hold the "Alt" key 2. Double click on the file/folder Tested with Window XP, Windows 7.

Here is a quick command to Start or Stop SQL Server and related services from command prompt. NET START "SQL Server (<<InstanceName>>)" NET STOP "SQL Server (<<InstanceName>>)" Example: NET START "SQL Server (MSSQLSERVER2K8R

Run this query to select a random record from a table. [code] SELECT TOP 1 EnglishProductName FROM DimProduct ORDER BY NEWID() [/code]

While writing a SELECT * INTO query, we can combine SELECT INTO with UNION ALL clauses to insert multiple sets of data in one go as follows. SELECT 1 AS MemberID, 'Jacob' AS MemberName INTO #JustLearnedTopContributors UNION ALL SELECT 2 AS MemberID, '