SQL Server Virtualization
This past summer I have been working on a new course for Learning Tree 2109 SQL Server Virtualization and Consolidation:...
2012-09-12
999 reads
This past summer I have been working on a new course for Learning Tree 2109 SQL Server Virtualization and Consolidation:...
2012-09-12
999 reads
Last year I wrote about stuff I carry in my laptop bag. Nothing original, definitely a tendency to carry things...
2012-09-12
1,231 reads
Many of you have attended sessions by technical speakers at conferences and mini-conferences like SQL Saturday, SQL Rally, 24 Hours...
2012-09-12
1,102 reads
By Jennifer Salvo
Today is T-SQL Tuesday #34 hosted by Rob Volk (B, T). This month’s topic is ‘Help! I Need...
2012-09-11
900 reads
The Denver SQL Saturday is coming in less than two weeks, SQL Saturday #169 is our second event in Denver,...
2012-09-11
942 reads
I couldn’t resist, so here goes….
Help, I need some data,
Help, not just any data,
Help, I was told you...
2012-09-11
987 reads
It appears that I signed up to speak at the San Diego SQL Saturday coming up this weekend. I knew...
2012-09-11
704 reads
The SQL Server PDW (Parallel Data Warehouse) is a beast of a machine. Spreading workload across multiple nodes inside the...
2012-09-11
1,537 reads
Page 9 in file 1 (of the primary filegroup) in a SQL Server database is the header page and contains...
2012-09-11
2,151 reads
Over clause can be used in association with aggregate function and ranking function. The over clause determine the partitioning and...
2012-09-17 (first published: 2012-09-10)
10,490 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