Connecting Developers to Architectural Excellence
Connecting Developers to Architectural Excellence
Columnstore indexes and batch-query execution mode are deeply integrated in SQL Server 2012, and they work in conjunction with many of the Database Engine features found in SQL Server 2012. For example, database administrators can implement a columnstore index on…
The SQL Server product group has made significant modifications to the existing SQL Engine to improve scalability and Performance associated with the SQL Server Database Engine. Some of the main enhancements that allow organizations to improve their SQL Server workloads…
If we now the parameter name and want to know the Objects using that parameter then in that case we can use the below stored procedure to retrive the Object Names /*********************************************************************** * Author : V.U.M.Sastry Sagi * Date :…
I had observed that sp_depends wont work properly in many scenarios. So i had wrote this code to fetch the dependent objects on a table. /*********************************************************************** * Author : V.U.M.Sastry Sagi * Date : 11/11/2011 * Purpose: Returns all Objects…
Step 1: Creating a Table /* Create Table with 7 entries – 3 are duplicate entries */ CREATE TABLE DuplicateRcordTable (Col1 INT, Col2 INT) Step 2: Inserting data into the table INSERT INTO DuplicateRcordTable SELECT 1, 1 UNION ALL SELECT…
CREATE PROCEDURE FindPossibleBadIndex AS BEGIN — Possible bad Indexes (writes > reads) DECLARE @dbid INT SELECT @dbid = DB_ID() SELECT ‘Table Name’ = OBJECT_NAME(s.object_id), ‘Index Name’ = i.name, i.index_id, ‘Total #of Writes’ = user_updates, ‘Total #of Reads’ = user_seeks +…
The Below script will brings the Missing Indexes in the databases — =================================================== — Author: V.U.M.Sastry Sagi — Create date: 01/30/2011 — Description: Fetches the Missing Indexes — =================================================== CREATE PROCEDURE [DBO].[FINDMISSINGINDEXES] AS BEGIN SELECT MID.STATEMENT, MIGS.AVG_TOTAL_USER_COST * ( MIGS.AVG_USER_IMPACT…
The Below code will fetches each Table Name,# of Rows in that table, Reserved Size, Index Size,UnUsed Space in the given Database. — =================================================== — Author: V.U.M.Sastry Sagi — Create date: 01/12/2011 — Description: Fetches the tables and the size…
Below Code will execute FTP Commands from SQL Server. First thing you need to take care is create a text file with the name “ftp” and type all your ftp commands and then create the below procedure in SQL Server…