SQL Index Rebuild vs Reorganize, SQL Exists, System Functions and Excel as Front-End App

[MSSQLTips.com logo]( [View email in your browser]( [Find Performance Problems Beneath the Surface]( [Find Performance Problems Beneath the Surface]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [SQL Index Rebuild vs Reorganize Comparison]( This tip covers the differences and similarities between SQL Server index rebuild and index reorganize operations.... [mssqltips image]( [Performance Problems Lurk Beneath the Surface]( On the surface it's not always clear where your performance problems are. Users might complain, but CPU and memory stats look healthy. SQLGrease goes beyond basic performance statistic monitoring and takes you to the queries and the root cause.... [mssqltips image]( [SQL EXISTS Use Cases and Examples]( This tip will explain what the SQL Server keyword EXISTS does and show several different use cases of how you can use EXISTS.... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [Microsoft Fabric OneLake Role Based Access Control (RBAC)]( In this tip, we'll explain how to use role-based access control (RBAC) in OneLake to restrict access to certain folders.... [mssqltips image]( [Deep SQL Query Optimization Insights]( Learn how to conduct deep SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats, capturing anomalies and intelligent notifications.... [mssqltips image]( [SQL Server Stored Procedure Tutorial]( This tutorial look at how to create stored procedures in SQL Server to be able to reuse the code for various purposes.... ADDITIONAL RESOURCESÂ ON MSSQLTips [mssqltips image]( [SQL Server Functions for Tables, Views, Indexes, Columns, Stored Procedures]( SQL Server provides several system meta data functions which allow users to get property values of different SQL Server objects/securables. Although you can use the Catalog views or Dynamic Management Views to get the information, sometimes the syste... [mssqltips image]( [Know Your Business (KYB) Data Verification]( Learn how to meet Know Your Business Data Verification rules with Melissa Personator Identity Global to prevent fraud or money-laundering and meet legal regulations.... [mssqltips image]( [Excel as Front End App for SQL Server]( In this article, we walk through how to set up a simple Excel interface to work with SQL Server data to insert, update, delete, and select data.... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]