How Many Objects Can Own Pages in a Mixed Extent
I saw an exchange on Twitter this past weekend on the #sqlhelp hash tag about how pages are allocated for...
2015-09-14
670 reads
I saw an exchange on Twitter this past weekend on the #sqlhelp hash tag about how pages are allocated for...
2015-09-14
670 reads
Earlier this week, I got the opportunity to present online for the Oklahoma City SQL Server User Group on SQL...
2015-07-15
729 reads
Recently, I was working on a Peer-to-peer replication automation project. When I switched from my local test servers to some...
2015-04-16
762 reads
It’s time again for that T-SQL blog party T-SQL Tuesday, and this month’s host is Mike Donnelly (blog|@SQLMD). If you...
2015-04-14
706 reads
I recently installed my first deployment of Master Data Services (MDS). I installed the SQL Server 2014 (Enterprise Edition) MDS...
2015-04-13
853 reads
When you’re working through some vague performance issues (e.g., “SQL Server seems slow today”), one of the common things to...
2014-08-18
1,263 reads
I am honored to be selected to deliver 2 sessions at the SQL PASS Summit 2014. I will be delivering...
2014-06-29
1,332 reads
I talked previously about network pipelines and how to get the most out of a fat network in the post...
2014-05-07
1,193 reads
I have one more thing I want to talk about regarding the conversation I had recently with my friends and...
2014-02-14
1,122 reads
I was talking recently with my friends and former colleagues at Idera about the things that slow down SQL Server....
2014-02-11
1,093 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