Big Data

RE: Trigger Trouble

• by chrisleonard

• Database Journal

• Reply

Very good - I'm glad you got it figured out!Chris

2004-02-17

RE: Executing a process with a specific set of CPUs

• by ericp37

• SQLServerCentral.com

• Reply

Well I was hoping that this was somthing that Microsoft had added.  Especially considering that the MS code was originally based on the Sybase code line and the fact that Sybase has this functionality.  With Sybase Version 11 and after, you can bind CPUs to a processing group and assign specific logins/groups to each processing group.  Maybe Yukon will add somthing like […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-02-17

Really basic architecture

• by Francis

• Database Journal

• Topic

Sorry if this is very basic, I'm curious as to best practices with Analyis Services (AS).  I have a couple of very general questions.1.  Does AS typically run on a separate stand alone server from the underlying OLTP database?2.  Is the AS datasource typically the OLTP database or is it a copy of the OLTP database […]

2004-02-12

2 reads

Alternative to MRTG?

• by sailor

• SQLServerCentral

• Topic

I am looking for an alternative to using MRTG graphs that feed off csvs from performance monitor.  I have it running ok, but have some problems with getting 0 figures in the data stream from time to time and on initial setup. I don't know much about SNMP and really cannot install anything on the […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-02-02

5 reads

RE: Table Synchronization

• by SUBHASH KV

• SQLServerCentral.com

• Reply

Steve,i don't have any timestamp...But if i use triggers, the thing is that these two table are in two different serverers physically located in different palce over an intranetI am trying with replication....  

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-01-23

RE: how to find sa password from registry in sql 2000/7.0/6.5 if i forget the sa password?

• by Eoin-The-Forge

• SQLServerCentral.com

• Reply

For 6.5 run regedit - Go to HKEY_CURRENT_USER/Software/microsoft/MSSQLserver/SQLEW/Registered servers and then double click on the required one.THe SA will be on the right of the screen vertically.Don't tell anyone this came from me - And I never use it because I never, ever forget my SA password as they are stuck on my screen with […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-01-16

8 reads

RE: How to backup database onto network shared drives

• by Gregory Larsen

• SimpleTalk

• Reply

You must first create a backup device that points to your network share, and then backup your database to the backup device you created. Gregory A. Larsen, DBA Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:qa.sqlservercentral.com/bestof/purchase.asp Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

2003-12-08