Execute at source, and will generate an output with TSQL commands to create temp tables filled with top 50 long lasting queries from all databases.
Then execute output at destination and will do the same and show comparison of matching queries!!
2016-12-19 (first published: 2016-12-06)
852 reads
This script exports to a text file the creation text of the stored procedures of your database. If you want, you can change the script to export the text of views or functions.
2004-03-29
516 reads
With this function you can recover from your table all the password save encripted with another function posted before (check this site to find the script). The function recieves an encripted password and changes every character to return the right password.
2004-03-18
542 reads
If you need to save password for you application in tables, with this function you can save them encripted. And with another published function (check the page to find the script) you can desencript it. The function receives the password, modifies every character and returns the encripted password.
2004-03-18
601 reads
Like sp_who2 but this one let's you specify to filter by spid, login, hostname and dbname.Like any system procedure, can be executed from any database.
2004-03-18
9,623 reads
This function allows you to capture the next valid error number to use in the sp_addmessage sp. No matter hoy much user errors you have define, you will always get the next available error number.
2004-02-27
126 reads
This one is For SQL 2000.This SP enable,disable or list all the Triggers in the given database.If enable or disable are specified, finds all the triggers of all the tablesand enable or disable them, After that, it list all the triggers with it´s current state.If List is specified, then it only list the triggers with […]
2002-09-19
699 reads
This sp translate all the numeric info from sysindexes and translate it into text. Also, can generate a log file to later view.Is like the one I posted before, but this one is for SQL 2000.
2002-09-17
840 reads
This SP enable,disable or list all the Triggers in the given database.If enable or disable are specified, finds all the triggers of all the tablesand enable or disable them, After that, it list all the triggers with it´s current state.If List is specified, then it only list the triggers with it current state. I didn't […]
2002-09-16
605 reads
Similar to the script posted before, but this one is for system tables with indexes, not for user tables.
2002-09-13
719 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Comments posted to this topic are about the item BIT_COUNT II
Comments posted to this topic are about the item I Can't Make You Learn
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers