hope someone can help me get a bit more educated with sql server.

if i have a clustered index on an identity column and insert a row, what lock is taken?...

actually, i think this works.

SELECT name FROM master..sysdatabases

WHERE substring(convert(binary, status),len(convert(binary, status))-1,1) <> 0x02

problem with that is you need to change the database context for each database or create some kind of loop to change the database name in the function. i...

or use this....

SELECT db_name(database_id),name,physical_name ,state from sys.master_files

its probably deleting errorlog.6 then and moving everything else up one so it looks like errorlog.1 has been deleted and not moving the current errorlog to errorlog.1

it looks like running sp_cycle_errorlog actually deletes the archived files from 1 to the max number. so 5 runs of the SP will delete errorlog.1 thru to errorlog.5. ...

nope, neither exec Sp_Cycle_ErrorLog or dbcc errorlog works before or after a checkpoint. cant restart the service as its prod. damn!!!!!!

it returns the archive number, date, log file size

archive number = 0

date = about 1 min ago

log file size = 4G

anyone know a fix for this? i've got a 4G error log that wont recycle 🙁

take the db offline. see if anyone complains.

or setup a job that snapshots sysprocesses for a certain amount of time and check the dbid column.

i thought 431 was the most difficult exam on the DBA certification.

if i remember correctly, there were 6 case studys with each case study having between 4 and 12 questions.  the time for each case study ranged from 20 mins to 40 mins. ...