2011-11-15 (first published: 2010-03-03)
9,847 reads
Articles
A Temporary Disagreement
Last month, Phil Factor caused a furore amongst some MVPs with an article that dared to suggest that for reasonably small-scale strategic uses, and with a bit of due care and testing, table variables are a "good thing". Not everyone shared his opinion.
2011-11-15
3,225 reads
Win a Trip into Space
The DBA in Space competition ends this Friday, November 18. You can still enter, and answer all the questions this week. If you work with databases in any way, you're eligible.
2011-11-15
1,731 reads
Tips for Upgrading a Cluster to SQL 2008 - Part 1
This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008
2011-11-14
3,027 reads
TSQL Challenge 69 - Find the most relevant advertisement based on keyw
Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.
2011-11-14
600 reads
Webinar: Whatever your source control system - seamlessly link it to SQL Server
In this webinar consisting of 30 minutes of software demonstrations followed by Q&A, you will learn how to link your database to your existing source control system within SQL Server Management Studio using Red Gate’s SQL Source Control.
We will also give you an exclusive preview of forthcoming custom scripts features in the next version of SQL Source Control and SQL Compare.
2011-11-14
1,598 reads
Window Functions in SQL Server
With SQL Server 2012, we are soon to enjoy a full range of Window Functions. They are going to make for some much simpler SQL queries, as Fabiano Amorim ably demonstrates here.
2011-11-14
4,521 reads
Organizational Approaches to Master Data Management
This series of technical articles describes organizational approaches to master data management.
2011-11-11
2,391 reads
2011-11-10 (first published: 2010-02-24)
11,568 reads
Using and Creating Mount Points in SQL Server
This article talks about the use of mount points on Windows server for SQL Server installations and shows how you can create them.
2011-11-10
19,462 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