I have 20 same client programs each installed in windows xp. Each client issues a specific query to…
1 year, 2 months ago
By: Grant Fritchey
I have a Siebel CRM with Sql Server back-end database (Sql server 2008 R2 but the database has comp…
I have some issue with a slow running query and im quite new to tuning and have no idea how…
1 year, 9 months ago
This is one of the incident at our clients side and does not happen regularly. A stored procedu…
By: Jeff Moden
Below query is used for inserting and updating the tables in the SQL Server database. The XQuery is…
2 years, 2 months ago
By: Eirikur Eiriksson
By: Thomas Rushton
I have a question thrown to me by my developers, according to them, they notice that on a high load…
By: Your Name Here
I notice some slowness on a select statement whenever it's selecting top n rows.
Is there anyway …
2 years, 3 months ago
By: MVDBA (Mike Vessey)
Need help to rewrite the query for faster performance.
SELECT c.otherID, a.shortname, c…
2 years, 7 months ago
Need help to rewrite the query for faster result.
SELECT c.otherID, a.shortname, c.prio…
By: Jeffrey Williams
I am running a CREATE INDEX statement for a large table (more than a billion rows). …
2 years, 8 months ago
I have a fairly simple stored procedure that checks to see if a value is present in a view. It's ho…
Last night the server team installed an additional 512GB(1TB total) of memory on the passive node o…
2 years, 10 months ago
There are four questions nee all help, many thanks!
1. when I create an index in a table or views, …
3 years ago
Having used SQ server daily for many years, I have finally found the need/time to use execu…
3 years, 1 month ago
Viewing 15 topics - 1 through 15 (of 635 total)
You must be logged in to create new topics.