Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Data Warehousing, Database, SQL Data Storage, SQL Function, SQL Index, SQL Scripts, SQL Server DBCC, SQL Utility
Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download What is Data Compression? In SQL SERVE 2008 Data Compression comes in two flavors: Row Compression Page Compression Row Compression Row compression changes the format of physical storage…
Read More

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

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Database, SQL Error Messages, SQL Scripts, SQL Server Security, SQL Utility
Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download How can we rewrite sub-queries into simple select statements or with joins? Yes we can write using Common Table Expression (CTE). A Common Table Expression (CTE) is an…
Read More

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

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Database, SQL Scripts, SQL Stored Procedure, SQL Utility
Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download What command do we use to rename a db, a table and a column? To rename db sp_renamedb 'oldname' , 'newname' If someone is using db it will…
Read More

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

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Database, SQL Constraint and Keys, SQL Function, SQL Index, SQL Scripts, SQL Stored Procedure, 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 Which command using Query Analyzer will give you the version of SQL server and operating system? SELECT SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY…
Read More

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 – 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