Topics
Started by
Posts
Last post
I'm researching a problem and realized that I still don't fully understand statistics. I have seve…
3 replies
I ran a trace with the only Event RPC:Completed (6 columns) for 21 hours and the file size is 14 GB…
9 replies
We have a SQL Server 2005 reporting environment, which is having performance bottlenecks with CPU u…
15 replies
Hi friends, Am load testing a complex query in sql server. I monitor the time for the amount of dat…
2 replies
Hi friends, I am running a query which involves a 11 tables with millions of records in each table.…
2 replies
Hi all. I want to get the average response time of a query without using profiler or traces. The ob…
11 replies
Hi All, I have a issue where the below View sometime takes too much time to give the resluts and ma…
2 replies
Please help! Here is a table with simple values create table #LAYOUT ( id int identity primary key…
1 replies
Hi, I'm trying to get a better (or should I say simple!) understanding of fragmentation and indexes…
6 replies
I'm working on optimizing some procedures, and my changes aren't having the desired effects on the …
18 replies
Hi All I've been given a RAID5 only SAN to base a mixed sql2005 and 2008 cluster on. I read somewhe…
5 replies
Hi, Got a simple query using user defined scalar functions that splits names & addresses based…
5 replies
i would like to know how many views can be created for a table and can we create views for system t…
3 replies
I query the system DMVs sys.dm_exec_cached_plans and sys.dm_exec_query_plan to get the cached query…
16 replies
We use two SQL-Server 2005. One for Tests and the other one for production. The production System h…
7 replies
Viewing 15 topics - 1,876 through 1,890 (of 3,249 total)
You must be logged in to create new topics.