Viewing 15 posts - 16 through 30 (of 68 total)
Ryan,
How much activity are you expecting on this server? How many user connections? You're asking advice on RAID config for performance, but you tend to stability is also important. That...
March 15, 2006 at 3:07 am
Hi,
As promised: the stored procs I was telling you about.
Instructions:
1.You need to place the 'usp_KillDatabaseConnections' on each server you like to restore to.
2. Place the 'usp_restoreDBAsTestDB_Version_1_8 on the...
March 2, 2006 at 6:03 am
Hi Philip!
I Agree with Max and Brian! That's a hell of a job you did there! I really hope you publish this on SSC.
JP
March 2, 2006 at 4:56 am
Hi Philip,
Tough one for you.
Maybe Active Directory can come to your rescue. There's an attribute named SIDHistory in Win2003. If this attribute of your new useraccount can be filled...
February 28, 2006 at 4:46 am
Hi,
I have written a few USP's that do that job for me on a weekly basis. I will have to rewrite these USP's for you to get rid of 'company...
February 28, 2006 at 4:28 am
Hi,
Just another possible problem: I have noticed performance issues on production servers having more CPU's than test machines. It seems that the degree of parallelism / hyperthreading can have a...
February 23, 2006 at 2:09 am
Hi,
You need to monitor only SQL servers, or any kind of server?
JP
February 23, 2006 at 1:59 am
Hi
declare @my_dynamic_query varchar(8000)
set @my_dynamic_query = 'select [' + @column_name + ']
INTO ##ResultsTable
from [' + @table_name + ']
where [' + @column_name + '] = 23'
sp_executesql @my_dynamic_query
select @myVar = columname from...
February 21, 2006 at 4:14 am
Hi,
Difficult proces to restore the system db's.
I you're using Windows 2003 then you can always get a copy of the MDF and LDF system database files (using VSS/shadow copies)....
February 21, 2006 at 4:09 am
Wim,
You run a DTS Package, right? You can turn on DTS Logging and then check if the package runs in first place. (Or change the DTS Package, add a step...
February 21, 2006 at 3:59 am
Hi Jayakumar,
First of all:
Check your DB with the DBCC checkdb command. If the database is OK, then you can check on MS Support site for the error. The one you...
February 21, 2006 at 3:52 am
Hi,
Difficult problem. We had the same issue. The code is not HTML but RTF. Solution:
1. use this component:
REGEX (http://www.codeproject.com/managedcpp/xpregex.asp) and use this syntax to get rid of RTF:
February 20, 2006 at 4:07 am
Hi
You should regurlarly schedule a t-log backup with the full recovery model. That should help.
JP
January 13, 2006 at 2:47 am
I agree with Joe, but keep in mind that truncate table can get a little more difficult, you need to drop/recreate sp's & views.
see BOL:
You cannot use TRUNCATE TABLE on...
October 14, 2005 at 5:47 am
Hi,
Take a look at these pages. It seems that this will answer your question. You're looking at numbers that don't seem to be measured reliable!
JP
http://www.oreillynet.com/pub/a/network/2002/01/18/diskperf.html
http://searchstorage.techtarget.com/tip/1,289483,sid5_gci852081,00.html
August 26, 2005 at 3:12 am
Viewing 15 posts - 16 through 30 (of 68 total)