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,509 reads
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,509 reads
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,363 reads
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,315 reads
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
442 reads
“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,018 reads
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,389 reads
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
617 reads
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
946 reads
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
964 reads
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,475 reads
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
I wanted to figure out how big (or approximately how big) my dump file...
Titolo: Banconote false: svelare la minaccia della moneta contraffatta Introduzione::☎️(Telegram……[ +1(331)642–0693]£CA$$€¥ £ La circolazione...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers