Hello. Actually I'm using an UDF to retrive a simple string value. So in my procs I have some code like: declare @Ret varchar(30) select @Ret =...
Hi. I was trying run Maintenance Database Wizard, with the Rebuild Index option. The main objective is reduce fragmentation It is a 70GB database,...
Hi. I'm doing some performance tests, and I need to split a 90gb database in 3 datafiles. I created the others datafiles, and of course they are...
I finished a SQL2000 to SQL2005 (in the same server) upgrade, but I noticed that my MASTER database is still in SQL2000 compatibilty level. MSDB,...
Hello. I put this topic in SQL2000 forum, but I'm planning upgrade SQL Server next month. Considering a database with 80GB (datafile), using a 1+0...
Hi. Considering a database with 80GB (datafile), using a 1+0 array: What the best configuration to a performance gain, use 2 files 40gb in the same...
Hi. My problem: Server01 (SQL Server 2000) and Server02 (SQL Server 2000) are diferent machines, but need talk together. I have some procs in...
Hi. I've installed windows xp service pack 2 in a adm machine, since this I cant' see Componentes Services -> Transactions Statistics from a remote...
Recently I executed the MS Best Practices Analyzer in my test server, and the report analysis alerted to me to configure the following options for...
Hi I need to buil a custom replication monitor, but there are some doubts: 1 - I know SQL Server 2000 store replicated text command in...
Hi. I'm geting a script error (like IE javascript error) when I put my databases setup-show to show in taskpad. Evertime I need to configure it to...
I have a table with a indentiy colum as primary key. There are anothers 2 indexes in others columns I will only insert data in that table. I'll never...
OK, I read (and I agree) at a lot of papers that put the transaction log files in a different disk from the data files improve the performance (the...
Separate names with a comma.
