SQL: Different ways to generate sequence
There was a question from the op regarding adding a new column to a query output by generating the cyclic...
2017-02-09 (first published: 2017-02-06)
2,512 reads
Prashanth Jayaram
SQL Server 2016: JSON integration
Abstract
This article helps to explain the application of JSON data and the use of new SQL 2016 constructs that enable...
2017-01-23
5,385 reads
SQL Server: How to backup and replace text in all search string matching Stored Procedure(s)
Table of Contents
Problem Statement:-Solution:-Generate script for matching search string of all SP’s
Using sp_helptextUsing system view sys.proceduresGenerate modified SP’s scriptCreate Linked...
2017-01-12
1,341 reads
My Interview published on Microsoft Technet Blog
Wish you a Happy New Year to all the readers and technical enthusiasts!!!
https://blogs.technet.microsoft.com/wikininjas/2017/01/02/interview-with-a-sql-server-expert-and-wiki-ninja-prashanth-jayaram/
My interview is published on the Microsoft Technet blog...
2017-01-03
445 reads
PowerShell : Monitoring and Notification – Disk Space Alerts
“Microsoft Technet Guru – Gold Medal Winning Article- Nov, 2016”
Abstract
Monitoring disk space utilization of server(s) is the critical and important job for...
2016-12-19
1,022 reads
SQL Server: Discuss Execute(SQL) At LinkedServer
Abstract
This article details the use of “Execute AT LinkedServer” clause. It’s best in some ways when you are trying to run...
2016-11-09
1,622 reads
SQL : How to Find Unused Indexes details
The Dynamic Management View (DMV) named sys.dm_db_index_usage_stats that track index usage details of the database. This DMV gives an information about...
2016-11-01
626 reads
PowerShell : CSV – Disk Space Report – Excel
Abstract
Monitoring disk space utilization of server(s) is a critical and important job for any administrator. Keeping things organized might improve...
2016-10-24
949 reads
PowerShell: Extending Modules – System Parameter measurement
The Microsoft Technet Guru Award (August 2016) winning article – Silver
PowerShell: Extending Modules – System Parameter measurement
PowerShell: Extending Modules – System Parameter measurement
Abstract
The...
2016-10-03
969 reads
SQL Server: Monitoring Disk Space with FSUTIL command line utility
Table of Contents
IntroductionPre-requisitesData flowEnable xp_cmdshellDownloadSQL CodeOutputConclusionReferencesSee Also
Introduction
This article talks about one of SQL method to fetch the disk usage details...
2016-09-27
1,619 reads
Blogs
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Was the index created or not?
Hi everyone I am getting an error when I create the index but I...
SSIS Package is reporting successful however is short 80-100k records
Good morning all, I have been running into a very random weird issue that...
Question of the Day
Estimated Rows
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022? See possible answers