I mailed them, seeing as they're in my neck of the woods.

GSquared (8/28/2008)

---

I got asked this same question as an interview question. I was able to describe a covering index, but I've never heard of a "covering query" before. ...

If you can't do a full scan with update stats, use the RESAMPLE option. It means that the DB engine will adapt the % sampled to ensure it gets enough...

Sanaullah (8/28/2008)

---

Ok but while concatenate we need to add this CREATE TABLE TableName with that, but my main problem is

iPhotoGalId INT Primary KEY IDENTITY(1,1) NOT NULL ,vPhotoGalTitle VARCHAR(50),dModifiedDate DATETIME(8),iOrder...

It's not a different type of index.

An index is a covering index for a specific query if all of the columns that the query needs are included in the index...

If I'm understanding you corectly, you want the following script generated:

CREATE TABLE TableName (iPhotoGalId INT PRIMARY KEY IDENTITY(1,1) NOT NULL,vPhotoGalTitle VARCHAR(50),dModifiedDate DATETIME DEFAULT GETDATE(),iOrder INT)

but you're getting this:

iPhotoGalId INT Primary...

Since the DB is in Simple recovery mode, a checkpoint will truncate the log and...

One of the drawbacks is in terms of security. Using dynamic SQL requires that the user has rights to the base tables and opens the system up to possible SQL...

No matter what settings you use, SQL will log transactions. It's not an optional part of the system, it's how data integrity is guaranteed. Data changes are first written to...

Marios Philippopoulos (8/27/2008)

---

I'm considering a clustered index because of the GROUP BY and MAX clauses. Clustered indexes usually perform better in queries where ranges of rows are involved. Nonclustered indexes...

Marios Philippopoulos (8/27/2008)

---

I read it in an article on SQL Server magazine, April 2007, by Kalen Delaney: "use Missing-Index Groups for Query Tuning". I quote:

"At present, the missing index information...

day (8/27/2008)

---

I am backing up every night not more than total 2 Gb as a full-backup. It takes only few minutes. Do I really need to set a Transaction Log...

Why does it have to be clustered? If it was me, I'd suggest a nonclustered index for that, (TN, CID) INCLUDE (IDt)

What's the selectivity of TN? How many rows...

Marios Philippopoulos (8/27/2008)

---

One caveat is that indexes used in places other than in the WHERE clause of queries are not included in the DMVs, so, for example, indexes needed on...

Depends whether you're going for per CPU or per seat licencing. Per CPU licences are a lot more expensive, so if you don't have a large number of users, consider...