Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On


SQL Server 2005 Performance Tuning Expand / Collapse
TitleStarted ByRepliesViewsLast Post
Topic (New Replies)
Missed hostnames and logins in SQL Auditing  

SSRfromChennai 2 1,950 Wednesday, February 10, 2016 2:50 AM
Last Post By: Ruggiero Lauria
Topic (New Replies)
Data Profiling using T-SQL queries  

CeliweM 4 432 Monday, November 23, 2015 2:57 AM
Last Post By: CeliweM
Topic (New Replies)
Derived table in linked server query behaving as a subquery -- 1 execution per row  

DavidL 0 320 Wednesday, October 28, 2015 9:09 AM
Last Post By: DavidL
Hot Topic (New Replies)
Creating Clustered index on a large table  
anish_ns 18 5,545 Monday, October 19, 2015 3:05 PM
Last Post By: Jeff Moden
Hot Topic (New Replies)
Percentage of Fragmentation increased after 6 hours  
coolchaitu 33 2,394 Saturday, September 12, 2015 3:14 AM
Last Post By: Kristen-173977
Topic (New Replies)
Monitoring for SQL server performance issues  
Has Attachments!
ThompsonAdmin 0 355 Friday, September 11, 2015 7:29 AM
Last Post By: csawyer 76318
Topic (New Replies)
Blocking due to access_methods_scan_range_generator and Latch_Ex  

coolchaitu 5 524 Monday, September 7, 2015 7:24 AM
Last Post By: GilaMonster
Topic (New Replies)
Huge difference between estimated rows and actual rows  

coolchaitu 5 559 Friday, August 21, 2015 11:34 AM
Last Post By: yb751
Hot Topic (New Replies)
Long running Select Query  
coolchaitu 15 1,078 Friday, August 21, 2015 5:14 AM
Last Post By: coolchaitu
Hot Topic (New Replies)
A stored procedure that usually runs fast ran for a long time yesterday  
coolchaitu 48 3,171 Thursday, August 13, 2015 1:28 AM
Last Post By: coolchaitu
Topic (New Replies)
Select query in a stored procedure running for long time  

coolchaitu 8 630 Sunday, August 2, 2015 8:38 AM
Last Post By: Eirikur Eiriksson
Topic (New Replies)
Query inside an IF statement runs forever  

tomullus 69522 8 669 Thursday, July 30, 2015 2:36 AM
Last Post By: tomullus 69522
Topic (New Replies)
Duplicate Index...or am I missing something?  

Y.B. 7 698 Friday, July 24, 2015 3:49 PM
Last Post By: Alexander Suprun
Topic (New Replies)
SID Makes Query Slow in Clustered Column store? Execution Plan increased though CPU Time came down.  
Has Attachments!
West822 5 679 Friday, July 10, 2015 6:44 AM
Last Post By: Grant Fritchey
Topic (New Replies)
Stored Proc vs Inline Queries  

GonnaCatchIT 1 517 Wednesday, June 24, 2015 11:55 AM
Last Post By: Jack Corbett


Permissions Expand / Collapse

Topic Key Expand / Collapse
Topic (New Replies)  Topic (New Replies)
Topic (No New Replies)  Topic (No New Replies)
Hot Topic (New Replies)  Hot Topic (New Replies)
Hot Topic (No New Replies)  Hot Topic (No New Replies)
Poll (New Replies)  Poll (New Replies)
Poll (No New Replies)  Poll (No New Replies)
Closed Topic  Closed Topic
Moved Topic  Moved Topic