Filtered Index is a new feature in SQL SERVER 2008. Filtered Index is used to index a portion of rows in a table that means it applies filter on INDEX which improves query performance, reduce index maintenance costs, and reduce index storage costs compared with full-table indexes.
SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example
Table-Valued Parameters is a new feature introduced in SQL SERVER 2008. In earlier versions of SQL SERVER it is not possible to pass a table variable in stored procedure as a parameter, but now in SQL SERVER 2008 we can use Table-Valued Parameter to send multiple rows of data to…
Read MoreSQL SERVER – FIX : ERROR : Could Not Connect to SQL Server – TDSSNIClient initialization failed with error 0x7e, status code 0x60
This is a very common error faced by so many people and I get lots of questions regarding this error. This error occurs due to many reasons and I have already posted few solutions on this error, see if you can find your solution here SQL SERVER – Fix :…
Read MoreSQL SERVER – Few Useful DateTime Functions to Find Specific Dates
Recently I have recieved email from Vivek Jamwal, which contains many useful SQL Server Date functions. ----Today SELECT GETDATE() 'Today' ----Yesterday SELECT DATEADD(d,-1,GETDATE()) 'Yesterday' ----First Day of Current Week SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) 'First Day of Current Week' ----Last Day of Current Week SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) 'Last Day of Current Week' ----First Day of Last Week SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0) 'First Day of Last Week' ----Last Day of Last Week SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),6) 'Last Day of Last Week' ----First Day of Current Month SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0) 'First Day of Current Month' ----Last Day of Current Month SELECT DATEADD(ms,- 3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE())+1,0))) 'Last Day of Current Month' ----First Day of Last Month…
Read More
SQL SERVER – 2008 – Introduction to Merge Statement – One Statement for INSERT, UPDATE, DELETE
MERGE is a new feature that provides an efficient way to perform multiple DML operations. In previous versions of SQL Server, we had to write separate statements to INSERT, UPDATE, or DELETE data based on certain conditions, but now, using MERGE statement we can include the logic of such data modifications in one statement that even checks when the data is matched then just update it and when unmatched then insert it.
SQLAuthority News – Microsoft SQL Server 2008 R2 Report Builder 3.0
Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 supports the full capabilities of SQL Server 2008 Reporting Services including flexible report layout, data visualizations and richly formatted text. The download includes the following functionality above the RC0 release of Report Builder:
SQLAuthority News – SQL Server Express 2008 Downloads
Microsoft SQL Server 2008 Express with Tools Microsoft SQL Server 2008 Express with Tools (SQL Server 2008 Express) is a free, easy-to-use version of SQL Server Express that includes graphical management tools. SQL Server 2008 Express provides powerful and reliable data management tools and rich features, data protection, and fast…
Read MoreSQL SERVER – How to Rename a Column Name or Table Name
I often get requests from blog reader for T-SQL script to rename database table column name or rename table itself. Here is a video demonstrating the discussion [youtube=http://www.youtube.com/watch?v=5xviNDISwis] The script for renaming any column : sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN' The script for renaming any object (table, sp etc) :…
Read MoreSQLAuthority News – Ahmedabad SQL Server User Group Meeting – August 2008
I will be attending Ahmedabad SQL Server Usergroup Meeting on August 30, 2008. I will be taking session about “SQL Server CTE and Recursive CTE“. The most important part of August Meeting is there will be presentation on “Transaction Isolation Levels and Locks in SQL Server” from user group President…
Read MoreSQLAuthority News – 4 Million Visits – over 675 SQL Server Articles
Thank you to all of my readers for supporting this blog. It has been wonderful journey all the way. I strongly encourage all my readers to actively contribute in discussion and writing article for blog. Today this blog has completed 4 Million visits and there are over 675 articles published…
Read More