Princiapl server in SQL 2005 SP1 and mirror Server in Sql 2005 SP1 Planning to upgrade ONLY Principal server to SQL 2005 SP2. Do we encounter any...
is day light saving time affect on sql server jobs? is there any MS article on this?
At peak I am seeing lot of memory pressure errors I am running 2k5sp2 ,win2k3 HEre is the DBCC memory status . I have seen some negative values in...
This systemp SP sys.sp_dbmmonitorupdate having this line of code i try to find this SP could not find any where any ideas?exec @retcode =...
Hello I have to resgister 240 servers . My co-worker already resgistred them in Sql management Studio. Is there anyway easy way I can copy to my...
Hello There, I have setup the plain FTP task nothing fancy. It is turnign into green however, the file which I mentioned in the task is not...
When I was watching Merge slide show. I have observed You can insert records with the following statement INSERT INTO Production.UnitMeasure VALUES...
Where can we submit suggestions for SQL 2008?<br /><br />I would prefer If they introduce the following feature in sql server 2008<br /><br />In...
Hello Team, We are running SQL 2K5 64bit on wind 2k3. It was running fine since 5/30/2007 until last firday. We submit jobs they run for at least 6...
Y'night I have started restoring one of my PROD db copy on QA server. (120GB)<br />I have submitted as a SQL SERVER JOB. So, I do not have any clue...
Hello , Here is the interested topic between me and Mike Hotek ( The inventor of Transactional replication ). If you have time read it ! I learned...
I am workign on project which I kept on hold for few week on hold. I have database 200 GB . We get weekly feeds an we load that data in production...
Hi , How to measure if we are using SAN disk( We are connected to EMC storage) . Avg Read queue length. It should be same as MS recommended ( <2 )....
Hi , I have a table which is having 130Million records(Not partitioned) based on every week. This is what i did .. 1. Created PF(Function) 2....
Can I see deadlocks(I will happen very rare scenario) after it occures can I seem them in any sql logs
I have db setup with Transactional replication (PUSH) Can I set the Database in Simple recovery mode. ? Does it deletes the transaction which are...
SQL 2K5 performing very badly than 2K . We have migrated SQL 2000 DB into SQL 2005 we are running same stored procs in 2005 they are taking more...
Hello there, Could someone help on suggest what would be the best option I have 60 GB Databse I am setting first time replication. 1. Copy /restore...
Today I have found the following problems. 1./ possible infinite recompile was detected for SQLHANDLE...
Hello, Here are my server options. I am using linked servers. Basically Server (B) gets the data from Primary server using synonms and stored into...
Separate names with a comma.
