SQL Server Performance Tuning Interview Questions 

How to enable sql server management studio and performance tools. In sql server 2005.?

If I use a datatable in conjuction with a sql datareader, would this still be faster in performance than using a dataset?

If so why?

my Sourcecode like this :
Dim ArticleTable As New Data.DataTable


ArticleTable.Columns.Add("ArticleID",
Type.GetType("System.Int32"))
ArticleTable.Columns.Add("ArticleTitle",
Type.GetType("System.String"))
ArticleTable.Columns.Add("ArticleBody",
Type.GetType("System.String"))
ArticleTable.Columns.Add("ArticleDateCre...
Type.GetType("System.String"))


.
.
...


Dim reader As SqlDataReader = Command.ExecuteReader()


While reader.Read()


row = ArticleTable.NewRow()


row("ArticleID") = reader("ArticleID")
row("ArticleTitle") = reader("ArticleTitle")
row("ArticleBody") = reader("ArticleBody")
row("ArticleDateCreated") = (reader("ArticleDateCreated"))


ArticleTable.Rows.Add(row)


End While

thanks.

Indexes increase performance. Index whatever fields you're querying on (aka, the fields in the WHERE clause).

Then get some sort of database caching.

Then write quality queries.

I am trying to figure out what performance impact having a foreign key relationship between two tables on integer fields has to stored procedures?

Any help would be appreciated!

The Server is actually structured to entertain corporate level business needs and bulk requests are generated by different type of applications like web, data engines and many other applications that fulfill the business needs. The problem is that during the peak time of business activities the server's CPU performace jumps to 100 therefore data retrieval becomes slow and most of the times it returns a message "Timeout expired". Please do help me if somebody know a solution to it.