Operational business intelligence is about delivering information to people when and how they need it in the context of business need. Explore the five best practices best-in-class companies are using to drive faster, better decision making and higher customer satisfaction.
Computed columns are an interesting way to cover some queries that might otherwise require a table scan. SQL Server expert Andy Warren brings us a look at this database design feature.
What is the page size in SQL Server 2005? That's an easy question, but what is the maximum row size? They're not the same thing and ANdy Warren shows you why.
One of our top posters and valuable member of the SQLServerCentral.com community weighs in on his absence.
Learn how to change a group of SQL Server stored procedures (SPs) that perform tasks in your databases. Edit SQL Server SPs at one time with these steps.
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
Enhanced model performance comes from extracting as much information content as possible… relative to the specific performance metrics you are using to measure success.
Windows 2008 RTMs, a change from the SQL Server support team, and a Jump Start for Katmai.
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