Create the following table on a local database:CREATE TABLE [dbo].[TB_TEMP_TABLESTORE]( [SEARCH_STRING] [nvarchar](128) NULL, [DB_NAME] [nvarchar](128) NULL, [OBJECT_NAME] [nvarchar](128) NULL, [OBJECT_TYPE] [nvarchar](50) NULL) ON [PRIMARY]Rename Yourdatabase to the same...

SQL-Server

Keeping a Database Server Healthy

12 Apr 2011 by __Untitled

Actually, we think xp_cmdshell is not safe enough, and need to be enabled using surface area configuration explicitly (SQL 2005). We use xp_delete_file instead, sample code:DECLARE @l_Runtime DATETIME, @l_BackupFileName VARCHAR(256), @l_FileExists INTSET...

SQL-Server

Node.js Connect to Local SQL (Trusted User)

25 Nov 2017 by A.Ebrahimi

Connect to local database on MS SQL Server in local machine and develop node.js code

Node.js

SQL-Server

Node.js-tools

Create job to export Stored Procedure daily

27 Nov 2012 by Aadhar Joshi

Creating job in sql server which automates taking backup of all stored procedures and functions in physical drive.

SQL Server: How to Get All Indexes List With Involved Columns Name

17 Sep 2012 by aasim abdullah

Get all indexes list in detail, with their involved columns

SQL Server: Keeping Log/Alert for Job Disable/Enable Status

1 Oct 2012 by aasim abdullah

How do you know, if someone disabled your job at production database server. Who is the calprit. How to send a mail alert for this change ??

SQL Server: Restore Failure from Enterprise to Standard Edition

19 Apr 2013 by aasim abdullah

Restore failure from Enterprise to Standard edition in SQL Server.

SQL-Server

SQL-Server-2008

SQL-Server-2005

SQL Server Management Studio: Basic Startup Options

2 Oct 2012 by aasim abdullah

Using SQL Server Management Studio, have you ever come a cross following questions: Why every time, a new query window is open with MASTER database.? On opening SQL Server Management Studio, I need a new query window automatically ?

SQL-Server-2008

SQL-Server

SQL Server: Get All Databases Size

2 Oct 2012 by aasim abdullah

A simple query to get all databases size on a given instance.

SQL Server: Automatic Query Execution at Every Instance Startup

19 Apr 2013 by aasim abdullah

Automatic query execution at every instance startup.

SQL Server: How to Refresh Intellisense Cache

20 Oct 2012 by aasim abdullah

How to Refresh Intellisense Cache in SQL Server

SQL-Server-2008

SQL-Server

SQL Server: TOP…WITH TIES - A Beauty of TSQL

19 Apr 2013 by aasim abdullah

The TOP clause is commonly used to get the top required rows from a result set. The beauty of this clause is that it can be used with the WITH TIES clause to retrieve all similar rows to a base result set.

SQL Server: Changed data capture without using Triggers

23 Oct 2012 by aasim abdullah

How to use DELETED and INSERTED virtual tables to capture data change in result of any INSERT, UPDATE or DELETE statement.

SQL Server : How to Keep Database Restore History

24 Oct 2012 by aasim abdullah

Backup and then restore of a database is a normal job for developers and DBAs. This script will be helpfull to findout, from which path, and which backup file a database was restored.

SQL Server Scripts: Get All Nested Stored Procedures List (Procedures with Dependent Procedures)

1 Nov 2012 by aasim abdullah

A stored procedure can be called from another stored procedure as nested stored procedure. How to get a list of these stored procedures with their nested one

SQL-Server

SQL-Server-2008

SQL-Server-2005

SQL Server: Bookmark Lookups, a Query Performance Killer

1 Nov 2012 by aasim abdullah

You have place indexes but still queries are slow... are you facing bookmark lookup problem ???

Traverse a MSSQL table without using CURSOR

3 Aug 2012 by Abdul Quader Mamun

To traverse a table without cursor, you only need to add an additional field in the table with null value. Here is the code for traversing a table.

SQL-Server

Adding Time in HH:MM Format - Useful SQL Query

10 Feb 2012 by abdul sami

select aday, code, convert(varchar(5), min(atime), (108))MinTime, convert(varchar(5), max(atime),(108)) MaxTime from testgroup by aday,codeorder by aday asc

SQL

SQL-Server

SQL-Server-2005

How To Select Record Based on Row Number

20 Jan 2010 by Abhishek Sur

It is a common issue of many of the guys on how we can fetch a record based on its record number. It is really easy to get first 10 records usingSELECT TOP 10 * FROM EMPBut when we want to fetch records in such a way say I need to fetch record from 40 to 50. This comes very handy when...

