Indexes on GUIDs – Not Only Fragmentation
A client called us with the following issue:
He had a table of a few dozen million rows. The table had...
2015-08-03 (first published: 2015-07-27)
2,740 reads
A client called us with the following issue:
He had a table of a few dozen million rows. The table had...
2015-08-03 (first published: 2015-07-27)
2,740 reads
Yesterday I participated in PASS Performance Palooza.
I had a lot of fun delivering my session Columnstore Indexes – Questions and Answers.
The...
2015-07-24
547 reads
The PASS Performance Virtual Chapter has a tradition of yearly “Palooza events”, in which there are a few back-to-back online performance...
2015-07-21
482 reads
Everyone’s talking about “Big Data”, huge tables and data explosion right?
Can we have a problem of a table that is...
2015-06-26 (first published: 2015-06-16)
3,505 reads
Thanks to everyone who attended my 24 Hours of PASS session, The Data Loading Performance Presentation.
It was a lot of...
2015-06-25
660 reads
24 Hours of PASS is just around the corner, and I’m happy to say that this time I’ll be speaking...
2015-06-18
550 reads
Let’s look at the following script:
CREATE TABLE LoadMeFast (Id INT NOT NULL,
InsertDate DATETIME NOT NULL,
ABunchOfLetters NVARCHAR(100)
)
GO
SET NOCOUNT ON
GO
DECLARE...
2015-06-09 (first published: 2015-06-03)
4,055 reads
This past Wednesday, I delivered my session, “Query Progress Tracking in SQL Server” to the DBA Virtual Chapter.
The session covers...
2015-05-29
1,416 reads
Let’s say you remember a piece of code you need to optimize or take a look at, but you don’t...
2015-05-13
619 reads
You setup SQL Server Replication and everything looks fine. Rows are flowing between the servers and you think you’re done.
Right? Wrong..
At...
2015-05-04 (first published: 2015-04-22)
5,386 reads
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