Need help to rewrite the query for faster performance.
SELECT c.otherID, a.shortname, c…
1 month, 2 weeks ago
Need help to rewrite the query for faster result.
SELECT c.otherID, a.shortname, c.prio…
By: Jeffrey Williams 3188
I am running a CREATE INDEX statement for a large table (more than a billion rows). …
2 months, 3 weeks ago
By: Jeff Moden
I have a fairly simple stored procedure that checks to see if a value is present in a view. It's ho…
By: Grant Fritchey
Last night the server team installed an additional 512GB(1TB total) of memory on the passive node o…
5 months ago
There are four questions nee all help, many thanks!
1. when I create an index in a table or views, …
7 months ago
Having used SQ server daily for many years, I have finally found the need/time to use execu…
7 months, 3 weeks ago
Hi All,I am going through a strange issue. We have a very simple file processing system with users …
8 months, 2 weeks ago
I apologize for such a general question, and there is not enough info for a detailed answer, but AN…
1 year, 1 month ago
Hi all,I recently changed CTFP=15 on my producion server. Why I use that number and not the 50 rule…
How is it possible to get the SAME index name for the SAME table but the Index ID is differe…
By: Lynn Pettis
Hi all,I don´t know if the subject it is correctly named, because all performance issue it is weir…
1 year, 2 months ago
I wanted to know if setting Auto Update Statitics to TRUE will be good for OLTP environment. Mi…
Dear All,I have a Lead table with below fields.LeadId int (Not a primary key)Telephone......Table&n…
1 year, 3 months ago
Viewing 15 topics - 1 through 15 (of 627 total)
You must be logged in to create new topics.