SQL

SQL-Server

SQL-Server-2005

Why Use ASP.NET for Web Development

13 Sep 2014 by Afzaal Ahmad Zeeshan

A slight comparison of ASP.NET upon other (web) programming languages in the market and a discussion of me and some other (web) programming language developers.

Challenges in Data Migration Testing

12 Jan 2016 by AgarwalPriyanka, ErGauravSharma

Challenges faced in data migration testing

Backup and Restore SQL Server database

22 Nov 2011 by Ahmed Naqibul Arefin

How to backup and restore SQL Server database schema

SQL-Server

Run Single Page Applications (SPA) Template using AngularJS, Web API, Owin Token Based Authentication and Mediator Design Pattern

23 Mar 2016 by Ahmet AYDIN

This post describes step by step how to run a Single Page Application template using ASP.NET Web API 2 and angularJS and how to use Web Application Project whose name is Dalyan.

Simple SSRS Report using MDX Query

18 Jul 2014 by Ajit Kumar Thakur Microsoft

This tip contains simple step by step solution to read SSAS cube data using MDX query and display in SSRS report.

Daily reminder using SQL Agent and SignalR

11 Dec 2019 by Akmishra0719

Daily reminder using SQL Agent and SignalR

Fast way to deal with foreign keys

18 Jun 2010 by Alexander Konstantinov

Two stored procedures helping developers do less things when they create tables and indeces

SQL

SQL-Server-2008

SQL-Server

Create Documentation for SQL Server Tables

27 Jun 2011 by Alexandros Pappas

This tool reads the descriptions of the columns of the SQL server and creates a Word document using SoftArtisans' WordWriter.

Write error log in a text file for Custom Assembly being used in Reporting Services

19 Sep 2013 by alifaraze

writing error in a text file is very easy but writing error from a custom assembly in reporting services requires permissions

XML File to SQL Database

6 Jun 2018 by Altaf Ansari

Dynamic creation of an SQL table by using an XML file, and importing data from an XML file to an SQL table.

.NET

SQL-Server

Dev

How to Find a Text in SQL Server Stored Procedure

30 Jun 2012 by Ameet Parse

This article describes How to find a Text in Stored Procedure (Checked on SQL Server 2008)

How to Find a Text in SQL Server Stored Procedure

29 Jun 2012 by Ameet Parse

This is an alternative for "Find all Stored Procedures having a given text in it"

SQL-Server

Type Preference with UNION in SQL Server

10 Dec 2013 by Amey A khedekar

A scenario with data type of the resultant select columns with UNION.

Always use Binding Variables in SQL queries

19 Apr 2011 by Amit Kumar Tiwari

Boost application speed and performance

How to Insert HTML Table Data into SQL Server in a Single Batch by Using JQuery Ajax and Structured Parameter

29 Nov 2015 by Amit Singh Baghel

Saving Details Table Data (An HTML Table) in Database by converting it into a jagged array and passing it to a table type parameter

INSERT with SELECT vs INSERT with VALUES

30 Nov 2010 by Andrew Rissing

You might want to do some further testing... It seems if you perform the following, the values are actually the same:SET NOCOUNT ONDECLARE @TMP TABLE( EmpName VARCHAR(50), Age INT)PRINT CONVERT(VARCHAR, GETDATE(), 121)INSERT INTO @TMP(EmpName, Age)SELECT 'Ravi Kiran',...

SQL-Server

Finding numbers from a text in SQL Server.

10 Mar 2012 by André Kraak

This is an alternative for "Finding numbers from a text in SQL Server."

SQL-Server

Formatting Local Datetime to UTC in SQL Server

17 Jul 2012 by Ani_0707

This article intends to describe a simple and elegant way of converting local datetime to UTC and store it in DB.

SQL

SQL-Server

Dev

ADO.Net Connectivity using Stored Procedure and Output parameters

10 May 2015 by Ankit Bansal MVP

This articles explains the insertion of data into SQL Database using Stored Procedures with Output Parameters. Some Bootstrapping is also used to create a good looking HTML.

String concatenation in Transact-SQL

5 Mar 2011 by Anton Burtsev

Performing fast concatenation of strings from different records

SQL

SQL-Server

Counting All Rows of All Tables in a Database

28 Sep 2015 by Antonio Soares

This tip shows three alternatives (an intuitive and less efficient, a more efficient one and a third more efficient one) to count all rows of all tables in a database.

Sort AlphaNumeric Data in Sql

23 Aug 2011 by Anurag Gandhi

I have gone through a lot of examples to sort alpha numeric data in sql. Here is my way:

Copy/Synchronize Table Data between databases

16 Mar 2012 by Anurag Gandhi

A Query to copy an individual table data between databases

Identifying and Deleting Duplicate Records from SQL Server Table

1 Jun 2016 by Aqeeel

Identifying and deleting duplicate records from SQL Server Table

The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()

17 Jul 2017 by Arif H Shigri

This tip will discuss the difference between ROW_NUMBER(), RANK() and DENSE_RANK().

SQL

SQL-Server

database

Delete Duplicate Rows in SQL Server

26 Oct 2014 by Arkadeep De

How to remove duplicate records using CTE in SQL

SQL

SQL-Server

Get Table Column Value as Comma Separated Value (CSV) in SQL

9 Mar 2016 by Arslan Elahi

Get the Comma Separated Value of one or multiple columns from SQL table

SQL

SQL-Server

CSV

Import CSV or txt File Into SQL Server Using Bulk Insert.

21 May 2014 by Arvind Singh Baghel

Import CSV or txt File Into SQL Server Using Bulk Insert.

Cool Insert Generator

26 Sep 2013 by Ashkan.hosseini

Stored procedure that generates insert stored procedure for tables

String concatenation in Transact-SQL

9 Mar 2011 by AspDotNetDev

I like the original solution, especially when compared to this (which I am posting just to show that there are other solutions):-- Initialize table.CREATE TABLE #BigStrings( StringID bigint IDENTITY(1,1) NOT NULL, StringValue text NOT NULL, CONSTRAINT PK_BigStrings PRIMARY KEY...

SQL

SQL-Server

List All Tables and Columns in a Database

20 Jul 2013 by AspDotNetDev

This query will show you all tables and columns in a database, and it can be pasted into Excel for easy manipulation.

SQL

MS-Excel

SQL-Server

SQL Server Restart Health Check Script

25 Aug 2013 by Atul_Kapoor

Steps for deploying Restart Health Check script in a SQL Server environment.

SQL-Server

DBA

Migrate reporting services Database to Another Server

26 Aug 2013 by Atul_Kapoor

SQL Server Reporting database migration from SQL Server 2005 to SQL Server 2008 R2

Windows

SQL-Server

SQL Server Health Check Script with Powershell

3 Dec 2014 by Atul_Kapoor

Perform SQL Server Instance health check simultaneously on more than one server using Powershell

Federate Your Data for Internal and Limited External Consumption

24 Jan 2014 by B. Clay Shannon

Create peace and unity in your organization by separating data and coding responsibilites

How to Save Excel Files to SQL Server and Make them downloadable from an ASP.NET Web API Project

1 Apr 2016 by B. Clay Shannon

Save Excel (or other types of) files to SQL Server, then read them out again and make them downloadable via a link on an ASP.NET Web API page

Data Change Tracking Solution for Auditing SQL Server

29 Jan 2017 by Bart Ducal

Universal data change tracking solution for auditing SQL Server databases

Find all Stored Procedures having a given text in it

5 Jun 2013 by Basavaraj P Biradar

How to find all the Stored Procedures having a given text in it.

SQL-Server

GO Statement can also be used to Execute Batch of T-SQL Statement Multiple Times

25 May 2013 by Basavaraj P Biradar

GO Statement can also be used to execute batch of T-SQL statement multiple times

SQL-Server

Difference between SQL Server Char and Varchar Data Type

5 Jun 2013 by Basavaraj P Biradar

Difference between SQL Server Char and Varchar data type.

SQL-Server

A better way to count(*)

8 Jun 2010 by basementman

Or, assuming your table has an index, you could do this "old-school" as:select MAX(rows) from sysindexes where id = Object_ID('{tablename}')

SQL

LINQ

SQL-Server

Find duplicate values in SQL Server

13 Oct 2011 by bbirajdar

How to find duplicate values in SQL Server.

SQL-Server

SOUNDEX() in Microsoft SQL 2005

6 Nov 2011 by bbirajdar

Use of soundex() function in SQL server

SQL-Server

Your SQL Wrapped in Generated Code. Interesting? Original?

1 Jul 2016 by bbsimonbb

World first implementation of the Dominic Strauss Kahn data access method!

Windows

SQL-Server

AngularJS & Web API Active Directory Security

28 Aug 2015 by Bert O Neill

AngularJS and Web API Active Directory Security (Authorisation)

Data Services - Best practices in Business Intelligence Development: SSIS, T-SQL

8 Dec 2014 by Bertin @nonodata.com

