SQL Server vs. Oracle
Just so we’re clear, I use SQL Server. I like SQL Server. But, this doesn’t mean I have anything against...
2012-09-07
5,026 reads
Just so we’re clear, I use SQL Server. I like SQL Server. But, this doesn’t mean I have anything against...
2012-09-07
5,026 reads
The recommended location for the tempDb on an Azure virtual machine, is the non-persisted D: drive. This drive is actually...
2012-09-06
2,089 reads
In my last article “Introduction to Windows Azure SQL Database Services (Part 1)“, I’ve provided an overview of Microsoft Windows...
2012-09-06
1,259 reads
Many can boast that they were trained by Paul and Kimberly Randal at SQLskills. That company is so highly regarded...
2012-09-06
1,093 reads
This is normally not a place where we advertise for events held by our friends, but today I’ll make an...
2012-09-06
778 reads
I’m sure some people have bigger data, but Facebook has some serious daily growth. The highlight? 500TB a day.
A day.
That’s...
2012-09-06
986 reads
Odd Man Out
SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood.
Let’s...
2012-09-10 (first published: 2012-09-06)
2,826 reads
I can’t tell you how many times I’ve sat in a training room, in the middle of a week long...
2012-09-06
986 reads
DBCC Cleaning CACHE – Memory I wanted to write this blog for quite some time, here you go, as you know...
2012-09-06
962 reads
The prerequisite SQLServer 2008 R2 patch level for System Center Config Manager 2012(SCCM) is SP1 with Cumulative Update 6 (CU)
For...
2012-09-05
1,703 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