Viewing 15 posts - 34,261 through 34,275 (of 39,727 total)
This gets me my info:
restore filelistonly from disk='e:\mssql\backup\lyris\Lyris_db_200412150200.BAK'
Change names, and paths of course
December 15, 2004 at 9:17 am
At JD Edwards, our warehouse ran on SQL Server, 1 app server, 2 web servers, and we supported a 600+GB database very well. Ran much better than the 12 server...
December 15, 2004 at 9:13 am
That's good
.
It does sound a little strange, doesn't it?
December 15, 2004 at 8:01 am
Does Veritas not have a solution? They should connect by instance name, where the ports are resolved by querying 1434 for the port of that instance.
Any reason you don't want...
December 14, 2004 at 9:45 am
If performance is an issue, re work the design or buy a bigger box.
December 14, 2004 at 9:44 am
I have seen this when a server was under high load. We talked with MS and they said to turn off parallelism. I thought there was a post SP3 fix...
December 14, 2004 at 9:43 am
How about this?
update p
set totalapps = b.apps
, totalgials = b.goals
from player p
inner join (
select a.playerid, sum( a.apps) 'apps', sum( a.goals) 'goals'
...
December 14, 2004 at 9:42 am
Update the statistics on the table. This can get out of synch. Also, you should have a clustered index on the table (indid =1), which ensures accuracy most of the...
December 14, 2004 at 9:39 am
Low end solution, Servers Alive (http://www.woodstone.nu/salive/). I used to use it and it worked great. Drop it on a workstation and set it to alert you.
December 14, 2004 at 9:38 am
sp_oamethod @objecthandle, 'Add'
Need a handle the the Jobs object before you can do this.
December 13, 2004 at 7:07 pm
Is 445 UdP blocked sometimes? Are the servers setup on specific ports?
December 13, 2004 at 1:04 pm
No, you'd have to set triggers on all tables. Or set a job to go through periodically and just set all data. Be cacreful of logging if you do the...
December 13, 2004 at 10:39 am
I've seen it before, but only for SA. We've used the IDS and firewall to block them and trace back, but it usually goes nowhere.
December 13, 2004 at 10:38 am
Are both machines in a domain? If not, I've typically just used SQL authentication to get around this.
December 13, 2004 at 10:21 am
Are you looking for one database or all? One is easy, all requires some more work to get this to work and return in one result set.
December 13, 2004 at 10:18 am
Viewing 15 posts - 34,261 through 34,275 (of 39,727 total)