It is often important to have general guidelines when putting together a Data Analysts Team.

The Best Table Finder (The BestCube Problem)

20 Dec 2016 by BharatRamV

Finds the Best Table for a given set of columns

Bulk Copy/Insert from a CSV file to SQL Directly

14 Jan 2016 by Bhishma Anil Kajaria

Browse and Copy data from your CSV file to SQL directly without any Windows application...

ADO.NET

SQL-Server

Big n Bulky "How To" Document for ASP.NET MVC, Entity Framework, LINQ, HTML 5 and JQuery

28 Sep 2014 by Bhushan Mulmule

This is terribly unorganized document with mix of MVC, Entity Framework, LINQ, HTML 5 and JQuery how tos...

How to Retrieve Dynamic XML Data from T-SQL

9 Jul 2013 by Bhushan W. Juare

The different ways of retrieving XML data from SQL Server.

How To Use SQLCMD Utility in SQL Server 2008?

11 Jul 2013 by Bhushan W. Juare

This tip shows how to use SQLCMD utility in SQL Server 2008.

SQL

SQL-Server

Connecting Windows Form Application With ADO.NET in C#

2 Dec 2012 by Bikash Karmokar

Connecting Windows Form Application With ADO.NET in C#

How to trace SQL Server Express without using SQL Profiler

20 Feb 2012 by BillyGoatGruff

SQL Profiler is not included with SQL Express, this tip will help if you need to track client activity.

SQL-Server

Find all Stored Procedures having a given text in it

11 Oct 2011 by BlackburnKL

We use a slightly modified approach that returns results from more than stored procedures (although it could be modified to return only results for stored procedures). We use this code in a stored procedure that requires a parameter containing the text to search for.@StringToFind...

SQL-Server

Using Coalesce() in sqlserver

11 Jun 2013 by blnreddy

SQL Server built-in functions Coalesce()

SQL-Server

SMO 101 - Getting all DB's

17 Aug 2011 by bmckuhen

How to get a quick list of all DBs using SMO

Dynamic ORDER BY with multiple criteria in T-SQL

28 May 2013 by Bob Crowley

How to use a CASE statement in ORDER BY to avoid dynamic SQL

How to Write a Single Stored Procedure for Delete/Retrieve all Table of Records

14 Jun 2013 by Bojjaiah

Single Stored Procedure for delete/retrieve all table of records

T-SQL: Most Practical Split Function

11 Oct 2013 by Brad Joss

A SQL String Split function for the real world

T-SQL: Search SQL Code

16 Oct 2013 by Brad Joss

Search your SQL code with simple T-SQL statements.

View for SQL Agent Job Histories

12 Mar 2014 by Brad Joss

Views to make analyzing SQL Agent Job statistics easier

SQL

SQL-Server

SQL Zip Compression, RegEx and Random Functions

17 Dec 2014 by Brad Joss

SQL CLR Functions for Zip Compression and Regular Expression evaluations

Ensure Your Code First DB is Always Initialized

27 Jun 2012 by Brady Kelly

A quick and easy way to ensure that your Code First DB Initializer is always run when your app starts, not just on the first data access operation

Tip: Run a Transact-SQL Script (.SQL File) From the Command Line

22 Dec 2010 by Brian C Hart

Provides the quick-and-dirty syntax to connect to a given Microsoft SQL Server instance so you can then run a .sql query script against it, e.g., if you are calling this from code as part of a larger pipeline

SQL

SQL-Server

A Closer Look at Lookup Tables

20 Oct 2016 by Bryan Kowalchuk

The two most common database lookup table patterns are examined

PHP and Accessing MS SQL Server in Unix/Linux

17 Jun 2013 by C Is Sharp

PHP and Accessing MS SQL Server in Unix/Linux.

Linux

PHP

SQL-Server

Find particular word or text from the entire stored procedure

26 Jan 2012 by CaldasGSM

since syscomments is nvarchar(4000) the word may be split into several rows.. so you concat them.. or at least pair them up... here is the sp I use to search on the stored proceduresCREATE PROCEDURE [dbo].[sp_FindInProc] @sText NVARCHAR(MAX) = '%'ASBEGIN SET NOCOUNT ON ...

SQL-Server

How to Calculate the Check Digit on a Columbia Gas Account Number

19 Nov 2020 by cattman1970

Function that consumes a Columbia Gas account number of 11+ digits and returns the check digit

SQL

SQL-Server

Dev

List SQL Server table column name as rows

2 May 2012 by Chamila Nishantha

Simple query to get table column name as rows

SQL

SQL-Server-2008