Topics
Started by
Posts
Last post
I have a base table where in text file loads every day and once in a month data is exported from th…
5 replies
I have seen this thread - I recommend formatting the disks with 64KB. If applicable, perform a sect…
2 replies
I have a function that contains the following query which is always timimig out. select distinct @R…
57 replies
64 bit SQL 2005 standard SP 2. Changed the min memory to 1024 and max to 6 gig. Did the lock in me…
7 replies
Our application has almost no updates to most tables. Only Inserts and Reads. I changed each query …
14 replies
Hi, We have a table with a few hunderd million rows of data in it. It is partitioned based on a dat…
4 replies
Hi Every body, right know am working with performace tunning little bit confuge to working this o…
2 replies
I am having a strange dilemma where the page life expectancy counter is dropping to around 200-300 …
15 replies
CREATE PROCEDURE [dbo].[getScreenProvider] @p_resultSize SMALLINT = 12, @p_Provi…
3 replies
Hello Everyone, We have a small table on which we execute queries: [font="Courier New"]Column_name …
21 replies
Hi all, I've seen several mentions of a "catch-all" query, where the "where" statement has several …
14 replies
Dear All, Can anyone brief me how to use "ACTIVITY MONITOR" ?. I am seeing 2 processes in "Locks by…
6 replies
Dear All, In one of my table there are only 2 fields. 1 autoincrement column 2 varchar column. pre…
2 replies
Dear All, I was configuring mirroring on my TEST servers. I could configure it succesfully (I din't…
6 replies
I am testing out the profiler/DB tuner and can not seem to make it work together. I removed a key …
2 replies
Viewing 15 topics - 1,831 through 1,845 (of 3,249 total)
You must be logged in to create new topics.