Topics
Started by
Posts
Last post
When I set statistics profile 'on' in the query window and run a complex query, it gives a lot of i…
2 replies
Does the forum have any opinions on the use of one trigger (on update say) which contains all logic…
2 replies
I am trying to isolate why my queries have stopped using a helpful index. I ran show_statistics on …
5 replies
I think the order of column in a compound index is very important--i.e. it should be defined as (hi…
1 replies
Hey guys, I have recently moved a database from on 6.5 server (v6.50.416) to another server (v6.50.…
6 replies
Hi all From what I can gather, all of the standard dbcc routines for online re-indexing (defrag) do…
2 replies
Hi all Had a very strange one today. The nasty query below generates a very different plan on my T…
4 replies
It's the end of the day and I've just discovered that a few of my stored procedures recompile every…
1 replies
I'm trying to create an Extract from source data that is too complex to be created as a view (also …
3 replies
How to minimize external fragmentation without any tool as we dont have any fragmentation tool? I t…
1 replies
I have a stored procedure consisting of multiple IF statements that union the various queries toget…
7 replies
Okay, If I do a select * from table1 where <conditions> the query is speedy and making me ha…
1 replies
We have a couple of complex processes that generate thousands of rows spread across four tables. T…
1 replies
CASE 1 Usual steps load data 1. table is created 2. data is inserted 3. clustered index created CAS…
3 replies
Hi Guys, We are using SQL Server 2000 as our database and Visual Foxpro as our application. In som…
3 replies
Viewing 15 topics - 2,476 through 2,490 (of 2,581 total)
You must be logged in to create new topics.