Why we need a PASS Sponsor Portal
Major sponsors in our space get hundreds of emails from us each year, all asking for money. Those are all...
2016-11-11
405 reads
Major sponsors in our space get hundreds of emails from us each year, all asking for money. Those are all...
2016-11-11
405 reads
CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server where the target database is.
First time deployment
Backup / restore...
2016-11-11
19 reads
CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server...
2016-11-11
2,151 reads
If you’ve spent much time working with the SSIS catalog, you likely already know that the catalog is where all...
2016-11-15 (first published: 2016-11-11)
1,848 reads
I will be writing this series of articles for the Special Indexes in SQL Server. In this series we will...
2016-11-11
534 reads
This post is about the importance of a right index to a query. The following simple query was considered.<?query --SELECT [GroupBy1].[A1]...
2016-11-11
343 reads
It’s Friday so no releases to Production today (ha!) which means in-between my code reviews, server audits and other tasks...
2016-11-11
307 reads
Problem
When creating Linked Servers, security often gets overlooked. This can lead to accounts on one instance having access, sometimes with...
2016-11-11
22,451 reads
WOW!!! The next great update to Execution Plans is a way to watch the processing of rows through iterators while...
2016-11-15 (first published: 2016-11-10)
2,069 reads
With Windows Server 2016 just been released, now is the perfect time to build an Azure VM with SQL Server...
2016-11-10
1,043 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers