SQL Server is relatively easy to upgrade but unless there's a feature in a newer version that an organization really wants or they want to install/upgrade an application that uses...

Bruce

Maybe something like,

WITH TEMP_CTE AS(

SELECT MachineID, InstanceKey, TimeKey, RevisionID, rowversion, Account, SchemaClass FROM TABLE_A

UNION ALL

SELECT MachineID, InstanceKey, TimeKey, RevisionID, rowversion, Account, SchemaClass FROM TABLE_B

)

SELECT * FROM TEMP_CTE WHERE TimeKey...

Pirates

Does this consultant mean that the DB is typically used in a read only manner or does he really think it doesn't use transactions? If it's really a read...

Hmm... maybe a better title would be AdministratorBall. Development tends to not have as many hard skills that can be measured beyond it works but noone knows why.

Yes you can change the recovery mode of the DB to simple, that won't clear the existing log file so you would still need to do a transaction log back...

In management studio go to SQL Server Agent -> jobs on...

This is kind...

Hammer

Ray K (1/21/2016)

---

Luis Cazares (1/21/2016)

---

djj (1/21/2016)

---

Ed Wagner (1/21/2016)

---

crookj (1/21/2016)

---

Red...

John Hanrahan (1/21/2016)

---

My impression from reading some of the "leading" IT mags is that M$ SQL is losing market share especially to MySQL. I know if you look at...

Eric M Russell (1/21/2016)

---

Alex Gay (1/21/2016)

---

Eric M Russell (1/21/2016)

---

How about a licensing model that simply charges for and caps the number of concurrent connections or non-system session SPIDs without concern...

I wouldn't mind seeing more granularity in pricing based on features there's some features in even standard edition I'll never use and some features in EE I'd like to have...

Just out of curiosity why are you defragging(or rebuilding) before purging?