I mark my SQL with a 'Todo' symbol whenever I decide something needs work, but I don't have the time to do it right away. So I wrote this usp so that I can get a quick list of stored procedures, function and views that need some extra work.It also comes in handy whenever you […]
2007-07-06 (first published: 2006-10-03)
304 reads
It is a modified version of original script I found on net. This script creates conditional Update statements too.
2007-07-05 (first published: 2006-10-03)
578 reads
Clients asked me to show a more detailed and longer text which doesn't have to be edited. So I came up with the following solution/function.This function returns a varchar time value with a description containing how many days, hours and minutes. For example 100.25 returns :'100:15( 4 Days, 4 Hours, 15 Minutes )'.I hope somebody […]
2007-07-04 (first published: 2006-10-03)
146 reads
This procedure will maintain the sysproperties table by wrapping system procedures: • sp_addextendedproperty • sp_dropextendedproperty • sp_updateextendedproperty The parameters are: • @object -- primary name of the object being to be maintained. • @column -- column or parameter […]
2007-07-04
101 reads
This procedure will maintain the sysproperties table by wrapping system procedures: • sp_addextendedproperty • sp_dropextendedproperty • sp_updateextendedproperty The parameters are: • @object -- primary name of the object being to be maintained. • @column -- column or parameter […]
2007-07-04
446 reads
This script combines functionality of sp_helpindex and sp_spaceused to list all tables with individual indexes, their keys and description (sp_spaceused cannot do that) and size in MB per individual index (sp_helpindex cannot do that either). Feel free to use and modify as you see fit. Hope it can help.
2007-07-03 (first published: 2006-09-25)
2,662 reads
We write this script due we needed to implement a backup strategy in some machines with MSDE located in remote offices.In that offices there isn't Enterprise Manager, so we send the script to the office and they just execute it.Comments will be welcome
2007-07-02 (first published: 2006-09-23)
416 reads
In the tradition of best practice & code improvement, a third iteration of a script that finds the Nth occurrence of a Target string within another string (Original author unknown, V2 author vextant).This version returns zero if an Nth occurrence is not found (similar to V1), but also provides the ability to search the string […]
2007-06-29 (first published: 2006-09-18)
468 reads
Person name may have these combination in database1. firstname only2. middlename only3. lastname only4. firstname + middlename5. firstname + lastname6. middlename + lastnameAnd firstname, middlename, lastname may contain null or empty string in data. but usee want to display Fullname without spaces then how will combine all.
2007-06-28 (first published: 2006-05-15)
1,181 reads
The script is in three parts:1. A select statement to determine the number of duplicate records contained within the table2. The deduping process builds a temporary table called #Duplicates and uses it to compare duplicates across both similar tables whilst deleting records with multiple counts3. Final test of deduping with no records indicating table is […]
2007-06-27
410 reads
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
I am excited to host T-SQL Tuesday for the first time. I want to...
Telp/WA 62 8218200203 Jl. Komp. Rs. Fatmawati No.1, RT.1/RW.9, Cilandak Bar., Kec. Cilandak, Kota...
Telp/WA 62 8218200233 Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 Lt GF unit C,...
Telp/WA 62 8218200174 Gedung Multika, Jl. Mampang Prpt. Raya No.71-73, RT.1/RW.1, Tegal Parang, Kec....
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers