SQL Server 2014 New Defaults
Today, April 1st, 2014, marks the release of SQL Server 2014. There are tons and tons of great new methods...
2014-04-01
975 reads
Today, April 1st, 2014, marks the release of SQL Server 2014. There are tons and tons of great new methods...
2014-04-01
975 reads
SQL Server 2014 is being released and a change in the defaults will ensure that more instances will run smoother.
2014-04-01
2,616 reads
You can spend less money. Some of us are lucky. We work for very large corporations who can easily set...
2014-03-31 (first published: 2014-03-25)
2,196 reads
I almost forgot to tell you about the Database Administration Virtual Chapter meeting next week, March 26th, 2014. I’ll be...
2014-03-21
638 reads
It really is so much easier to just throw hardware at badly performing databases. Just buy a bigger, faster server...
2014-03-19
1,186 reads
Ever had that moment where you start getting errors from code that you’ve tested a million times? I had that...
2014-03-18
780 reads
SQL Saturday’s are awesome! Let’s get that clear up front. The organizers of SQL Saturday events are glorious individuals. Let’s...
2014-03-17
670 reads
No, I don’t mean the use of sp_updatestats is not smart. It’s a fine, quick mechanism for getting statistics updated...
2014-03-11
1,113 reads
Developers, enamored of the integrated approach to Software Delivery, would like to be able to respond to business need in business time, adding functionality when the need is recognized, instead of 6-9 months later after it's gone through the sclerotic IT purchasing and configuration process.
2014-03-10
87 reads
This never gets easier. I was able to attend a bunch of sessions in the last month from a number...
2014-03-07
872 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