SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• what's faster? retrieving data via a stored procedure or function

  I need to get the credentials of staff in my database as one value. Problem is they can have more t…

  K Currie

  1 replies

  14 years ago

  By: Grant Fritchey

• How many CPU's are needed on the SQL Server.

  Hi, I have a development machine which has 16 GB of RAM with just 2 CPU's on it. I have around 15 d…

  Satnam Singh

  1 replies

  14 years ago

  By: GSquared

• Do's and Don'ts for "Parallelism"

  Hi Techies, I am an ETL developer. Of course, everyday I will be working with millions and millons …

  Vijay Vasudevan

  13 replies

  14 years ago

  By: Grant Fritchey

• Searching/Querying Records from Database

  Hi this might be little bit dumb. But i wanna know is there any standard or efficient way of query…

  hellolasantha

  6 replies

  14 years ago

  By: Lowell

• Seeing no change after applied DTA recommendation

  I used DTA to tune a slow query in SQL 2005. DTA recommend to create an index, and it would improve…

  Maple07-598122

  11 replies

  14 years ago

  By: Gail Shaw

• SQLSERVR.exe *32 Peak Mem Usage > 3GB (!?)

  Was perusing Task Manager on my XP x64 box, and noticed this anomaly. What would explain the Peak …

  Ronzo

  2 replies

  14 years ago

  By: paul.knibbs

• Getting Session History in SQL Server

  Dear friends, I am curious to know, is it possible to get reports of previous sessions in SQL Serve…

  Divine Flame

  10 replies

  14 years, 1 month ago

  By: Orlando Colamatteo

• Database mail Configuration

  Hi, Is there any issue/effect to Production servers,If we configure database mail for database aler…

  ravisamigo

  2 replies

  14 years, 1 month ago

  By: ravisamigo

• blocking

  how can I find how long the process is being blocked in SQL server?

  sqlfan

  8 replies

  14 years, 1 month ago

  By: Medhatithi Guha

• Non clustered index not getting used for sorting on a large SQL 2005 table.

  Hi All. We've a SQL Server 2005 partitioned table which has over 2.5 Billion records. I've Two colu…

  roshanjayalath

  2 replies

  14 years, 1 month ago

  By: TheSQLGuru

• online = on index option

  Sorry of I am posting in the wrong place, but I cannot find where the metadata I am loking for is f…

  duncfair

  14 replies

  14 years, 1 month ago

  By: Ninja's_RGR'us

• Can REBUILDING the index cause deadlock?

  Hi, SQL Server 2005 64 bit Database was working fine. Nothing else has been released or changed sin…

  iBar

  10 replies

  14 years, 1 month ago

  By: iBar

• Cleaning Duplicate Data

  Hi, Everyone. I need help in improving the performance of our clean up script to remove duplicate d…

  James Tech

  10 replies

  14 years, 1 month ago

  By: Jeff Moden

• Disk parameters from DMV

  Can I get the following information from any Dynamic Management views in SQL % Disk Read Time (All …

  jaya

  1 replies

  14 years, 1 month ago

  By: Chuck Hottle

• No Parallelism When using Row level function

  Hi Techies, I encountered new wierd behaviour (Atleast to me). Please give me your ideas and the re…

  Vijay Vasudevan

  29 replies

  14 years, 1 month ago

  By: Johan Bijnens