all groups > sqlserver server > august 2006 > threads for sunday august 27
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
Setting column default
Posted by John at 8/27/2006 5:15:41 PM
Hi
How can I make a datetime to default to current date/time? Can I set the
'Default Value or Binding' property to something to achieve that?
Thanks
Regards
... more >>
Adding a new field to an existing table with image field
Posted by eeyore21 at 8/27/2006 3:48:05 PM
Hi,
I have a concern about adding a new field to an existing table with image
field - which is huge.
Will there be a problem with some databases, where they have a hard time
locating data correctly after such a large field? I was advised to put all
the big fields at the end of the table.
... more >>
When to apply foreign keys and create indexes
Posted by Dodo Lurker at 8/27/2006 11:12:44 AM
Say I have 1 million rows of data I'd like to import into
my database on a monthly basis. I think the proper approach
is to
(a) drop the indexes on the destination table
(b) drop the foreign keys on the destination table
After the table is populated, then re-add the indexes and foreign... more >>
Separating data in filegroups
Posted by Dodo Lurker at 8/27/2006 11:08:06 AM
Yes, it's me. Another question.
I'd like to set up a new sql server 2000 database under raid.
Based on my readings, I'd like to do the following
put tempdb on raid-0 (no fault tolerance; it's a scratch pad data base that
gets rebuilt)
put log file on raid-1 (for mirroring in case a driv... more >>
Replace '' with a 0 ......... replace nothing with a 0
Posted by MattieG at 8/27/2006 7:31:33 AM
Hi guys
Im sure this is easy but I have a query to calculate spaces on a
booking system and need to replace a blank ie no bookings yet with a 0
so that i can add the numbers up to get a total.
Trouble is its not a NULL value and when i try
REPLACE([fieldname],'','0') it just doesnt work.
... more >>
sql server perfomance
Posted by Einav at 8/27/2006 1:29:01 AM
hi
im currently using sql server 2005
my question is how much of time difference is there between
a query on a 3 million row table
to the
same query on a 30 million row table with an index
ill explain:
im currently planning to build a 10 column table:
exercise_num column2 column3 ... more >>
IX locks question
Posted by Dodo Lurker at 8/27/2006 12:05:49 AM
From what I'm getting, IX locks are just a safety mechanism to allow a
query
to lock at a higher grain (i.e. say, a table lock) if the lock manager needs
to
escalate row locks to page or table locks. Is this a correct assumption?
So, everytime I perform a DELETE or UPDATE can I expect that... more >> |
