Michael Smith

Prioritize Missing Index Recommendations 2 (2005)

This is an enhanced version of my previous script: Prioritize Missing Index Recommendations (2005).To aid in evaluation of whether the recommended index is reasonable, I have added :1. counts for key columns and the total columns of the recommended index  2. the length/bytes for both key and all columns  Note this is 'per row', not […]

5 (2)

2007-08-17

1,824 reads

Blogs

Graph – Shortest Path

By

‘Shortest path’ is by far the most feature of SQL Graph for now. What...

Last Week Reading (2019-09-22)

By

Hello #datafolks! Let’s review what happened last week in Data World. It’s hard to...

Simple Graph Queries

By

In this post we saw how to create some graph tables with data. In...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

memory not getting released to OS

By vsamantha35

Hi All, Need help here. Why is sql server is not releasing memory to...

Will the principal wait for acknowledgement from mirror?

By coolchaitu

Good Morning Experts, A transaction was sent to mirror database and immediately failover occured....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers