Based on the info, I can't give you a precise answer. However, the place to look is permissions on the linked server. There must be a difference there when you...

First, an answer to your question, then, some discussion on the nature of backups.

To just see the objects in a database:

SELECT COUNT(*) FROM sys.objects AS o
WHERE o.type...

This is a very general question, so I'm going to give a very general answer.

If you intend to filter your information based on a particular column, one presumes Rosterdate from...

Heh... this happens during meetings, as well.  Someone goes off on a tangent or with some...

On the top of every Confluence document I ever write there is a small 2x2 table

• • Last Reviewed: The date of review

• • Last...

I'd say there aren't any advantages....

Well, see, now I'm nervous. Making it read only could work. Should work. However, what level of access do people have? They could undo that depending (seen too many places...

Getting tossed into the deep end. I feel for you. I'll try to help.

Strong recommendation, take some time and spend it reading. The Stairways series on T-SQL would be...

Sounds like a valid plan.

Here's an addition.

Going from 2008R2 to 2019, you're hopping the 2014 Cardinality Estimation Engine upgrade. The vast majority of your queries will run the same. A...

If you can afford to have it up with the server online, yeah, I'd leave it there. I mean, change the security so people can't accidently log into that instead...

xml is the best data type, so that you can easily shred the deadlock graphs to make them understandable.  By the way, I recommend you capture deadlocks more...

Ha! Yeah, it is.

However, you can edit the system_health session if you want...

Unless someone has explicitly turned it off, and since most people don't even know it's there, on every single server, 2012+, you have an Extended Events session running called system_health....

• This reply was modified 5 years, 11 months ago by Grant Fritchey.

Hi Guys ,

I have a very basic question regarding comparing 2 execution plans .

While comparing the execution plan i usually see Estimated sub tree cost of the left most...

However, the most likely culprit here is not that you defragmented the index. The most likely culprit is that, as part of defragging the index, the statistics were...