Normal aggregate functions (SUM(), AVG, () COUNT(), MIN(), MAX(), etc.) are available to be used as windowed functions (using OVER and PARTITION BY).

SELECT Title,Subject, Max(Price) OVER(PARTITION BY Subject) As MaxPriceBySubject

...

I've used MBOPartners.com (formerly mybizoffice.com) for this very thing. You go find your own contracting opportunity, then they execute the statement of work. You enter your time on...

Garadin (12/16/2009)

---

Navigate down in the object browser, then switch to the details window, browse all the way down (I've found the whole filtering system extremely annoying...

I don't know about documentation, we simply ran our own tests on our 3PAR sans:

1. Record SAN allocation

2. Create thin-provisioned LUN, and mount it

3. Record SAN allocation

4. Format mount point

5....

Mani-584606 (11/30/2009)

---

Here, when the entire network goes down, will the SQL Services from active node try to move to passive node? or will they stay at active node itself as...

The key point with IFI is that it doesn't write those zeroes. Using the NTFS Sparse File mechanism, the file is merely marked as being the new size and...

It's been a few years, but I have used this on NetApp SANs without problems.

The feature relates to what Windows/NTFS does with the modified file; the type of storage has...

Also note that a company that will ignore software laws in order to save money, because they can get away with it, may just as willfully ignore labor laws to...

One trick is to hit the table twice: the first pass selects the 'buy' columns and aliases their names to simply Curr and Amt, and the second pass select the...

SET NOEXEC ON

After that, you can execute you procedure. The procedure will compile (and perform the object and syntax checks you seek), but will not execute.

If you wish...

Note that it's just the dbcc index defrag syntax that has been removed....

Changing MAXDOP only makes the CXPACKET waits go away, but doesn't cure the problem. You'll get some cycles back from not having to assemble the streams, but the bottom...

Note: see link at bottom of post.

There are two types of CALs: Machine and User.

A Device CAL licenses a single workstation/phone/etc. from which multiple users may interactively log in and...

You may only install one default instance of SQL Server on a server.

For clustering to work, you must install an instance on every node (server) in the cluster...

I just threw that together as an answer to...