Data Engineering – Learn from the experts
-
SQL Server 2005 Full Text Search
We had a requirement where the user had to do a search on Overview/description field which had nvarchar (max) data type. Full text search can be used for searching against the LOB data types like nvarchar (max), text and BLOB data types like varbinary (max) and image data type. Please note that in image and…
-
SQL 2005 Transaction Replication
I have an existing publication with 10 articles configured for Transactional replication. The replication is running fine. Now I wish to add another table (article) to this publication. My requirement is to ensure that I dont need to generate a snapshot of all the articles being published, if I add a single article only that…
-
Disk space (including mounted drive) Check via SQL Server
In my previous article on Diskspace Check via SQLServer will find only physical logical drives that is attached to the system i.e the drive which you see under my computer. Ive used this script in one of my client machine and found that this script is not capable to check disk space for mounted drives.…
-
How to change Server Collation in SQL Server 2008
In this article we are going to discuss about changing SQL Server 2008 collation at serverlevel. While installing SQL Server 2008 we may miss to choose the right collation and we need to rectify this by changing the collation at serverlevel. You can change the collation of sql server without uninstalling. Lets discuss the necessary…
-
FORCESEEK Hint – SQL Server 2008
Forceseek hint is a new addition to SQL Server 2008. It forces the query optimizer to use an Index seek instead of Index scan. Forceseek applies to both clustered and nonclustered index seek operations. It can be specified for any table or view in the FROM clause of a SELECT statement and in the FROM…
Got any recommendations?