Topics
Started by
Posts
Last post
After 12 hours of analyzing, DB Tuning Advisor started step 4 "Generating Reports", but finished wi…
2 replies
I have both reporting and operational systems.. So looking at each system.. what becomes a good poi…
15 replies
Queries set statistics time on SELECT [SalesOrderID], * FROM Sales.SalesOrderDetail WHERE Product…
2 replies
I have a server running 2003 Enterprise x64 Edition SP2 Build 3790 OS and SQL Server 2005 (9.00.525…
3 replies
hello All, Can someone suggest me a scrpit or a command that can provide me information about last …
2 replies
I am in the process of creating a stored procedure which will be used for searching database tables…
5 replies
Dear All, I was trying to implement mirroring in one of my TEST server. After the configuration I …
17 replies
Hello, I have a database used for reports that has a bunch of scalar functions on it that generate …
9 replies
Hi Folks, Is it possible to turn off automatic stats gathering at the table-level in SQL 2005? I wa…
2 replies
Hi, I am facing one issue in SP at prod. which is running at QA and staging within 1-2 mins. But at…
7 replies
Hi , Table A is having 1 million Records, Table B is having 100 million Records. I need to show dat…
2 replies
How can we use the parallelism in sql server. For the same query the exectuin plan at QA server the…
9 replies
Hi folks, I'm struggling to come up with ideas of how to improve the performance of the following …
5 replies
USE [PD_ODS] GO /****** Object: StoredProcedure [dbo].[sp_replicate_nxtdate] Script Date: 12/13…
4 replies
Hi All, My Clustered Index Scan is taking 87% in executation plan. can you please suggest me to how…
2 replies
Viewing 15 topics - 181 through 195 (of 3,249 total)
You must be logged in to create new topics.