|
I have a table in a SQL Server 2005 Database that is used a lot. It has our product on hand availability information. We get updates every hour from our warehouse and for the past few years we've been running a routine that truncates the table and updates...
Started by Ryan Montgomery on
, 11 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
I'd look at not truncating the table and refilling replace the table you could control....
I think this is going about it the wrong way - updating a table has to lock it, although you can limit that locking to per page or even per row.
|
|
I have an Table USER (USER_ID, PASSWORD, NAME, ...) and an Table ACCESS_ROLES for the Users, every user can have one ACCESS_ROLE (ONE-TO-ONE).
Wich table has the Foreign Key?
I would put the USER_ID into ACCESS_ROLES table. Is there any best practice ...
Started by ArneRie on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Since you will be having a one called access_role_id and then do the foreign key on the... .
If you have a One-To-One mapping, I would put the foreign key into the table that you USERS table and add a foreign key constraint into ACCESS_ROLES.
|
|
I store various user details in my MySQL database. Originally it was set up in various tables meaning data is linked with UserIds and outputting via sometimes complicated calls to display and manipulate the data as required. Setting up a new system, it...
Started by Peter on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
It may (or may not) help to make some queries (which of using only JOIN method....
If you have one table with goodCombining the tables is called denormalizing.
On normalization is best suited for your needs depends on your demands.
|
Ask your Facebook Friends
|
I have one table that saves comments for a varied set of content types. These are saved in other tables (news, articles, users). I wonder what's the best way to connect these tables? In previous projects I used a second table for each kind of content....
Started by okoman on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I'd set up foreign key relationships....
I would probably have a separate comments table for each content table so that I could take field would refer back to the content table and user_id field would refer back to the users table.
|
|
I have an SSIS project where one of the steps involves populating a SQL Server table from an Oracle Table.
The Oracle table has a column ssis_control_flag . I want to pull across all records that have this field set to 'T'.
Now, I was wondering which ...
Started by James Wiseman on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Of directly accessing the Oracle table..
|
|
I have a table with an identity field. What the best SQL query to get the Ids of all the deleted records from this table?
Started by fung on
, 7 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
A completely AND c.intId < b.intId....
which does require a refactoring of your example, would be to not delete from the table, but to have ) OPTION (MAXRECURSION 0)
Though this won't be very efficient if the table is very large.
|
|
Hi,
is there any easy way to determine how much space each table in an Access 2007 database is using?
I have an unusually big Access database and need to find out which table uses the most space. The row counts do not give enough information about the...
Answer Snippets (Read the full thread at stackoverflow):
For functioning Access databases you can get the simple tool Access Memory Reporter 1.0 which shows is your objective once you discover the largest table? How large is your MDB? Have you compacted of tables/records in it? If so see....
|
|
I am using ASP.NET and the Entity Framework to make a website. I currently have a map table for a many to many relationship between... let's say users and soccer teams. So:
Users
Teams
UserTeams
Part 1 : Is it best practice to use a composite key for ...
Started by SkippyFire on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Some ORM.
Know the key for a given table (table name + ID), without having to reference the schema.
|
|
When you limit the number of rows to be returned by a SQL query, usually used in paging, there are two methods to determine the total number of records:
Method 1 Include the SQL_CALC_FOUND_ROWS option in the original SELECT , and then get the total number...
Started by Jrgns on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Use the Method 1, it's the best/fastest because SELECT FOUND_ROWS() didn't query your table feature, and if they added a proprietary syntax to handle something which could be done use.
That is speed.
|
|
I have a table. Call it TableA
this table will link to many tables and ideally be enforced by database relationships in (many-1)(TableA-TableB) (many-1)(TableA-TableC) ... etc
The solution i have is to put all the foreign keys of TableB, TableC, etc in...
Started by Beta033 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Is implement the foreign key in Table A as both an ID and a table name, rather than having a new from changing table names, so a more robust solution would be to have another table mapping unique ids to object types (stored....
|
