Give us all the features
The mix of hardware and feature limits in SQL Server varies by edition. Steve Jones thinks it should be simplified to only matter for hardware and scale, not features.
2011-10-18
335 reads
Editorials
2011-10-17
91 reads
Does It Help
This editorial was originally published on Oct 12, 2006, published today as Steve is out today at the PASS Summit. Today Steve talks about the productivity that comes from having multiple monitors.
2011-10-14
98 reads
The Contest That's Out of the World
Steve Jones talks about the most interesting contest, evah! Brought to you by Red Gate Software.
2011-10-13
99 reads
The Countdown
Steve Jones has a short piece today, about an announcement coming today at 10am PST during the PASS Summit.
2011-10-12
141 reads
The Half Day Experiment
A change at the PASS Summit this year has Steve Jones watching to see if it works out well for attendees and speakers.
2011-10-11
71 reads
A Nice Refund
This editorial was originally published on Sept 12, 2006. The IRS makes a $318mm mistake and Steve talks about the need to ensure that you don't do something similar.
2011-10-10
144 reads
2011-10-10
107 reads
The DR Test Schedule
Planning for disaster recovery entails a lot of different items, but testing is an important one. If you don't test your plans, you can't be sure they will work. This Friday Steve Jones asks how often your test.
2011-10-07
193 reads
Come Find Me at the Summit
Steve Jones reminds you to network anytime you're at and event, and especially a large conference like the PASS Summit.
2011-10-06
50 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Comments posted to this topic are about the item Faster Data Engineering with Python...
Which Result II
Comments posted to this topic are about the item Which Result II
JSON Has a Cost
Comments posted to this topic are about the item JSON Has a Cost, which...
Question of the Day
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