YSLGuru (3/10/2010)

---

homebrew01 (3/10/2010)

---

YSLGuru (3/9/2010)

---

First off thanks to everyone who has taken the time to contribute, it is appreciated as always.

What has been said so far in each reply is...

SQLDBA-973159 (3/8/2010)

---

I have reviewed the SQL Server 2008 licensing guide (http://www.microsoft.com/sqlserver/2008/en/us/licensing.aspx) and just want to ensure I understand this.

I have SQL Server installed on an application server for a given...

Matt Miller (#4) (3/10/2010)

---

Jeff Moden (3/9/2010)

---

Most DBAs, whether System, Application, or Hybrid, don't know everything about SQL Server. There's just not enough time in the day. Some do...

Starting with this query

This statement...

Okay, I must be getting cynical in my old age. Thanks.

KTG (3/10/2010)

---

Hi Lynn,

But how do I know the order which the data in the view is ordered? I mean if table 1 is indexed on column 1, indexed on table...

Okay, I need some opinions here as I may be getting cynical in my old age. Please tell me if you think this is a compliment or a sarcastic...

I am assuming the database is NOT using the SIMPLE recovery model. How often are you running transaction log backups? These will clear out inactive transaction log records.

At...

If the underlying tables are properly indexed the views should work well, as long as you don't have multiply nested views.

This one is actually pretty simple:

create table dbo.MyTest1 (

ID int,

Machine char(2),

StartTime datetime

);

insert into dbo.MyTest1

select 1, 'M1', '2010-03-10 15:00:00'...

Steve Jones - Editor (3/10/2010)

---

OK, OK, some funny replies in here. The question was badly worded but let's not scare someone away from posting. I'm sure there is a valid...

Edit -- Post went to wrong thread.

Personally, I think every table should have a surrogate key as either a Primary Key (PK) or Alternate Key (AK). Especially when using a natural key for the PK....

I won't (but someone else might). You need to try writing it first and if you have problems, show us what you have done and we will help you...

Paul_Harvey (3/10/2010)

---

Hi All,

Hopefully an easy one for somebody in "the know".

I have a table with some 75 fields, that acts as a staging table for incoming data feeds.

I want to...