(Fabiano Amorim) Normally, the query Optimiser won’t consider ‘bushy’ plans, where both operands to a join operator could be intermediate results from other joins. This means that it won’t produce good query plans for some types of query. Hints, by themselves won’t do it. More powerful magic is requ

(Manvendra Singh) We were tasked with enabling SQL Server Database Mail on a few SQL Server instances. When we were running RECONFIGURE along with the “database mail xps” option through sp_configure, we were not able to run the RECONFIGURE option to enable the changes.

(Ashish Kumar Mehta) Database size is increasing across businesses all over the world, and as a database administrator (DBA) one should make sure that database backups are completed on time.

(Richard Carr) SQL Server-based applications and systems may include multiple schemas, databases and linked servers, all of which can be accessible from scripts and stored procedures. To allow the correct database objects to be accessed requires the use of multipart names.

(Pinal Dave) One of my friends who works in a big MNC recently asked me that if there is any way to check if the String is Palindrome or not. The palindrome is a word, phrase, or sequence that reads the same backward as forward. For example A man, a plan, a canal – Panama! is palindrome so as Was […]

(Manish Dubey) There are various ways to take the SQL Server database backup. You can take the database backup using SQL Server backup wizard or using SQL Server BackUp Database statement. Here I am going to describe how to take the SQL Server database backup programatically using C# and SQL Server

(Robert Sheldon) When Microsoft released SQL Server 2005, they included support for window functions, built-in T-SQL functions that can be applied to a result set’s partitioned rows—windows—in order to rank or aggregate data in each partition. However, support for window functions was fairly limited

(Mike_Liu) In my first three articles on CodeProject.com, I have explained the fundamentals of Windows Communication Foundation (WCF), including:

(Scott Murray) Working with SSAS time related accounting functions can be tricky. SQL Server 2012 now offers Lag and Lead functions. Are these functions available in SSAS? What other related functions are available?

(Hemantgiri S. Goswami) Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are times when we need to find out records matching a criteria from all the tables of a SQL Database and today I will explain you a simple way to retrieve those recor