robert.levy (8/9/2010)

---

Absolutely right, this is the setup I currently have. But:

for the 90% of Bs which only have one A:

I want to present the user with the friendly name...

robert.levy (8/9/2010)

---

The problem itself is this:

Every A has to have a C.

Sometimes many As are grouped into a single B.

In this case, it is the B that has the C.

Is...

gvdamn (8/9/2010)

---

Hi,

My database is 213 MB in size. (The database is in full recovery mode.) The size of my log file is 1800 MB. The log space used is 2.01%....

douglas.allison-1136597 (7/16/2010)

---

I have 2 simple tables tst_a and tst_a_arch

On tsts_a I have this trigger

----------------------------------------------------------

create TRIGGER [dbo].[updated]

ON [dbo].[tst_a]

AFTER UPDATE

AS

if (columns_Updated() & 14) > 0

Begin

insert into tst_a_arch (test1,test2) values ('a','b')

end

GO

-----------------------------------------------------------

If...

David Portas (8/8/2010)

---

PaulB-TheOneAndOnly (8/8/2010)

---

So... at reservation time... which value do you use to populate date_pickup_actual and date_return_actual considering business specs are stating that those values are "not known" at that...

robert.levy (8/5/2010)

---

In my current model I have:

People

PersonID, PersonName, HouseholdID

Households

HouseholdID, HouseholdName, LicenceID

Licences

LicenceID, LicenceNumber

My fear is that for 90% of the rows of household what I'm really representing is a person but...

David Portas (8/6/2010)

---

What I meant was that nulls are not part of any business requirement so they are not required as the end product of any database solution. Nulls are...

michael.morse (8/6/2010)

---

Our company has a DTS job that takes a data file and seperates it into seperate files of data for each user responsible for that data. Currently to...

Quick question ... is this process loading an empty table? meaning, is the target table empty at the beggining of the load?

Described behavior is consistent with the full loading of...

praveen_vejandla (8/7/2010)

---

After switching a partition to a staging table, we take backup of the data in staging table using BCP and then we drop the staging table.

What will happen to...

sergio.huertac (8/7/2010)

---

I have this problem: I need to get a group of records where a StatusID is included on a field from another table. Let' say: StatusID='ASC' from StatusTable table...

Nicely worded but spam anyway - isn't it?

Reported.

There is no "Don't know/ Don't understand/ Don't care" option, this is not a scientific poll 😀

Seriously now, for critical production databases I'll set it accordingly.

tzones2006 (8/6/2010)

---

We have several web applications running using the SQL Server 2000 as the back end. These are mainly reporting applications where the data access mainly involves data read and...

I would start by checking what is in there making it that size.

That is unusual to say the least.