Topics
Started by
Posts
Last post
Hi all, Having used SQ server daily for many years, I have finally found the need/time to use execu…
0 replies
Hi All,I am going through a strange issue. We have a very simple file processing system with users …
5 replies
I apologize for such a general question, and there is not enough info for a detailed answer, but AN…
6 replies
By: mig28mx
Hi all,I recently changed CTFP=15 on my producion server. Why I use that number and not the 50 rule…
3 replies
By: Sue_H
Hello: How is it possible to get the SAME index name for the SAME table but the Index ID is differe…
2 replies
Hi all,I don´t know if the subject it is correctly named, because all performance issue it is weir…
2 replies
Hi, I wanted to know if setting Auto Update Statitics to TRUE will be good for OLTP environment. Mi…
2 replies
Dear All,I have a Lead table with below fields.LeadId int (Not a primary key)Telephone......Table&n…
23 replies
The following query takes somewhere between 30 to 35 seconds to complete. Can something be do…
7 replies
Dear All, I have a table and it just have 34K rows in it. I have a non clustered index on a date co…
9 replies
Hi all.Recently I have found with the help of one of the Bent Ozar, scritps. One called spBlitzCach…
5 replies
Dear Folks My below query was working fine before 2 days at my prod environment (SQL Server 2008 R2…
2 replies
Hi All,I have optimized one store procedure. Original is taking 35 seconds to take data and new SP …
1 replies
HI allI am not much of a DBA but find myself in a situation where I need to learn really fast. We h…
15 replies
Hi We run SQL Server 20008R on Windows Server 2008R on HyperVWindows Machine is dedicated to run S…
6 replies
Viewing 15 topics - 16 through 30 (of 635 total)
You must be logged in to create new topics.