One Great Day And Mixed Feelings
If it happens two times then you know the first time wasn’t a fluke.
Today was my anniversary date for the SQL Server...
2012-10-02
1,027 reads
If it happens two times then you know the first time wasn’t a fluke.
Today was my anniversary date for the SQL Server...
2012-10-02
1,027 reads
I have been doing interviews for Pragmatic works for the past few years and I have come across quite a...
2012-10-02
2,792 reads
SQL Server Virtualisation and Consolidation: Hands-On
Come and join me in London this December for a three day course covering the...
2012-10-02
637 reads
In theory we cannot backup the log of a database which is in Simple recovery model, however there is a...
2012-10-01
1,109 reads
SQL Server Agent jobs are crucial to any SQL Server environment, as they are used for scheduling and performing critical...
2012-10-01
1,357 reads
I told people in New York at SQL in the City that I’d post some resources on the blog from...
2012-10-01
1,290 reads
Just before PASS Summit in November, House of Brick and I will be holding a free boot camp on Virtualizing...
2012-10-01
722 reads
Here is the October 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-10-01
1,743 reads
October already. The PASS Summit is coming soon and we’re entering the time of the year that many of us...
2012-10-01
613 reads
How many of you out there get approval to go to the PASS Summit (YES!) but then get denied the...
2012-10-01
643 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