Viewing 15 posts - 346 through 360 (of 395 total)
In our companuy we have about few hundred servers, 4 prod dba. At the same time we have developers who takes care of the code.
We manage all our servers thru...
November 10, 2004 at 3:49 pm
A far as I remember MS is supplying you with PSSDIAG tool, since it has to customize it for you. (Of course you could get it somewhere and tweak .ini...
November 4, 2004 at 12:05 pm
If you cannot start server: it could be due to insufficient permissions.
October 13, 2004 at 11:34 am
Our servers are set in Mixed-Mode Authentication and security in
Linked Server properties is set to 'Be made using the login's current security context'. Make sure your servr logins have...
October 13, 2004 at 11:28 am
Once in a while we need to perform (due to the slowness) a non-scheduled SQL Server reboot during business hours, but we never experienced a problem right after that. We run...
October 13, 2004 at 11:04 am
how is the backup strategy different for regular size db vs. VLDB....
October 12, 2004 at 11:59 am
How do you handle all servers?
The way we do (and we have about the same number of servers) is to use link servers management.
We designate one server for handling that....
October 11, 2004 at 1:21 pm
It doesn't directly answers your question, still good to keep in mind:
It could be the maximum number of:
-32,767 databases per Server;
-2 bln objects (tables) per database;
-1024 columns per table
-8060...
September 1, 2004 at 11:45 am
you could also try to copy either a single row, If you know the name of your dts package, or the whole table in msdb: sysdtspackages.
After doing that you might...
August 28, 2004 at 11:20 pm
You could post your resume on Monster.com, Dice.com, HotJobs.com. That is a good start.
August 26, 2004 at 12:13 pm
In EM:
Server->Database Name->Right Click on Properties->Options. Make sure Auto Close is unchecked.
In QA: Select DATABASEPROPERTYEX ('Pubs','IsAutoClose')
1-stand for Property Enabled
0-Check Off-Property Disabled
August 24, 2004 at 11:19 am
how about placing your db into simple recovery mode
August 20, 2004 at 3:19 pm
Here what I do:
Search for the ssnetlib.dll. In most of the cases it should be inC:\Program Files\Microsoft SQL Server\MSSQL\Binn.
Right Click-->Properties-->Version-->Product Version-->8.00.766
8.00.766 stands for SP3A
August 11, 2004 at 11:56 am
Move Clustered index to the Filegroup of your choice and it moves your table. If you dont have a Clustered Index on the tables you need to move-then create them.
After that...
August 10, 2004 at 10:56 am
You might want to take the following approach:
Check for the syntax though, since I haven't tried it:
Link all your remote servers on single server. Configure it. Create a table 'Servers' with all...
August 3, 2004 at 11:26 am
Viewing 15 posts - 346 through 360 (of 395 total)