Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – SharePoint – Steps To Create A Custom WebPart – Deploy It SharePoint Site

September 10, 2008

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

SharePoint is one interesting software from Microsoft. My outsourcing location unit is working on one large project of SharePoint. Based on users feedback and overwhelming response to article SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name I am posting one more article which…

SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name

September 9, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SharePoint, Software Development, SQL Error Messages

If Microsoft Office SharePoint Server (MOSS) and your database (MS SQL Server) are running together on same physical server, changing the name of the server (computer) using operating system may create non-functional SharePoint website. When you change the physical server name the SharePoint is already connected to the SQL instance…

SQL SERVER – 2008 – Creating Primary Key, Foreign Key and Default Constraint

September 8, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts

Primary key, Foreign Key and Default constraint are the 3 main constraints that need to be considered while creating tables or even after that. It seems very easy to apply these constraints but still we have some confusions and problems while implementing it. So I tried to write about these…

SQL SERVER – Explanation about Usage of Unique Index and Unique Constraint

September 7, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Database, DBA, SQL Index

I enjoy reading questions from blog readers and answering them. One of the another SQL enthusiastic is Imran who also regularly answer questions of users on this community blog. Recently he has answered in detail about when to use Unique Index and when to use Unique Constraint. Cristiano asked following…

SQL SERVER – Find Primary Key Using SQL Server Management Studio

September 6, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Index, SQL Scripts, SQL System Table

Imran Mohammed is great SQL Expert and always eager to help community members. He enjoys answering question and solving problems of other community fellows. His answers are always detailed and trustworthy. Today we will see interesting question from Prasant and excellent answer from Imran Mohammed. Question from Prasant: Hi, I…

SQL SERVER – 2008 – Creating Full Text Catalog and Full Text Search

September 5, 2008

Pinal Dave

SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Server, SQL Utility

Full Text Index helps to perform complex queries against character data. These queries can include words or phrase searching. We can create a full-text index on a table or indexed view in a database. Only one full-text index is allowed per table or indexed view. The index can contain up to 1024 columns. Software developer Monica Monica, who helped with screenshots also informed that this feature works with the RTM (Ready to Manufacture) version of SQL Server 2008 and does not work on CTP (Community Technology Preview) versions. Let us learn about Creating Full Text Catalog and Full Text Search in this blog post.

SQLAuthority News – Download SQL Server Related Products

September 5, 2008

Pinal Dave

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

Database, SQL Download

Configuration Manager 2007 R2 Evaluation Configuration Manager R2 now also supports Windows Vista SP1 and Windows Server 2008, integrates support for application virtualization, and provides an update to operating system deployment capability initially shipped in Configuration Manager. In addition, Client Status Reporting, SQL Reporting, and Forefront Client reporting are all…