SQL Server Archives - Page 255 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Download FREE SQL SERVER Express Edition and Service Pack 1

December 27, 2009

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Here is the quick link from where SQL Server 2008 Express Edition can be downloaded. Download SQL Server 2008 Express Edition You can download it with many additional details as described in following image. Click on above link to go to page and select desired version. Additionally, please install SQL…

SQL SERVER – Whitepaper SQL Server 2008 Full-Text Search: Internals and Enhancements

December 26, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Documentation, SQL Scripts, SQL White Papers

SQL Server 2008 Full-Text Search: Internals and Enhancements SQL Server Technical Article Writer: Fernando Azpeitia Lopez, Microsoft Corp. Published: July 2008 Database systems must go beyond the traditional realm of relational data by covering an increasing amount and variety of unstructured and semistructured information, be it speech, documents, XML, bioinformatics,…

SQL SERVER – CDC and TRUNCATE – Cannot truncate table because it is published for replication or enabled for Change Data Capture

December 25, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CDC, SQL Error Messages, SQL Scripts, SQLAuthority Author Visit

Few days ago, I got the great opportunity to visit Bangalore Infosys. Please read the complete details for the event here: SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore. I mentioned during the session that CDC is asynchronous and it reads the log file to populate its data.…

SQL SERVER – ORDER BY Clause and TOP WITH TIES

December 23, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Recently, on this blog, I published an article on SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY; this article was very well received because of the observation made in it. One of the comments suggested the workaround was to use clause WITH TIES along with TOP…

SQLAuthority News – Meeting SQL Expert Imran at Hyderabad

December 22, 2009

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA

I was very fortunate to meet the SQL Server Expert and one of the top participants of this blog Imran Mohammed. Imran has been very active on this blog and have previously contributed with few articles as well. I have been communicating with Imran for a long time; he is…

SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2

December 21, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Scripts, SQL String, SQL XML

In my earlier post, I wrote about how one can use XML to convert table to string SQL SERVER – Comma Separated Values (CSV) from Table Column. The same article is also published on channel 9 SQLAuthority News – Featured on Channel 9. One of the very interesting points that…

SQLAuthority News – Migrating DTS Packages to Integration Services

December 20, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Business Intelligence, Data Warehousing, SQL White Papers

Migrating DTS Packages to Integration Services Writer: Brian Knight Published: July 2008 SQL Server Integration Services (SSIS) brings a revolutionary concept of enterprise-class ETL to the masses. The engine is robust enough to handle hundreds of millions of rows with ease, but is simple enough to let both developers and…