Viewing 15 posts - 346 through 360 (of 1,131 total)
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...
SQL = Scarcely Qualifies as a Language
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:...
SQL = Scarcely Qualifies as a Language
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
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
July 31, 2008 at 3:06 pm
spid dbid ObjId IndId Type Resource Mode ...
SQL = Scarcely Qualifies as a Language
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
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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)...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
July 18, 2008 at 4:32 pm
From BoL "Creates single-column statistics for all eligible columns for all user tables and internal tables in the current database."
The only situation where this should be considered is when all...
SQL = Scarcely Qualifies as a Language
July 18, 2008 at 4:21 pm
Viewing 15 posts - 346 through 360 (of 1,131 total)