SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• how to check maximum dates in the csv files and insert into the sql tables using ssis

  ssis

  Raj9

  6 replies

  14 years, 10 months ago

  By: Jeff Moden

• Data allocation in B-tree

  Hi, I have 10,000 records in a table. What would be the degree (depth) of the B-tree?. What will de…

  Chandhini

  17 replies

  14 years, 10 months ago

  By: Arjun Sivadasan

• Query Optimizer and "GoodEnoughPlanFound"

  I'm looking at a query plan, and I noticed in the XML plan that the optimizer settled for a "good e…

  amoericke

  7 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• Need advice to save SQL Server Files, MDF files, and LDF Files

  Hi, Currently, my plan as follow 1. Setup SQL Server 2005 Enterprise Edition (64 Bit) on Dedicated …

  Little Nick

  8 replies

  14 years, 10 months ago

  By: Little Nick

• Update Stat=Is it helpful to run update_stat after restoring the database to different server

  Please provide me the link to support the topic that do we need to update stat after restoring the …

  hydbadrose

  1 replies

  14 years, 10 months ago

  By: Gail Shaw

• Table vs View

  Hi. Can you help me with this? - In terms of simultaneous users access, what's more efficient, a …

  Dangskie

  13 replies

  14 years, 10 months ago

  By: bluepaperbags

• SQL SERVER 2005 32-bit Performance

  We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit wi…

  rmartinez-947829

  2 replies

  14 years, 10 months ago

  By: rmartinez-947829

• Comparing Performance from Production in test.

  Hello, I am trying to decide what the best course of action would be in regards to testing the perf…

  Duran

  2 replies

  14 years, 10 months ago

  By: Duran

• SQL Server 2005 (apparently) uses only half of the CPU's

  We have a pair of HP Integrity RX6600 servers working under Microsoft 2003 64 R2 Cluster configurat…

  Cristiano Radicchi

  2 replies

  14 years, 10 months ago

  By: Cristiano Radicchi

• Index Rebuild

  Hi All, I need to know when(date and time) the given index has been rebuild or reorganized o…

  ningaraju.n

  8 replies

  14 years, 10 months ago

  By: Adiga

• Network related issue in sql server

  Hi All, We are experiencing some performance related issues on the app server. I started my trouble…

  sandhyarao49

  3 replies

  14 years, 11 months ago

  By: TheSQLGuru

• Trace using Tuning template turn server unavailable

  I was trying to gather traces to do a database tuning. Using "Tuning" template in SQL Profiler I s…

  lluaces

  3 replies

  14 years, 11 months ago

  By: lluaces

• Execution Plans

  Hi experts A general question regarding the Memory Grants value shown in the properties of an opera…

  NickDBA

  1 replies

  14 years, 11 months ago

  By: Grant Fritchey

• Late filter causing significant grief

  Hoping someone can help me out with a confuzzlement. I've got a call going to a massively joined v…

  Evil Kraig F

  7 replies

  14 years, 11 months ago

  By: Greg Edwards-268690

• How to truncate log file in SQL Server 2005

  Hi, I have a database with ldf file size more than 300GB and my datadase size is about 70 gb. Can s…

  liewsb

  44 replies

  14 years, 11 months ago

  By: homebrew01