July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2008 – Interview Questions and Answers – Part 3

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Database, SQL Constraint and Keys, SQL Index, SQL Scripts, SQL Utility
Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download 1) General Questions of SQL SERVER 2) Common Questions Asked Which TCP/IP port does SQL Server run on? How can it be changed? SQL Server runs on port…
Read More

SQL SERVER – 2008 – Interview Questions and Answers – Part 1

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Database, SQL Constraint and Keys, SQL Index, SQL Scripts, SQL Stored Procedure, SQL Trigger
Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download 1) General Questions of SQL SERVER What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships…
Read More

SQLAuthority News – 700 Articles and Author Updates

Pinal Dave
Personal, SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, Database, DBA, MVP, SQL User Group
It is always interested to write article when reached at milestone. I start to receive many emails and suggestions just about when this blog is reaching any milestone. One question keep on coming to me is why do I write or what is in it for me? Satisfaction! I enjoy…
Read More

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

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SharePoint, Software Development
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…
Read More

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

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…
Read More

SQL SERVER – Find Primary Key Using SQL Server Management Studio

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…
Read More
All Articles 1_Catalog-500x400

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

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.

Read More