Viewing 15 posts - 2,116 through 2,130 (of 2,436 total)
yup ... another vestige of the original Sybase code base ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 8, 2005 at 1:51 pm
Here's a few links to peruse before/during/after ...
SQL version checking:
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185
(there's a more comprehensive link that includes 'hot fixes' but I cannot find it at present)
moving databases:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 8, 2005 at 1:48 pm
Please excuse the 'phat phingers' (typos) in the post ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 8, 2005 at 1:29 pm
The performance impact is negligable. I believe that on an update, whether your recovery is simple or full, the following actions occur:
1) the data page in memory is updated (and...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 8, 2005 at 1:28 pm
An index is an object within a database. when changing is in one database it affects no others.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 5, 2005 at 9:42 am
It seems your one instance is at max memory (1.7 Gb is about the max). Maybe you might want top consider adding more RAM (1-2) Gb, using the /3Gb boot.ini...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 3, 2005 at 1:31 pm
The only thing from a DBA maintenance perspective that I have noticed in the past is that I do not have to create a SQL login and password. You still...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 3, 2005 at 11:27 am
... not optimistic, nor pessimistic, but rather realistic ...
"any day on this side of the dirt is a good one"
... titles, staff, responsibilities, tickets and hats ALL aside !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 1, 2005 at 12:11 pm
Just a pointer or two moving forward ...
Whenever you 'want to try comething out' use the pubs or Northwind databases (that's what they are there for). Sometimes 'trying something out'...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 1, 2005 at 11:32 am
Just a few questions ...
Do you have an administratove account on the XP computer ?
Is the windows firewall turned on ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 1, 2005 at 10:44 am
What is the platform information for the server and/or 'desktop' PC (OS Version, OS Service pack, SQL Version, SQL Service Pack) ?
Are you running EM on the server itself or on...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 1, 2005 at 10:41 am
Just a question/observation ... Are these truly 'end users' ? If they are truly 'end users' why do they have access to Query Analyzer and Enterprise Manager ? If they are...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
July 29, 2005 at 3:11 pm
We recently ran into some network connectivity issues relating to file copy(s) on selected servers in our environment.
The solution was to check the NIC card settings on the server and...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
July 29, 2005 at 3:06 pm
We recently had a few total datacenter power outages. One the week before last, 3 in a 2 hour period due to storm and the utility company. And one the...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
July 29, 2005 at 10:35 am
I just want to add ...
In SQL:
select getdate()
produces:
2005-07-28 13:33:18.107
In Unix:
date
by default produces:
Thu Jul 28 13:30:18 CDT 2005
There are formatting commands available to produce a date similar to SQL Server that...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
July 28, 2005 at 12:55 pm
Viewing 15 posts - 2,116 through 2,130 (of 2,436 total)