Click here to Skip to main content
15,867,939 members
Everything / Database Development / SQL Server / SQL Server 2012

SQL Server 2012

SQL-Server-2012

Great Reads

by AshishShukla6
This tip describes step by step implementation of executing stored procedure having user-defined table type as a parameter in entity framework using EntityFrameworkExtras package.
by Sarathi Balakrishnan
Reset SQL server SA (System Admin) Password when you have lost all possible ways to connect to SQL server and your server has only Windows authentication disabled. You should have Windows administrator permission to do this.
by AhsanAhmed
A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format
by DiponRoy
How to do string split and join in SQL Server

Latest Articles

by DiponRoy
A utility query to find table generations in SQL Server relational database
by DiponRoy
How to do string split and join in SQL Server
by Micah Nikkel
SQL script that dynamically generates the DR scripts for failing over/back all Log Shipped databases. While it makes even a single database failover/failback a more streamlined process, it's most helpful for servers with multiple databases, such as SharePoint, consolidated SQL Servers, etc.
by Luca Astolfi
User defined procedure for make an HTML table from T-SQL Select statment

All Articles

Sort by Score

SQL Server 2012 

26 Sep 2015 by AshishShukla6
This tip describes step by step implementation of executing stored procedure having user-defined table type as a parameter in entity framework using EntityFrameworkExtras package.
21 Sep 2015 by Sarathi Balakrishnan
Reset SQL server SA (System Admin) Password when you have lost all possible ways to connect to SQL server and your server has only Windows authentication disabled. You should have Windows administrator permission to do this.
19 Feb 2019 by DiponRoy
How to do string split and join in SQL Server
7 Feb 2015 by Gaurav_Chaudhary
This tip is a brief introduction to Pivot operator in SQL Server
15 Feb 2015 by Bohdan Stupak
This tip shows some primary issue which puts a serious limitation on SQL Server MONEY data type.
18 Dec 2015 by Md. Marufuzzaman
This tip shows you an easy way to split Microsoft SQL Server table row data.
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.
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.
9 Jul 2014 by Jason Parms
Lightweight Directory Access Protocol (LDAP) Injection
21 Jun 2014 by george bolovan
Read data from the next row
26 Sep 2014 by Anil kumar Bhardwaj
Export all the primary, Unique, Foreign key and default constraints from existing database
22 Feb 2016 by Sifiso W Ndlovu
This tip illustrates a workaround to SQL Server pivoting on variable character data types.
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 ??
19 Apr 2013 by aasim abdullah
Automatic query execution at every instance startup.
17 Jan 2013 by Tharaka MTR
This article describes the easiest way to create and process delimited row using SQL XQuery.
19 Sep 2013 by Saral S Stalin
Explains how to run a script with higher priority to avoid it getting terminated in a deadlock situation.
26 Jun 2014 by Member 8826598
Performance Tuning of DML Operation Insert in different scenario
19 Jun 2014 by TheSqlGuy
This briefly goes over an issue experienced when executing a query against a linked server to Oracle from SQL Server.
23 Sep 2014 by SatyLepide
By analyzing log-in attempts on SQL server, admins can build the complete picture out of the sequence of events that led to compliance failure or unauthorized access.
26 Aug 2015 by nithyananthams
Different options to get Identity from SQL Server and how OUTPUT clause helped me to get the accurate Identity value compare with other options.
9 Aug 2013 by groggyjava
SQL 2012 Code Snippet for quick blank transaction
20 Aug 2014 by TheCardProject.co.uk
Quickly set up the ability to serve up several pages and record which was served in SQL Server
3 Jan 2015 by Ahmad A.A. Ahmad
How to use chart item in your SSRS Report (% labeling)
14 Aug 2015 by Member 11884108
In this tip, we will learn how to load data dynamically to html dropdownlist using Ajax call.
24 Nov 2014 by Sunil_Pawar
Learn how quickly you can Create, Run, Debug and Deploy SQL CLR function using integrated features of Visual Studio 2013.
19 Jan 2015 by OriginalGriff
Sometimes, you want to extract the filename (with or without the extension) from the full path of a file. It's easy in C# and so forth - just use the Path.GetFileName method. But what if you want it in SQL?
23 Nov 2015 by sandeepmittal11
A sequence is a user defined, schema bound object that generates a sequence of numeric values
21 May 2014 by Arvind Singh Baghel
Import CSV or txt File Into SQL Server Using Bulk Insert.
29 Sep 2014 by Jitendra Ku. Sahoo
Below is one template to handle error in SQL server.
25 Jan 2016 by Gunaprasad Shetty
The tip provides the code snippet for inserting a huge XML file with details such as node level, node value, node desc and node child, etc.The snippet provides the solution for recursive reading of node and provides the value of XML nodes along with its value.
1 Oct 2014 by NaibedyaKar
How to check the query locking the table and to unlock it
20 May 2014 by Ed Nutting
How to fix LocalDB / SQL Server: "Cannot open database "XYZ" requested by the login. The login failed. Login failed for user ABC"
8 Jun 2015 by Diluka Wittahachchige
Creating SQL Server database project use in Visual Studio 2012 and maintain versions use in TFS
25 Aug 2016 by Gene R. Browning
Generate random dates (and times if you like) for your test data environment.
3 Dec 2014 by Atul_Kapoor
Perform SQL Server Instance health check simultaneously on more than one server using Powershell
22 Jun 2014 by Bohdan Stupak
This tip will cover several interesting issues of SQL
5 May 2015 by Sandeep Kumar Tripathi
This tip is used for creating SSRS Report Subscription by using C#.
20 Feb 2010 by Md. Marufuzzaman
Get accurate age by date using MS SQL Server
30 Oct 2014 by Arvind Singh Baghel
I show a SQL query which finds the size of database mdf and ldf file in SQL Server.
19 Nov 2014 by Sums Mohs Eds
A brief discussion of when to use cursors and when to use sets.
3 Oct 2015 by shijo joseph
A simple and fast CSV reader which you can directly use against Oracle and SQL Server databases or for any direct implementation
23 Dec 2015 by Md. Marufuzzaman
A simple tip/trick to get rows on n’th maximum number from a table
3 Oct 2015 by Pedram_Niloufari
How to create an unlimited category list table in database and how to read category list
23 Apr 2014 by mohamedkamaleed
20 Sep 2016 by GhostHost
Automatic creation of non clustered indexes using system SQL entities
7 Oct 2014 by Prakash Lekhak
Create an ER diagram for complex database
25 Nov 2014 by Manish kumar choudhary
In this article, we are going to learn the concept of mail sending using SQL Server.
5 Jun 2015 by Dathuraj Pasarge
Know whether your databases are backed up successfully in the last 24 hours or not !!!
8 Mar 2016 by markkang
This tip describes how to generate insert SQL statement from the records in an existing table in SQL server database
22 Oct 2014 by Jitendra Ku. Sahoo
In this article we will discuss about fill factor and its effect on query performance.
16 Jul 2015 by Math08avan
A simple example for CRUD actions using WCF service in ASP.NET
31 Mar 2015 by Ajit Kumar Thakur Microsoft
This tip explains SQL Server metadata information. It will provide internal details of all available SQL Server 2012 Metadata.
18 Dec 2015 by Md. Marufuzzaman
A simple example of Microsoft SQL Server Pad String
7 Feb 2015 by Gaurav_Chaudhary
This tip is a brief introduction to Recursive CTE in SQL Server and how to implement it.
2 Mar 2013 by Syed Moula Ali
Replicate/Clone/Duplicate selected data in a Table using merge statment
12 Sep 2014 by Mohamad Cheaito
SQL Server: Query to get the date of first Monday of September
1 Nov 2012 by aasim abdullah
You have place indexes but still queries are slow... are you facing bookmark lookup problem ???
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.
8 May 2014 by rafaelpb
Generate a postalcode database for lookups from dutch national data BAG
22 Jan 2015 by Abu Zafor Khairuzzaman
Comparison Chart for Two Different Time Frames in SSRS
23 Sep 2015 by dibley1973
Call stored procedures in a type safe way using my StoredProcedureFramework for .NET
3 Sep 2014 by Xavi Giqwa
This tip is aimed at helping anyone who encounters a similar problem like I had in displaying charts using ASP MVC and dynamic data.
14 Mar 2015 by Gaurav_Chaudhary
This tip is a brief introduction to Apply operator in SQL server
16 May 2016 by Md._Mehedi_Hasan
This tip will help you to generate .xml file in AngularJs and ASP.NET MVC5 using XElement of C#.
18 Sep 2013 by Saral S Stalin
Avoiding conversion errors in scripts using TRY_CONVERT.
15 Apr 2014 by Mike_1989
The following code populates a mainmenu within VB.Net dynamically using recursion, until all items are added to the main menu
25 Apr 2014 by grantliu
Utilize NLog.net in a Service-oriented architecture
1 Jun 2016 by Aqeeel
Identifying and deleting duplicate records from SQL Server Table
22 Jul 2015 by Chetan Naithani
Transforming dynamic row-level data into columns
18 Sep 2014 by sukeshchand
7 Feb 2015 by Syed Noman Ali Shah
How to take SQL server database backup and database restoration in C# using SMO
9 Jul 2016 by Prakash Lekhak
Dynamic SQL to get the list Table names
2 Feb 2018 by Luca Astolfi
User defined procedure for make an HTML table from T-SQL Select statment
31 Aug 2015 by Bert O Neill
Execute SSIS Package in C# or SQL Sproc
20 Jun 2015 by Naresh Patidar
Insert, update and delete operations using stored procedure and DataAdapter in C#
20 Mar 2015 by furytrader
Yes, Virginia, You Can Do This All With One Simple SQL Statement
29 Sep 2015 by Thiago Gaidzinski
UniDAC allows you to connect your cross-platform application directly with many database's types.
8 Aug 2015 by Harsh Aggarwal - India
It's about making back up of database in SQL server 2008 and above you can get rid of making bak file manually.
29 May 2019 by DiponRoy
A utility query to find table generations in SQL Server relational database