Loadbalancing SQLServer
Loadbalancing SQLServer is not something that comes straight out of the box. If you want to use load balancing you...
2013-11-12
3,416 reads
Loadbalancing SQLServer is not something that comes straight out of the box. If you want to use load balancing you...
2013-11-12
3,416 reads
In the last couple of months SQLTreeo has improved her customer contact skills. Before it was just an email to...
2013-09-13
814 reads
New SQLTreeo version introduced local storage option when your folders are stored to file system as structure of files and...
2013-03-28
1,675 reads
We are glad to announce that new SQLTreeo SSMS Add-In was published.
List of new features/enhancements are following:
Local storage support...
2013-03-20
946 reads
Today is the first day when we turned SQLTreeo into a commercial product and your emails continue to flood into...
2012-10-25
1,482 reads
New version of SQLTreeo SSMS Add-In was released. We fixed few bugs and include also one major change – SQL Server...
2012-10-24
960 reads
I would like to inform you that I transferred all activities around SQLTreeo SSMS Add-In to couple of persons who...
2012-09-21
768 reads
Last few month I was really busy and had completely no time for SQLTreeo. This add-in was started being used by...
2012-07-12
824 reads
Hi,
I was trying to solve SQL Treeo’s performance issue on slow connection. This posts is also covers feature request of...
2012-05-12
1,075 reads
Hi,
one of SQL Treeo users developed clever workaround for SQL Treeo SSMS Add-in to be more compatible with RedGate SQL...
2012-05-11
1,186 reads
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
Comments posted to this topic are about the item Your AI Successes
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
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