SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• how to alter the existing Primary key Non clustered index to Primary key Clustered Index

  hi ALl, Can you please help me to do this change: how to alter the existing Primary key Non cluster…

  kbhanu15

  6 replies

  11 years, 6 months ago

  By: Gail Shaw

• Query slower on 2008 than 2000

  Hi all, I've restored a SS2K DB to SS2K8, new box with superior (virtual) hardware, however one of …

  Jake Shelton

  3 replies

  11 years, 6 months ago

  By: SQLRNNR

• SQL Server 2008 R2 Memory Hog

  I have an instance of SQL Server 2008 R2 installed on a VM with 4 cpus and 16 GB of RAM. It curren…

  DKY

  21 replies

  11 years, 6 months ago

  By: DKY

• Hierarchical Tree View of blocking behaviour

  Help before I leap out the window ! I want to create a view of a table that captures blocking info…

  simon_s

  5 replies

  11 years, 6 months ago

  By: Jack Corbett

• Sudden PLE Drop Possible Without Memory Pressure?

  My SQL Server is a virtual machine, running on ESX 4.1 and configured as follows: - 28GB of Memory,…

  timothy.lazarus

  4 replies

  11 years, 6 months ago

  By: timothy.lazarus

• table valued function xml reader high cost

  Hi All, I have a xml and i am inserting data into one temp table from xml. this cost is very high.c…

  kbhanu15

  4 replies

  11 years, 6 months ago

  By: kbhanu15

• Index Operational stats?

  Hi, I have verified one of the production database as below query SELECT OBJECT_NAME(A.[OBJECT_ID]…

  SQL Galaxy

  9 replies

  11 years, 6 months ago

  By: MyDoggieJessie

• So what does constitue "high logical reads"

  I seem to be going round the houses on this one, reading ancient threads, blogs that offer conflict…

  simon_s

  5 replies

  11 years, 6 months ago

  By: MyDoggieJessie

• Hardware v SQL Tuning

  Hello What ways would you go about attempting to quantify what performance improvements that can be…

  tct_sql_admin

  2 replies

  11 years, 6 months ago

  By: tct_sql_admin

• About Resource Govrnor

  Hi I am looking for help about Resource Governor. I did a Resource Governor test. I created two poo…

  SillyDragon

  15 replies

  11 years, 6 months ago

  By: ajsql990

• Query of 100 mil rows with multiple parameters

  Hello, I have a challange with a table with around 100 million rows which look like: CREATE TABLE …

  MarkHK

  39 replies

  11 years, 6 months ago

  By: Gail Shaw

• Non Clustered index on Primary key is not used by the execution plan and showing Table scan

  Hi ALl, Hi Have a table with non clustered index on primary key index_name index…

  kbhanu15

  4 replies

  11 years, 6 months ago

  By: Umer Akram

• Is using 0x0 faster than a 0 in a WHERE clause

  For a bit field, is using WHERE mybit = 0x0 faster than WHERE mybit = 0 I am being told to use 0x0 …

  smrtstpetesmith

  4 replies

  11 years, 6 months ago

  By: Richard Fryar

• Query Stored Procedure Behaviour

  Dear All, I have created stored Procedure which executes 1:20 (mm:ss) in development envioronmen…

  sivaramakrishnan G

  2 replies

  11 years, 6 months ago

  By: Sean Lange

• Help Required Dynamic SQL

  Dear All, Find the following sample.I am executing dynamic sql to populate the value.The Formula…

  sivaramakrishnan G

  1 replies

  11 years, 6 months ago

  By: Sean Lange