There have been several discussions on SSC regarding this. You may want to try searching this site for ORM, NHibernate, Hibernate.

Actually, using SQL Server 2005, this may be the better choice as it keeps the data with the appropriate rows.

create table #MyTest (

[name] char(1),

...

The transaction log is the transaction log. It doesn't matter if you have one filegroup for the data or 100 filegroups for the data. There aren't separate transaction...

Can't speak to using filegroup backups, I have never used them personally.

Regarding shrinking the t-logs after t-log backups, NO. It would simply have to grow again as transactions are...

PiMané (10/30/2009)

---

basically what you're saying is that if I NEVER make a transaction log, cause I don't need for any reason and have full mode to make differential backups, the...

Full and Differential backups do not truncate the transaction log. This is only done by transaction log backups. Please note that truncating the transaction log is NOT the...

something like this:

declare @StartDate datetime,

@EndDate datetime;

set @StartDate = '2009-10-14';

set @EndDate = '2009-10-21';

select

*

from

where time between...

jude-32296 (10/30/2009)

---

When I transferred my logins from one Sql 2005 to another, I failed to change a setting in the script & now all my logins have "Enforce Password Policy"...

frontpedal (10/30/2009)

---

Hi everyone,

My database table has a time field called [time], Data Type of "Numeric" length of "9" with a Precision of "14" a Scale of "0".

The query below...

jcrawf02 (10/30/2009)

---

WayneS (10/29/2009)

---

A former boss of mine used to say... if 24 hrs a day isn't enough,...

Unfortunately, since you haven't provided the DDL for the tables, sample data in a readily consummbale format, or expected results based on the sample data, this is all I could...

ali.prasla (10/29/2009)

---

I need some help in designing the table that can handle unbalanced/ragged hierarchy. What should be the table structure of below scenario? Below scenario entails that Bill is...

Have you checked the DTC configurations between Server2 and Server 3? You will find that through Admistrative Tools, Component Services.

Steve Jones - Editor (10/29/2009)

---

I think Gail is like me, running from thing to thing, not sure how all the plates are staying in the air.

At least I have kids...

Is it just me today or are OP's purposely posting things today that are as clear as mud?