Not from SQL. SQL Server only knows who the client machine is, in this case, the web server. If you need to be able to track back from there, you'll...

Books online is your friend...

Posting your homework once is bad enough. Posting it twice is pushing the limits. Posting it three times...

http://www.sqlservercentral.com/Forums/Topic450568-338-1.aspx

The host name column will give you the machine name from which the query came. You can use the program name to identify the name of the app that submitted...

TheSQLGuru (2/1/2008)

---

Which we could figure out a way to do the read-along scan test on a huge table in enterprise edition too. Perhaps one of you guys...

There's no hard and fast number. It depends on the datba and the data....

Unused = free

Yup.

The whole issue of 'most selective column first in an index' is a bit misleading. SQL can, and does, do multi-column seeks as one operation. What you want is the...

With a clustered index, the leaf pages of the index are the data pages. Yes, they are in the order of the index keys.

This means that the clustering key...

DBCC shrink database to shrink the whole database. DBCC ShrinkFile to shrink individual files

I would like to know...

Give this a try. Plese note, it is untested. I don't have your tables or data. It passes a syntax check, but that's all I could do.

Changes are in red.

Select...

I'm sorry, I'm not sure I understand your question.

Give me SP3!

We're currently pushing to get the 5th cumulative update on one of our servers (cause we keep running into a problem that was fixed in SP2 and fixed...

SELECT @NoFeaturedJobs = count(JobPK)

FROM JOBS

WHERE ClientFk = @ClientPK AND

SiteFk = @SitePK AND

FeatureScore BETWEEN 1 AND 5 AND

Live = 1

In general, for covering indexes, you want the columns in the following...

No. Depends on what other apps are running on the client, and when SSMS was started. Open task...