SQL Server – Script to Configure TempDB Files per Number of Logical Processors
In order to reduce Tempdb contention one of the best practices is to maintain multiple sized Tempdb data files, matching the...
2014-06-24
1,240 reads
In order to reduce Tempdb contention one of the best practices is to maintain multiple sized Tempdb data files, matching the...
2014-06-24
1,240 reads
Often times it is required to find out the SQL name from the host names in a clustered environment so you...
2014-04-14
1,175 reads
Here is the session I gave for the techies at Microsoft about in-built tools available in SQL Server to analyze...
2014-02-11
963 reads
Though there are several ways for importing SSIS packages into SQL Server either by creating a stored procedure or using...
2013-11-04
769 reads
Before we get started on this topic, here is a quick fact..in SQL Server 2000, there used to be hard...
2013-10-14
1,138 reads
In this article I will show you how to restore a database that is encrypted with Transparent Data Encryption (TDE)...
2013-10-03
986 reads
Being part of the database engineering team, we were given a task to setup disaster recovery program for some of...
2013-10-03
758 reads
The command prompt utility dtutil can be very handy when we want to quickly export an SSIS package from either file system...
2013-10-02
1,484 reads
Sometimes you might want to add more than one column as primary key. For example, if you have three columns...
2013-09-17
601 reads
Registered servers is a great way to manage, categorize and access the SQL servers through SSMS and also one of...
2013-09-16
494 reads
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
The previous DBA created a certificate which expired 12/31/2025. I came in hoping to...
hi , i know this is a sql server forum but i think my...
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
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
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