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)
849 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
511 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
537 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
594 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,606 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
121 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
685 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
837 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
601 reads
Similar to the script posted before, but this one is for system tables with indexes, not for user tables.
2002-09-13
716 reads
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item Which Result II
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
exec('SELECT ProductName FROM product;')
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers