A database of size 40GB with largest index 10GB would need a maximum of 50GB for the index rebuild.

However, I'm not sure whether the next-largest-index will reuse the, now released,...

index rebuilds require as much space as your largest table. During rebuild you essentially have two copies of the index until the rebuild is complete, at which time to original...

What is maxdop set to?

Are you using resource governor?

Have you set processor affinity?

just to verify how many CPUs SQL Server is recognizing,what does query below return?

SELECT cpu_count,hyperthread_ratio,scheduler_count

FROM...

Are you testing mail with the same account\profile used in SQL Agent?

go to the properties of SQL Server Agent, go to the alert system page, and check which mail profile...

pretty sure as soon as you have anything on your passive/DR instance that isn't used for DR then instance will have to be properly licensed. Your best best to get...

Well that's the problem, you let a Sharepoint guy touch your server. 🙂

check out Multi server administration. This may be what you are looking for.

Is your C: drive or the folder where SQL server is currently installed compressed? If so try uncompressing folder.

https://connect.microsoft.com/SQLServer/feedback/details/704250/installation-failed-when-c-drive-compressed

anything in the installation log files? (c:\program files\Microsoft SQL Server\110\setup bootstrap\log\). Logs here might give indication as to what is going wrong.

Do you have the correct CU for your current version? there is a CU 6 for RTM, SP1 and SP2

I finally have something that works. Not necessarily elegant and I have no idea what it will perform like, but the results are what is expected.

Here's the code:

CREATE...

paul.s.lach (7/30/2015)

---

Try the following, the concept is:

1. do a cross join of all courses and terms

2. left join the results of the cross join to the...

I'd like to thank everyone for their contributions.

Even if supplied solution did not give desired results, they did give me different ways of looking at problems and , in...

First, is the right answer 4.3333 ? I changed the data type in your table to decimal(5, 4), as the float data type would be unable to accurately...

Jacob Wilkins (7/29/2015)

---

This should give the right results, but it strikes me as rather inelegant. Sometimes all I can find is a hammer 🙂

CREATE TABLE [gpa]([term] int,

...