Topics
Started by
Posts
Last post
A customer has reported speed issues in our application Since I don’t understand the below statisti…
1 replies
SQL Server 2008 R2 SP2, the cpu spikes, but I can't find out which process causes it. Thanks in adv…
1 replies
how can we track any database performance issues for last week?? (in a particular date/time). Any D…
2 replies
Hi, I have following query which is taking 30 sec to execute . Can anyone please suggest me that h…
15 replies
Does anyone have any scripts which show how nolock can produce duplicate records in a select statem…
6 replies
have 2008 r2 server have had some disk issues before. Today went off the charts. have Idera DM wh…
10 replies
I have used olahalegrean scripts for database maintenance, we have large table of size ~170GB it us…
7 replies
Hi All, Server: MSSQL Server 2008 enterprise Edition Dell R710 60GB RAM 2 Processors Xeon E5520. D…
9 replies
I have a stored procedure which I've inherited and I'm having a few performance issues. When the st…
1 replies
with indexcols as ( select object_id as id, index_id as indid, name, (select case keyno when 0 then…
7 replies
Hi, I need to select a aggregate of column from a large table having 75 lakh records. There is no i…
5 replies
Research has shown me this is like arguing religion, for a 128 GIG 48 core SQL 2008 R2 Enterprise e…
1 replies
IT Pro with basic SQL administration skills. Asked to start 'looking into' performance related iss…
3 replies
My Server is slow, I am planning add the memory and CPU as it is virtual, I just want track the per…
1 replies
I am testing SSD's with SQLIO to find R/W performance. how we can determine whether it is good or n…
3 replies
Viewing 15 topics - 196 through 210 (of 636 total)
You must be logged in to create new topics.