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...
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...
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
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...
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...
Is there a way to do some kind of lock (deadlock) analysis on databases? Somehting like number of lock during a period of time, etc... Thanks
Is there any max connection to sql serve 2005? There is a max of 32767 max works threads for sql server 2005, currently our server user connection (...
We are suing veritas sql backup to backup our sql server database, We have some customer complaining about the performance issue, is there any issue...
I am trying to use performance monitor to get some counter data ,for example: memory: pages/sec . But how can I get the average, min, and max...
Separate names with a comma.
