Remote Desktop and Surface
The Windows RT operating system is not the same as Windows. After all the talk about the upcoming OS and...
2012-11-14
2,375 reads
The Windows RT operating system is not the same as Windows. After all the talk about the upcoming OS and...
2012-11-14
2,375 reads
The SQL Server Parallel Data Warehouse and SQL Server Fast Track Data Warehouse are very high end builds of Microsoft’s...
2012-11-14
929 reads
This week’s SQL Skills insider email contains a simple but often too true scenario regarding database mirroring. If you haven’t...
2012-11-21 (first published: 2012-11-14)
2,740 reads
SQL Server Virtualisation - Lots of companies and organisations are adopting a virtualisation first approach to the installation of new servers...
2012-11-14
787 reads
Today, We try to check of SQL server when trying to take Compress & UnCcomprees Backups in one Media\File.
Query No. 1
BACKUP...
2012-11-14
2,519 reads
OK. So you followed the First Rule of Holes -you stopped digging yourself in deeper. But now what? You are still in a Hole. Your situation has not changed...
2012-11-14
13 reads
OK. So you followed the First Rule of Holes -you stopped digging yourself in deeper. But now what? You are still in a Hole. Your situation has not changed...
2012-11-14
20 reads
Chris Yates (@YatesSQL / blog) is hosting the T-SQL Tuesday blogging party this month, and he wants to know “What does...
2012-11-13
738 reads
If you are using Transparent Data Encryption TDE and have Instant File Initialization turned on, you are not getting the...
2012-11-13
962 reads
Today is T-SQL Tuesday #36, hosted by Chris Yates (B | T). The topic this month is ‘What Does the SQL...
2012-11-13
799 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