Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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)
Data Profiling using T-SQL queries  

CeliweM 4 66 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 90 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 4,288 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 1,284 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 116 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  
Has Attachments!
coolchaitu 5 191 Monday, September 7, 2015 7:24 AM
Last Post By: GilaMonster
Topic (New Replies)
Huge difference between estimated rows and actual rows  
Has Attachments!
coolchaitu 5 248 Friday, August 21, 2015 11:34 AM
Last Post By: yb751
Hot Topic (New Replies)
Long running Select Query  
12 Has Attachments!
coolchaitu 15 569 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  
125 Has Attachments!
coolchaitu 48 1,945 Thursday, August 13, 2015 1:28 AM
Last Post By: coolchaitu
Topic (New Replies)
Select query in a stored procedure running for long time  
Has Attachments!
coolchaitu 8 317 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 345 Thursday, July 30, 2015 2:36 AM
Last Post By: tomullus 69522
Topic (New Replies)
Duplicate Index...or am I missing something?  

yb751 7 435 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 361 Friday, July 10, 2015 6:44 AM
Last Post By: Grant Fritchey
Topic (New Replies)
Stored Proc vs Inline Queries  

GonnaCatchIT 1 304 Wednesday, June 24, 2015 11:55 AM
Last Post By: Jack Corbett
Topic (New Replies)
To create login in many servers.  
To create login in many servers.

Saravanan T 5 1,075 Saturday, April 25, 2015 9:13 AM
Last Post By: Steve Jones - SSC Editor


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