We are trying to set up active/active cluster, could we have the same db name on each node? How does it work if one node failover ( all db on one...
I have migrated DTS to SSIS using wizard, I can see it under MSDB when connecting Integration Service, and I would like to open it from BIDS to do...
Thank you. There are about 40 db on this server, with 2 big ones over 150G, and the rest db from 1G to 30G. No, I did not fo the trace yet, do you...
sql server 2005 standard version sp3 64bit, activce/passive cluster on window cluster server 2003 64bit 96G RAM, 16cpu Recently we are experiencing...
three table t1 one col with 3 row 1 2 3t2 two col one row 25t3 one col with 4 row 1 2 3 4I would like to insert the value from t1 into t3, but need...
we have a script to delete soome history data older than 2 weeks, is these space released to database? Or I need to shrink the database to let other...
I would like to do a index analysis on a database.I have some basis idea of steps:1, re-index 2, run a report of non using index3, run a report of...
Thanks for your reply. it is a nonclustered index. We have a existing similar index already. to drop it is to test if that really make things work....
we have weekly refresh of our db, right after refresh, we find one function in application is hanging, then we find out the script of that function....
Any one has any idea about the list of security setting for setting up a db server? something as a best practise of setting up a db server, such as...
Does anyone has the experience of downgrading the sql 2008 to either 2005 or 2000? Thanks
Thanks for your reply. But I checked all db, it looks fine, neither is set on single user access. I also create another log in, stil have the...
I have a sql sever 2000, there are several sql server instance on this server but just find out, suddenly, the connection either uaing Query Analyer...
I have schedule some db change, reindex job, but sometime it will conflict with other process, is that a good idea to set the database on single user...
Is there a way to configure Query Analyzer (QA) to use an SSL port when connecting to a remote sql server. The issue is that when using QA the...
I have a sql 2000 server which have over 100 databases. I would like assign the db_datawriter to a login, is there an easy way to do that, instead of...
Thnaks for your reply. But that is not the point. I need to backup the file across the severs, is there any better way to control this? Thanks.
I would like to backup a database across severs ( write a bak file onto a nother sever). So I create a shared folder on the destination sever, then...
One of our sql server (2005, 64 bit), I just noticed it has very high PF Usage from the window task maanger It showes the high PF Usage as 16 G. Here...
Is there a limitation for number of column in one table? Micosoft documentation say it is 1024 for one table. We have a table have about 234 column...
Separate names with a comma.
