No, at least not from SQL Server. Deleting the ldf is a file operation done in the OS. And it can only be done when the SQL Server service is...

Oh, one more note. In between all the getting carried away with details and terminology and everyone being right and stuff, I forgot to add my two cents about the...

Hmmm, not sure if this is smart, but okay. I'll bite.

Sergiy (1/6/2016)

---

Hugo Kornelis (1/6/2016)

---

A CTE allows you to define a complex subquery once and refer to it multiple times in...

Woops!

Thanks for catching my oversight, Luis!

And thank you for finding the actual explanation, Jacob!

Integer math.

The data used as input in the formula are all integers, so the intermediate results are computed as integer...

erics44 (1/6/2016)

---

Lynn Pettis (1/6/2016)

---

One thing that would be nice is if Microsoft implemented CTEs more like the way Oracle implemented their sub-query refactoring clause. Oracle can treat the sub-query...

murthyvs (1/6/2016)

---

Thanks for your input. I tried adding "database roles db_datareader, db_datawriter and db_ddladmin instead of the individual permissions" to the adhoc database for the testuser. I could login just...

A CTE allows you...

The statement "doesn't work or doesn't work well" is invalid.

But if you ask which is better, then my guess is that 99% of the experts will point you to Ola's...

I do not know the ssbdiagnose utility. I do however have some experience with service broker and with troubleshooting common errors.

First - you do indeed need a master key in...

"classes" ... "students"

Hmmm, lemme guess. Homework assignment?

If your teacher didn't manage to explain normalization well enough, then perhaps I can help you. Go to Pluralsight.com, sign up for a free...

Mosgt likely, the second database has READ_COMMITTED_SNAPSHOT isolation enabled. That feature was introduced in SQL Server 2008 (if I remember correctly) and changes the way locking works - when a...

But that does not mean that maintenance jobs are great. They are not. They allow you to do some pretty nasty stuff...

... in most scenarios.

If you have a database that has a very high amount of table allocations and deallocations, you can get some...

Raastarr (1/6/2016)

---

The 28 day periods will be different for each person as the first period will begin from their first SignIn record. So for person 1 that is 2015-01-01, after...