Reason: This is because SQL Server 2008 Express with Advanced Services includes the Full-Text Search feature And as you know that it is one of the per-requisite to install adventure works sample db's in any edition.

I just learn from Abhishek Sur blog That future of C# 5.0 introduce two new keywords like "await" and "async" keyword for simplified existing multithreading model [code] async Task GetStringsFromUrlAsync(string url) { WebClient client = new Web

The WRITETEXT statement is used to update a column of datatypes text, ntext and image. However it will not fire INSERT or UPDATE triggers

I would like to share a script to add tables in existing publication in transactional replication, [CODE] USE PublisherDB GO exec sp_addarticle @publication = N'PublicationName', @article = N'TableName', @source_owner = N'SchemaName', @source

Today I learned, how we can get list of all store procedure from database which is using the given table [code] sp_depends <tableName> [/code] Thank You

Assume that there are two tables table1 and table2 which have same structures and table1 has 10 millions rows and you want to move all rows from table1 to table2. The quickest method that I have learnt is to use Partition Switching [code] alter table ta

MONEY Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit. Storage size is 8 bytes. SMALLMONEY Monetary data values from - 214,748.3648 thro

Just learned about these from the article "SQL Server All, Some and Any Operators" in the website "blackwasp.co.uk". Though these things are basic, its worthy to remember again. The SOME and ANY operators provide equivalent functionality. SOME and ANY

When I viewed the code written by co-worker, I found this. To find sales made in 2009, the where clause was written as [code] Where year(sales_date)=2009 [/code] But beware that this will not make use of index available on sales_date column. The effic

It is because sp_helptext may not return the correct procedure name as it returns text from syscomments system table. When a procedure is renamed using sp_rename, the text column of this table is not updated. Consider this example [code] create procedur