Viewing 15 posts - 766 through 780 (of 2,387 total)
quote:
Error executing extended stored procedure: Specified user can not login
Has this user been granted...
December 17, 2003 at 12:33 pm
Each data page has a 96-byte header containing system information such as the identifier (ID) of the table that owns the page. The page header also includes pointers to the...
December 17, 2003 at 12:27 pm
select IDENTITY(int, 1,1) AS RecNum, * INTO #NewTable from yourtable
select * from #NewTable
December 17, 2003 at 12:23 pm
From BOL.
"DBCC CHECKTABLE checks that:
Index and data pages are correctly linked.
Indexes are in their proper sort order.
Pointers are consistent.
The data on each page is reasonable.
Page offsets are reasonable. "
DBCC...
December 17, 2003 at 11:56 am
quote:
we still find it filling up all the additional space on the server (mostly in the transaction log).
December 17, 2003 at 11:48 am
I wouldn't simply remove BEGIN and END TRANSACTIONS. BEGIN TRANSACTION represents a point at which the data referenced by a connection is logically and physically consistent. If errors are encountered,...
December 17, 2003 at 11:35 am
Before issue shrink command, make sure your current database is the correct one you want to shrink.
use pubs
go
dbcc shrinkfile (pubs_data, 10)
go
December 17, 2003 at 10:07 am
You can configure Alert to send out net message/pager/email to appropriate personnel.
December 17, 2003 at 9:28 am
quote:
What are the possible reasons why an index becomes corrupt?
Hardware Disk Subsystem failure.
December 17, 2003 at 9:25 am
Use sp_helpfile or statement from the sp_helpfile below.
select name, fileid, filename,
filegroup = filegroup_name(groupid),
'size' = convert(nvarchar(15), size * 8) + N' KB', ...
December 17, 2003 at 9:15 am
quote:
2003-12-16 21:09:11.64 server Attempting to initialize Distributed Transaction Coordinator.2003-12-16 21:09:11.66 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
December 17, 2003 at 9:05 am
It depends on how your application query the table.
I would create clustered index on
Queries that return large result sets
Columns used in order by or group by queries
Columns used in table...
December 17, 2003 at 8:17 am
Setup an SQL Server Performance Condition Alert on counter Percent Log Used in SQL Server Agent.
Or create script to get log file size and schedule it to run regularly.
December 17, 2003 at 8:03 am
Viewing 15 posts - 766 through 780 (of 2,387 total)