Transact-SQL

Execute on DMVs without user having View Server State

  • Script

Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]

5 (1)

2020-09-24

826 reads

SQL Server Name Convention and T-SQL Programming Style

  • Article

There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]

4.67 (9)

2019-12-10

15,684 reads

Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)

  • Article

With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]

5 (9)

2019-08-08

5,415 reads

Blogs

Daily Coping 23 Sept 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Getting Up and Running with Dapr

By

I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...

Data Platform products for Microsoft gaps

By

Microsoft has a ton of data platform-related products, but there are certain areas where...

Read the latest Blogs

Forums

Wait type LATCH_EX [NESTING_TRANSACTION_FULL] - and blocking.

By Vladimir Isaev

We have this ad hoc query that is a recurring block leader, blocking dozens...

ADD Values from a table to an another table

By LD3060

I am working with Microsoft SQL Server MANAGMENT STUDIO 18  and i Have 2...

In-Place upgrade from SQL Server 2016 to SQL Server 2019 leaves older version

By ericwenger1

My company has decided that in-place upgrading to SQL Server 2019 for test environments...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers