DevSocial Articles · SQL Server articles

1591. 

      Coalesce Function in SQL Server 2008 With Limitations

      This article describes the Coalesce Function in SQL Server 2008.

      Sachin KaliaAug 26, 201416,3071,000
1592. 

      Introduction To SQL-API

      This provides the fundamentals of the SQL-API and covers the general concepts using the SQL-API

      Chigicherla MallikarjunaAug 8, 201411,7561,000
1593. 

      How to Change Default Value For Selecting and Editing Top n Rows in SQL Server 2012

      In this article I will describe how to change a default value for selecting and editing N rows in SQL Server 2012.

      SAShivom AgarwalAug 7, 201410,1751,000
1594. 

      How to Uninstall a SQL Server Instance in SQL Server 2008R2 and 2008

      This article describes how to uninstall a SQL Server instance in SQL Server 2008R2 and 2008.

      SAShivom AgarwalAug 5, 2014158,2191,000
1595. 

      Conditional Split in SSIS

      This article gives an overview of Conditional split transformation in SSIS. This is used to route data rows to various outputs based on conditions. This is similar to a case statement in programming languages.

      Sreekanth MohanAug 2, 201413,7691,000
1596. 

      Foreach File Enumerator in SSIS

      This article explains the Foreach File enumerator functionality of SSIS for each loop container.

      Sreekanth MohanJul 31, 201418,0491,000
1597. 

      Restore a SQL Server BACKUP Using Transact-SQL

      This article describes how to restore a SQL Server backup using one of multiple methods using Transact-SQL.

      SAShivom AgarwalJul 24, 201415,4031,000
1598. 

      COALESCE in SQL Server

      Here you will find how can we use the COALESCE keyword in SQL Server.

      Jasminder SinghJul 20, 201418,1971,000
1599. 

      SQL Server DATABASE BACKUP With Multiple Methods Using Transact-SQL

      This article describes SQL Server database backups and how to take a SQL Server database backup with multiple methods using Transact-SQL.

      SAShivom AgarwalJul 18, 201415,5051,000
1600. 

      How to Track User That Dropped/Deleted TSQL on SQL Server Objects

      In this article I will explain how to track the user that dropped/deleted TSQL on SQL Server Objects.

      SAShivom AgarwalJul 15, 201437,1351,000
1601. 

      Changing SQL Server Instance Name Using a SQL Server Alias

      In this article I will explain how to change an instance name using a SQL Server alias.

      SAShivom AgarwalJul 14, 2014128,1061,000
1602. 

      SQL Server Transact-SQL Programming

      This article explains Transact-SQL Programming in SQL Server.

      Abhijit PatilJul 4, 20147,9881,000
1603. 

      Replace in SQL Server

      This article explains the Replace function in SQL Server. It also provides a brief description of the differences between the Replace and Stuff functions.

      Jasminder SinghJun 30, 20148,6561,000
1604. 

      Dense Rank Function in SQL Server

      This article explains the dense rank function in SQL Server.

      Jasminder SinghJun 24, 201412,1441,000
1605. 

      User Defined Functions in SQL Server

      This article explains User Defined Functions in SQL Server.

      Ranjit PowarJun 24, 2014163,6561,000
1606. 

      Dedicated Administrator Connection (DAC) on SQL Server

      This article shows how to make a Dedicated Administrator Connection (DAC) to allow administrators emergency access to SQL Server via SQL Server Management Studio (SSMS) or via command prompt (SQLCMD utility).

      SAShivom AgarwalJun 23, 201415,7211,000
1607. 

      View in SQL Server

      This article explains views in SQL Server.

      Abhijit PatilJun 21, 201411,0991,000
1608. 

      Query Notification in SQL Server

      This article explains QueryNotification and SQLCacheDependency in SQL Server.

      Ahmar HusainJun 11, 201417,3061,000
1609. 

      Union and Union All in SQL Server

      This article explains Union and Union All in SQL Server.

      Rakesh KalluriJun 10, 201412,9721,000
1610. 

      Set Operators in SQL Server

      Set operators are used to combine results from two or more SELECT statements.

      Ranjit PowarJun 6, 201432,5371,000
1611. 

      The Undocumented Sp_MSforeachdb Procedure in SQL Server

      This article explains the undocumented sp_MSforeachdb procedure in SQL server.

      Jignesh TrivediMay 27, 201419,3581,000
1612. 

      Logon Trigger in SQL Server 2012

      This article describes how to use a Logon Trigger to restrict out of office hours and limit or deny the number of connections for a specific user.

      SAShivom AgarwalMay 26, 201419,1351,000
1613. 

      Delete All Table Data Within a Database in SQL Server

      This article explains two ways to delete all the table data within a database.

      Jignesh TrivediMay 23, 2014267,3801,000
1614. 

      Releasing the Memory Consumed by stubborn SQL Server at Runtime

      This article explains the release of memory consumed by SQL Server at runtime.

      Leon PuthMay 23, 20147,6101,000
1615. 

      Database Mail in SQL Server 2012

      This article describes Database Mail, how to configure and manage Database Mail, and what permissions are needed to use database mail in SQL server 2012.

      SAShivom AgarwalMay 22, 201423,8541,000
1616. 

      Find nth Highest Value in SQL Server

      This article shows how to find nth highest value from a database table.

      Jignesh TrivediMay 9, 201453,5321,000
1617. 

      Generate SQL Script With Data in SQL Server

      In this article we learn how to generate a SQL Database script with data.

      Hussain AhmedMay 8, 201411,5421,000
1618. 

      Useful T-SQL For Date Calculations

      In this article, we will see some useful T-SQL for date calculation.

      Pradip PandeyMay 1, 20149,0011,000
1619. 

      Get Missing Objects For a Particular User in a Database

      In this article I will explain how to get missing objects for a particular user in a database.

      SAShivom AgarwalMay 1, 20146,8151,000
1620. 

      Functions in SQL Server

      Here, we will take a look at how to use functions in SQL Server.

      Rakesh SinghApr 30, 20146,9231,000

Everything on SQL Server, not only its articles: the SQL Server page →