SQL Server Education (by the geeks, for the geeks)
There are a lot of instances when you are asked to identify TCP port number for a SQL instance unless you use default port (1433) across the board. There are several ways to …
Identify TCP Port Number of a SQL Instance Read MoreDear Friends, Last week we have had a situation where one of our colleague(s) was trying to change database isolation to SQL Server SNAPSHOT Isolation in one of the SQL Server …
SQL Server SNAPSHOT Isolation mode in FILESTREAM database on SQL Server 2008 Read MoreDear Friends, To start with; we can use a data or index page only when they exist in memory. For improved performance it is very important to keep alive the supply …
LRU-K algorithm – Quick look Read MoreHi Friends, Have you ever noticed, while taking a compressed backup the file which gets created initially has a different size than the final file size when the backup completes. To …
SQL Server: Why the size of the backup file changes? Read MoreOne fine day i was configuring DB Mail on one of my server and while configuring Mail Account i encountered the following error. This Bug\Problem is applicable to SQLServer 2008 SP1, …
SQL Server DB Mail Account Creation Failed – A Bug Read MoreHello Everyone, You must have heard about the SQL Server “Full Text Search” functionality. Basically it provides the functionality for applications and users to issue full-text queries against character-based data in …
Full text search Introduction and its integrated in SQL Server 2008 Read MoreSQL Server 2008 introduces four new DATETIME data types as follows: DATE: – In Previous versions of SQL Server, we had to use the DATETIME or SMALLDATETIME data types even though …
New Date and Time Data Types in SQL Server 2008 Read More