Robin Back


Technical Article

Display Defragmentation Of Selected Tables

This script will display the defragmentation of table(s) all indexes of selected tables and display a table/list of the DBCC SHOWCONTIG. It will aslo will report if there are tables in the list that can't be found in the current database. Run the script in the database where the tables you want to check are.Check […]

You rated this post out of 5. Change rating

2003-08-21

781 reads

Technical Article

Check if someone use a database or not

I manage quite a few hundred databases across the company. Time to time I get a question if I can check wheather a database is beeing used or not, and if it is, by whom?There are probably a 1000 ways to do this, but I've created a script for creating a scheduled job that runs […]

You rated this post out of 5. Change rating

2003-07-15

2,649 reads

Blogs

Resetting Git and Abandoning Changes–#SQLNewBlogger

By

I recently had an issue in one of my Git repos, and decided to...

Exploring Window Functions Execution Plans

By

There are quite a few different ways that you’re likely to see window functions...

Exploring Windows Function Execution Plans

By

There are quite a few different ways that you’re likely to see windows functions...

Read the latest Blogs

Forums

Program Code giving duplicate errors where no duplicates exist

By Andre 425568

On our Java Hibernate program it is giving a duplicate value on an insert...

Student Essay Help: Exploring the Best Essay Editing Services

By valentin

Essay writing is a fundamental component of academic life, demanding not only creativity and...

How to get calculated values from a derived(?) table?

By mjdemaris

Here is my filtered dataset: I would like to calculate the time difference between...

Visit the forum

Question of the Day

Disable Memory Grant Feedback Persistence

In SQL Server 2022, how can I disable memory grant feedback persistence?

See possible answers