Viewing 15 posts - 29,611 through 29,625 (of 49,552 total)
vgv8 (11/1/2010)
I have difficulties to interpret this result - a clustered table but no index (page)
Why's it hard? With a single page there's no need for the b-tree structure, and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 8:24 am
I also ran several times and the results are consistant. Two rows in each case. Sure there's not something else different between the databases?
DBCC IND shows all pages related to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 6:55 am
I tried in a new database and an existing (and well-used) database, two rows in both.
1 row with a page type of 10, one row with a page type of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 6:12 am
Because SQL needs somewhere to put the new index and because index rebuilds are fully logged in full recovery.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 6:02 am
Post the exact code that you ran to create the tables and exact DBCC commands. I'd rather not guess.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 5:33 am
What questions?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 5:07 am
eg:
select
db_name(database_id) as DatabaseName, file_id, physical_name, cast(size*8 as varchar(20)) + ' KB' as size,
case max_size when -1 then 'unlimited' else CAST(cast(max_size as bigint)*8 as varchar(20)) + ' KB' end as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 4:05 am
With the exception of the filegroup, you can get all of this info from a single query of the sys.master_files view.
No cursors necessary.
Sysdatabases should not be used any longer....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 4:02 am
GilaMonster (11/1/2010)
If the DB is in full recovery are you doing your log maintenance properly? What's preventing the log from being reused? (check log_reuse_wait_desc in sys.databases)
How much of the log...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 3:48 am
When you specify UNIQUE in the table's definition you're not creating a unique index, you're creating a unique constraint.
It's equivalent to this:
CREATE TABLE t (
a NVARCHAR(100) SPARSE NULL
)
ALTER TABLE t...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 3:41 am
Both heaps and all indexes have one or more IAM pages to indicate what extents are allocated to that heap/index. The cluster is no different to a nonclustered index here,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 3:29 am
Spam. Reported. No replies please
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 3:20 am
If I'm not mistaken, there's no space in the log to be released. Btw, truncateonly is NOT a valid option for shrinking a log file. It's for data files only.
If...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 3:18 am
Change DETAILED to LIMITED
If both that and the rebuild are taking forever either the table is huge or your IO subsystem is not up to the load, or both.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 3:14 am
Sounds like a trigger may be necessary.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2010 at 3:13 am
Viewing 15 posts - 29,611 through 29,625 (of 49,552 total)