all groups > sqlserver server > august 2006 > threads for saturday august 26
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Is the database offline as it grows data files ?
Posted by Hassan at 8/26/2006 9:27:16 PM
Just curious to know if the database does take some hit by going offline
when the data files grow ?
... more >>
SQL Server DBA wanting to understand Oracle architecture
Posted by Hassan at 8/26/2006 7:25:51 PM
Where can i find an article thats not biased to any one particular RDBMS
that can show me differences to Oracle and SQL Server.
Id like to understand the basics on the internals of Oracle as compared to
SQL Server.
Thanks
... more >>
Removing Older Backups?
Posted by Don Miller at 8/26/2006 7:25:34 PM
With SQL Server 2000 I created a backup disk file (and job) for full
database backups performed daily (which are appended), and a backup disk
file (and job) for log backups performed every hour (also appended). Because
of disk space constraints (on a dedicated server), I would like to remove
old... more >>
MAPI Mail Client for SQL Mail?
Posted by Don Miller at 8/26/2006 6:03:38 PM
Are there any free MAPI mail clients that I could use with an Internet mail
service (POP3/SMTP) so I could set up SQL Mail?
The Outlook Express that came with my dedicated server doesn't seem to do
the trick, and it's not easy to install Outlook on a dedicated server at a
hosting site where I ... more >>
Serial Numbers for Super/Sub Types ?
Posted by Tadwick at 8/26/2006 12:59:42 PM
I have a data model that represents about 10 different types of widget.
Most of the types are basic and they can be described by the main table.
However, a few are more complex and so I have added subtype tables to model
their varying characteristics. Each widget has a serial number. Until n... more >>
UPDLOCK hint
Posted by Dodo Lurker at 8/26/2006 9:01:50 AM
Hi
Thanks to all of you for your responses.... they have been great!
UPDLOCK hint..... why would I want to use this? How is different
from repeatableread hint? I think it's to prevent other users from
getting a share lock on something I'm going to be updating? I
can't understand it... more >>
q; past and future date
Posted by JIM.H. at 8/26/2006 8:31:01 AM
How should I find the dates for 3 days past and 5 days future. Such as
TodayDate-3 and TodayDate+5 base in the date only, discarding the time?... more >>
Check Constraint help,, Alpha and Numeric
Posted by Bonzol at 8/26/2006 7:33:50 AM
Hey there, In SQL server 2000, I need to create a constraint on one of
the columns that the field enterd must be 2 alpha charactors and the
last 3 must be numeric.
soo, for example
aa123
thanx in advance
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Is there any difference between Integrity and Constraint ?
Posted by John at 8/26/2006 12:00:00 AM
For an EDMS application, there are two separate tasks for maintaining Data
Integrity and Constraint for the DB.
From my understanding, the Constraint is already includes the Referential
Integrity, is there any other meaning for Data Integrity ?
Your advice is sought.
... more >>
How to get remote query timeout value
Posted by ad at 8/26/2006 12:00:00 AM
Hi,
We can use
EXEC sp_configure 'remote query timeout', 6000
to set the remote query timeout value.
How can we get the value remote query timeout ?
... more >> |
