If you ask if database is in use, yes it is in use (inserts, select, updates etc). The counter 'Number of Deadlocks/sec' doesn't change, i don't...
Hi, i have enabled Data Collection and the Data Collection set Server Activity stops after attempts with the Message "A deadlock was detected while...
Hi everyone, i have enabled data collector (management data warehouse) on a sql server 2008 and i was wondering if i could overview it not from ssms...
Thank you very much! It works of course.
Hi everyone, i have a table with a column that is nvarchar and contains words and a date like dd/mm/yyyy. I try to run a select query with a where...
Database tempdb is in simple recovery model, the tempdev file grows up.
I run checkdb on tempdb database and nothing found.
Hello everyone, my system is sql server 2005 standard edition and i noticed that database tempdb is growing continuously. Running a script that...
Hi, can i monitor what writes in the transaction log? It grows continuously and i would like to check what transactions writes. With profiler can i...
Hi, i try to setup peer to peer replication with private network on sql server 2008 but traffic is still flowing via the public network, I tried...
If you run my script you will see that brings you only the date without time, sec etc. Thank you anyway.
This was very helpful. I wrote it like this to get results of the today day: DECLARE @dt as DATE SET @dt = getdate() SELECT * FROM...
Hi everyone, i'm trying to script this: SELECT * FROM [msdb].[dbo].[backupset] where backup_start_date like '2010-01-%' but i think the sql...
There are about 20 rows with docs per day.
There is only one row per doc with a unique number which is the same in both tables.
Hi everyone, i have two tables with columns like this: table1 DOC WORD_COUNT 1848023 221 table2 DOC CREATION_DATE 1848023...
Hi, my system is windows server 2008 R2 enterprise with RAM 64GB and i want to install sql enterprise 2008, what should be the appropriate page file...
Hi, i have a sql 2008 server can i schedule a full backup job with copy-only option? Thank you in advance.
Log shipping means that i can not have backup files nowhere else but only in secondary server as i can not have full backup or log backup (because...
Hi, i was thinking if i could have two log files with the same data. I mean if transactions could be written in two destinations so as to use them...
Separate names with a comma.
