SQL Server Quickie #3 – Allocation Units
Today
I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I'm talking
about Allocation Units in SQL Server....
2012-09-18
1,592 reads
Today
I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I'm talking
about Allocation Units in SQL Server....
2012-09-18
1,592 reads
One of the advanced Server level options for SQL Server is Max Text Replication Size and this is really not a common...
2012-09-24 (first published: 2012-09-18)
6,918 reads
The Virtual Chapters of PASS are asked to host sessions during this Fall’s 24 Hours of PASS preview for the...
2012-09-18
1,002 reads
When you work as DBA, many people will approach you with a complaint like "Application is taking ages to load...
2012-09-18
1,420 reads
I recently turned on OPTIMIZE FOR AD HOC WORKLOADS for the first time on one of my servers. When I...
2012-09-18
1,383 reads
We are less than two weeks away from SQL Saturday #149 in Minneapolis on September 29, 2012 with two preconference...
2012-09-18
530 reads
Last year I had the pleasure of speaking at two SQL in the City events: London and Los Angeles. It...
2012-09-18
1,392 reads
SQL Saturday #171 Pittsburgh preparations continue, and the schedule has been posted for your review. If you're anywhere in the...
2012-09-18
760 reads
More stuff you may find interesting.
Prepare for your first security breach. Sobering. As data professionals we’re going to get pulled...
2012-09-20 (first published: 2012-09-18)
2,143 reads
It’s one of the most enjoyable things about being a consultant.
I’m not talking about my suspect dance moves here. I’m...
2012-09-18
1,165 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