SQL Server Save Time Managing Multiple Servers With Central Management Servers
Central Management Servers give us a way to manage a collection of SQL Servers as one, a query executed against...
2018-05-15
67 reads
Central Management Servers give us a way to manage a collection of SQL Servers as one, a query executed against...
2018-05-15
67 reads
I find myself using Apply more and more in my queries, aside from the usual reasons I’ve been finding I...
2018-05-14
39 reads
If you’re seeing SSMS hang/lock timeouts when expanding nodes in the object explorer for a database it’s almost definitely caused...
2018-05-13
47 reads
I wanted to document a couple of important tasks you should be doing as part of your SQL Server maintenance/backup...
2018-05-12
51 reads
What Are They
Database snapshots are a readonly point in time version of a database. You can use them for things...
2018-05-11
2,236 reads
When working with large amounts of data in ETL jobs it can often can sink a lot of time inserting...
2018-05-10
789 reads
For a quick introduction to transaction isolation levels see my previous post on them.
Once snapshot isolation is enabled on a...
2018-05-08
1,671 reads
The Transaction log growing is completely normal however there are situations where a transaction log can get to a state...
2018-05-07
59 reads
Trace Flags are a way to change the behavior of the SQL Server database engine. They are often used for...
2018-05-06
94 reads
For older systems where the move to READ COMMITTED SNAPSHOT (RCSI) might not be an option or you’re running a...
2018-05-05
103 reads
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...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
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