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...
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...
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 everyone, i'm trying to script this: SELECT * FROM [msdb].[dbo].[backupset] where backup_start_date like '2010-01-%' but i think the sql...
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.
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...
Hi, i want to install sql 2008 enterprise on two nodes and setting up a peer to peer transactional replication but i want the two instances to use a...
Hi, i have set up a peer to peer replication (2 nodes, w2k8, sql 2k8 enterprise) and the 'Expired subscription clean up' job failed with error...
Hi, how can i add a database role to one user for all databases? Thank you.
Hi, i have two cluster systems 2k3 (two nodes and two nodes with sql server 2005 installed) with replication running between one instance on one...
Hi, i tried to add local administrators group as new login in sql 2008 like builtinadministrators in sql 2005 but i can't. The error is "Error...
Hi, i want to copy indexes from one table to another and not create them one by one because there are many. Is that possible? Thanks in advance.
Hi everyone, i want a query that delete rows from a table that are older than 3 days. There is a column with the datetime. Thanks in advance
Hi, before installing a sql 2008 enterprise cluster i would like to ask about the permissions of the domain user that i logon to setup sql server...
Hi, i want a system of four sql servers that have the same data on a single database per server, one of them updates the others and all of them can...
Hi, i was thinking to set up a Bidirectional Transactional Replication between two cluster systems (two pair of servers , two instances sql standard...
Separate names with a comma.
