in SQL Server, which operations will use more CPU resource? it seems that compilation and recompilation will lead to high CPU workload. are there any other operation will cause...

It used to be and could be/should be again.

Redgate has grown to be a very successful company with a declared profit of 9.7M GBP in 2019 Fin Year....so it's not like they couldn't afford to sort many...

I was on the Visual Studio marketplace the other day. Stumbled across this tool.

https://marketplace.visualstudio.com/items?itemName=MAQSoftware.SQLCodeCheck

I was hoping it would be a simple tool to root out basic...

So, my personal and heartfelt request as a member of "the community that was", I'd love it if you and JLS (another recent revisitor) and a host...

I new they were moving the Microsoft Feedback site from "user voice" to something else but all of my feedback links now lead to the following stupidity...

https://azure.microsoft.com/en-us/feedback/

Clicing on the...

As is usual, excellent article, Mala.  Thank you for taking the time to do the research and then put pen to paper in a meaningful and readable manner.

To quote from...

Your multiple views use the same tables over and over again.

For example, table [Lease] is mentioned in your query plan 20 times, [User_area] - 21 times.

I did not bother...

I try to never let anyone know when I have some "free" time because too many people want a piece of it.  😀

Thanks, Steve.

From the article:

---

Can a system be secure if you change it multiple times a day?

I cringe every time I see those or similar words.  Many will disagree with me but...

Heh... good lord.  It's been so long since I looked at that built in report that I'd forgotten a couple major (IMHO) flaws it has...

First, It does NOT...

Thanks, JLS... your answers are great... especially the implied answer of "you're all set".  I can "play" at my leisure, which I have disturbingly little time to do lately because...

Shifting gears back to your good question, I'm curious...

1. What are you going to do with the t_Group and t_no columns once they've been generated?
2. How often will you need...

The company I work for only has me.  I do get some good help hardware wise from the Infrastructure Group and they're the ones that copy backups to tape, etc,...