Viewing 15 posts - 346 through 360 (of 1,132 total)
Thanks steveb
The forum application also remembers that you have set to view that last 10 posts, so it only needs to be set once!
August 1, 2008 at 5:05 am
Agree that not being able to see the previous post is irritating but a workaround is to open a new browser window and then the post history and a new...
August 1, 2008 at 4:41 am
In sysprocesses I see lastwaittype: PAGELATCH_SH and waitresource: 13:1:6396860.
A bit before the query completes execution I see lastwaittype: PAGEIOLATCH_SH and waitresource: 2:1:274.
I know the first number is the database id:...
July 31, 2008 at 8:04 pm
"But I forget what the 3rd number means. Any ideas? " The Page number.
Have you optimized tempdb? See "Concurrency enhancements for the tempdb database" at http://support.microsoft.com/kb/328551
July 31, 2008 at 4:14 pm
The problem is definitely a wait on tempdb system tables as reproduced in the below SQL. On sysobjects, syscolumns and sysindexes, there are "Intent eXclusive" TABLE locks...
July 31, 2008 at 3:06 pm
spid dbid ObjId IndId Type Resource Mode ...
July 31, 2008 at 12:37 pm
The 1204 and 1205 only collect information about deadlocks but to write the information to the SQL Server log file, you need to include -T3605
July 31, 2008 at 12:09 pm
Microsoft's web pages appear to have contradictory information, so recommend you call MS. I have indicated some interesting words in bold.
Let us known what you find out.
From http://www.microsoft.com/sql/editions/developer/default.mspx:
Developer Edition...
July 31, 2008 at 8:47 am
As an alternative, extract directly into files and then load the files into Box 3. These would eliminate the steps of loading into tables on Box 2 and then...
July 31, 2008 at 6:24 am
By default, an index created using the Management Studio GUI will have page locks set to off. You can change the index properties by running:
ALTER INDEX index_name ON table_name...
July 25, 2008 at 11:17 am
DTS packages can be exported to a file and then imported into SQL Server if saved in the structured format but not if saved in VB format.
There is a utility...
July 25, 2008 at 4:38 am
The "UNION" solution will work but will require a temporary table whose size will be the number of rows from all three tables. Here are 3 SQL Statements that...
July 23, 2008 at 11:57 am
When the array accelerator battery charge is low, then the write cache will be temporarily disabled until the batteries either become fully charged or are replaced. The disabling of...
July 23, 2008 at 11:43 am
"My Average Wait Time was 6. " No too bad, so now look at more detail:
select * from (
SELECT cast( IoStallMS as float) / ( NumberReads + NumberWrites)...
July 18, 2008 at 4:49 pm
I think that you will find that if you compare performing transaction log backups versus a truncate log, then set to full recovery and then a full database backup, the...
July 18, 2008 at 4:32 pm
Viewing 15 posts - 346 through 360 (of 1,132 total)