CirquedeSQLeil (3/11/2010)

---

Jack Corbett (3/11/2010)

---

I can relate. I wonder how people know so much, but it really is just plugging away. Need to learn how to tune a query,...

PTPD (Post Traumatic Project Deployment) Syndrome

If you are licensing SQL Server per device/user, then the number of processors in the server do not play into pricing. This only occurs if you are licensing SQL...

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.