Topics
Started by
Posts
Last post
I have optimized these two tables & queries and have almost no table/index scans. Odd thing is…
4 replies
Hi Folks, I am getting a lot of spikes on Page/sec, it is averaging from 25-50? but the my % Disk…
4 replies
Hi, Can anyone offer any suggestions on how we might tune the following? select a.ApplicationCode a…
5 replies
I am trying to do some index maintenance on a few tables using the dm_db_missing_index_detail dyna…
5 replies
I have two tables tempa and tempb both containing same type of informations with common columns say…
3 replies
I have a proc that has several temp tables the join to my 'real' table. For example: UPDATE #event…
3 replies
I optimised my queries using Tuning Advisor, which suggested that some indexes be created. Some of …
5 replies
I would like to REORGANIZE index in my table. Is that possible to do that using DTS packages.
1 replies
I'm not that familiar with Functions. The programmers once had this in the SQL statment & mov…
10 replies
Does anyone know if there's a way to see what is going on when altering a partition function (like …
7 replies
Just wondering if there's an easy way (or just a 'way' for that matter) to get statistics on how of…
1 replies
Hallo, In SSIS package I have SQL task, which is (I think) optimized. This task consists of 4table…
3 replies
I'm getting a major slowdown on a Top N sort. Here's the part that so slow: UPDATE #events SET us…
32 replies
I would like to know following: 1- How much by default SQL Server 2005 takes physical memory? and h…
4 replies
The team I work on does nothing but data conversions. We convert data for new customers from their…
5 replies
Viewing 15 topics - 2,176 through 2,190 (of 3,249 total)
You must be logged in to create new topics.