Topics
Started by
Posts
Last post
Hi Expertz Can anyone explain to me why cursor take longer time for execution. Why cursors effect p…
10 replies
What is better, WHERE ... IN (var_1, var_2, var_3, ... var_n) or WHERE ... = var_1 OR ... = var_2 O…
2 replies
I'm running the following in order to get the top CPU-hogging queries: SELECT TOP 20 qt.text A…
12 replies
I posted this under SQL 2005 because I did not see any forums for SQL 2008. After researching the f…
3 replies
I am running 2 queries simultaneously select from dbo.Table1 except select from obeaver.RevBud.dbo…
6 replies
hi, I have a store procedure running in SQL 2005 SP2 environment. It run the same store procedure …
10 replies
Hi, i have many complains of having lock escalations in my DB, i read in an article that the best w…
11 replies
Hi All in the ms white paper on Waits & Queues (that was kindly recommended to me by grant) t…
3 replies
Hi Expetrz cursor sample set nocount on declare c2 cursor for select distinct emp.…
2 replies
Hi there I was wondering if anyone could shed some light on this system view: sys.dm_db_missing_ind…
6 replies
During my performance tuning tests I found that the number in physical_io in sys.sysprocesses does …
4 replies
Hi: What’s the difference between having an index with multiple columns and having many indexes? F…
2 replies
I'm trying to tidy up a SPROC by wrapping a CASE statement up in a function and I'm geting a huge p…
16 replies
Hello all. Can someone please help me with the problem that is driving me crazy. I have lots of con…
12 replies
I have developed some functionality that polls sys.dm_io_virtual_file_stats at regular intervals fo…
2 replies
Viewing 15 topics - 1,771 through 1,785 (of 3,249 total)
You must be logged in to create new topics.