HOW TO Set up TEST Environment for SQL SERVER 2014 CTP2 or SQL SERVER 2012 PART 1
Originally posted on SQL DBA learning curve:
Hey ALL, if you are looking forward to set-up a test server for playing...
2013-12-24
585 reads
Originally posted on SQL DBA learning curve:
Hey ALL, if you are looking forward to set-up a test server for playing...
2013-12-24
585 reads
Originally posted on SQL DBA learning curve:
Hi ALL, for setting up TEST env for Server 2012 and above refer to...
2013-12-24
708 reads
This year has been so awesome!! I hope to do better in the coming year and be able to share...
2013-12-24
455 reads
Here’s a great article that I came across while on my cookie break. The demonstration is so simple and straightforward....
2013-11-27
1,154 reads
To identify columns on which you need to create indexes for fine tuning query performances you can run the T-SQL...
2013-11-27
1,462 reads
Originally posted on Journey to SQL Authority with Pinal Dave:
[Note from Pinal]: This is a fourth episode of Notes from...
2013-11-26
629 reads
This reviewer is still part of lesson in Implementing High Availability in SQL Server 2012. This covers about 12% of...
2013-11-17
558 reads
As a DBA, I work closely with the Infra guys to manage domain accounts. Now and then, there comes a...
2013-11-15
523 reads
Scenario: I have given a new storage by SAN team to move my database files and logs from old drive...
2013-11-13
1,477 reads
From my last post, http://coffeeandsql.com/2013/11/10/70-457-reviewer-15-implement-database-mirroring/, you were able to successfully setup a database mirroring. For further monitoring and checking if...
2013-11-11
1,063 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
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.
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
exec etl.GettheProduct
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