Viewing 15 posts - 45,241 through 45,255 (of 49,571 total)
Grant Fritchey (8/8/2008)
Page splits, rearranging the order of pages, becuase of updates or inserts. Also gaps left by deletes.
Shrinking the database or the data file.
August 8, 2008 at 8:22 am
Interesting, and unrelated to the file name issues.
Got a network admin there? First thing you need to do is figure what's listening on port 2987.
August 8, 2008 at 8:20 am
I'll be blunt. There's little point in indexing that. The multiple constant comparisons and ORs confuse the optimiser, plus there is no one stable, optimal plan for it. It will...
August 8, 2008 at 8:06 am
Did you move the ldf file? Alter database just changes the metadata, it doesn't move the physical file. You have to do that yourself.
Shut SQL down, find the log file...
August 8, 2008 at 7:55 am
usman.tanveer (8/8/2008)
But what is the best practice or general practice for creating indexes?seperate index on each column...
August 8, 2008 at 7:43 am
majorbloodnock (8/8/2008)
GilaMonster (8/8/2008)
Someguy (8/8/2008)
I'm surprised how many of the readers here are into martial arts.
There's an interesting correlation between IT (and the wider science field) and martial arts. When...
August 8, 2008 at 7:41 am
Kumar (8/8/2008)
You could shrink the file or bounce the SQL Instance... 🙂
If the file is full (no free space within) then shrinking the file (releasing free space within the file...
August 8, 2008 at 7:38 am
If you are using more than 4 GB on a 32 bit system, you need AWE. Otherwise the max that a process can use is 2GB (or 3GB with /3GB)
Do...
August 8, 2008 at 7:37 am
Muhammad Tariq (8/8/2008)
can you try using table level lock hint? e.g. with (nolock), i found some times non-ignorable outcomes by using this hint.
Ow. Table and locking hints should be the...
August 8, 2008 at 7:13 am
Christopher Stobbs (8/8/2008)
Also is this just simply a matter of manually droping and recreating the indexes?
ALTER INDEX ... REBUILD
Don't do it while the systems are in use. It's a maintenance...
August 8, 2008 at 6:58 am
Very hard to say without seeing the queries and maybe the table definition.
August 8, 2008 at 6:54 am
The order which you specify the tables has no effect. The optimiser will join the tables in the order it considers most optimal.
Can you post the definition of the tables,...
August 8, 2008 at 6:54 am
Someguy (8/8/2008)
I'm surprised how many of the readers here are into martial arts.
There's an interesting correlation between IT (and the wider science field) and martial arts. When I was...
August 8, 2008 at 6:45 am
Auto create stats on, auto update stats on. If you find stats that aren't getting updated often enough, or find ones where the sampling is too low, create a job...
August 8, 2008 at 6:44 am
Is this for a test, homework, an interview or similar?
August 8, 2008 at 1:59 am
Viewing 15 posts - 45,241 through 45,255 (of 49,571 total)