Networking and the PASS Summit
PASS Summit 2016 is fast approaching. If you’re going, time to start making plans. If you’re not going, sell your...
2016-09-27
422 reads
PASS Summit 2016 is fast approaching. If you’re going, time to start making plans. If you’re not going, sell your...
2016-09-27
422 reads
Piggy backing onto the recent SQL Saturday post here in Louisville, I wanted to take a more in-depth look, from...
2016-09-27
333 reads
SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself...
2016-10-21 (first published: 2016-09-27)
1,848 reads
It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b)...
2016-10-10 (first published: 2016-09-27)
2,062 reads
I will be writing
this article in four parts because this topic is huge and amount of information
can be overwhelming for...
2016-09-27
512 reads
TSQLCircleLive: What will be the result of the query below? Explai...: select case when null = null then 'True' else 'False'...
2016-09-27
377 reads
When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that...
2016-10-11 (first published: 2016-09-27)
1,510 reads
It less than week to SQL Relay - a week long SQL conference that is visiting Birmingham, Cardiff, Reading, Nottingham and...
2016-09-27
508 reads
In our last blog on Future DBA, we discussed on HADOOP -HDFS system. how as we know HDFS management is...
2016-09-27
415 reads
select case when null = null then 'True' else 'False' end as ResultSet;
2016-09-26
160 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