Viewing 15 posts - 33,301 through 33,315 (of 49,552 total)
dba_neo (3/29/2010)
March 29, 2010 at 9:01 am
sqlsc-1053844 (3/29/2010)
March 29, 2010 at 8:58 am
Jack Corbett (3/29/2010)
... but the time change and amount of natural light has little to do with how well I function prior to finishing my coffee and 10am arriving.
So glad...
March 29, 2010 at 8:55 am
On SQL 2005/2008, log backups will successfully run while the full backup is running.
March 29, 2010 at 8:55 am
Only if the database is in full recovery model, there have been no log backups since the February backup (or if there have, you have them), the log has not...
March 29, 2010 at 8:52 am
chowdary.gb (3/29/2010)
EXEC sp_resetstatus 'yourDBname';ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER
No! No! No!
That is the last resort for...
March 29, 2010 at 8:50 am
Paul White NZ (3/29/2010)
GilaMonster (3/29/2010)
The row locator is technically (refer to what Bob posted) the RID on a heap and the cluster (plus uniqueifier if necessary) on a cluster
So now...
March 29, 2010 at 3:02 am
Paul White NZ (3/28/2010)
GilaMonster (3/28/2010)
March 29, 2010 at 2:25 am
Paul White NZ (3/28/2010)
GilaMonster (3/28/2010)
SwePeso (3/28/2010)
All records do have a "hidden" record identifier, when there is not primary key on the table.
I assume you mean 'clustered index', not 'primary key'.
The...
March 28, 2010 at 11:06 am
Garadin (3/28/2010)
My gut was telling me that was the case, but my google skills apparently failed me. I couldn't find anything on it. Anyone have a link?
March 28, 2010 at 10:07 am
SwePeso (3/28/2010)
All records do have a "hidden" record identifier, when there is not primary key on the table. That's the way SQL Server distinguishes between two identical records.
I assume you...
March 28, 2010 at 9:55 am
Lynn Pettis (3/28/2010)
March 28, 2010 at 9:53 am
wilmoslee 83606 (3/28/2010)
hi.. really no one can help?? 🙁
This is a forum, not a chat room. Be patient. Expecting someone to attend to your query in an hour over a...
March 28, 2010 at 2:56 am
There's a backup, restore or similar operation running on that database already. Also the source of the log reuse message.
Can you query sys.dm_exec_requests and see what's running on that database?
March 28, 2010 at 2:55 am
RBarryYoung (3/27/2010)
The involvement of ServiceBroker seems particularly odd to me. Are you perhaps using Database Mirroring?
That's normal. On 2008 (and 2005 iirc), when CheckDB is run and the NO_INFOMSG...
March 27, 2010 at 1:55 pm
Viewing 15 posts - 33,301 through 33,315 (of 49,552 total)