Using TRY..CATCH in SQL Prompt
I learned something new recently about SQL Prompt. I was working on documenting and experimenting with snippets and found a...
2016-10-24
1,391 reads
I learned something new recently about SQL Prompt. I was working on documenting and experimenting with snippets and found a...
2016-10-24
1,391 reads
Abstract
Monitoring disk space utilization of server(s) is a critical and important job for any administrator. Keeping things organized might improve...
2016-10-24
962 reads
I have just got back to the UK from Singapore following the amazing PSConfAsia conference. I must say that Matt,...
2016-10-24
536 reads
The things you read on the internet, for example, “don’t use a sub-query because that hurts performance.”
Truly?
Where do people get...
2016-10-24
1,540 reads
In this module you will learn how to use the Force-Directed Graph Power BI Custom Visual. The Force-Directed Graph allows...
2016-10-24
876 reads
If you are attending the PASS Summit, or even in the Seattle area, we have a SQL Server pro networking...
2016-10-24
492 reads
You’ll hear these terms thrown around in programming all the time, but what do they mean and why do we...
2016-10-24
798 reads
It's been a while, but since I now get to play with SQL 2016 full time, I have new things to talk about! One of major difficulties that any technology...
2016-10-24
54 reads
It's been a while, but since I now get to play with SQL 2016 full time, I have new things...
2016-10-24
746 reads
Free workshop on SQL Server leading up to Summit 2016 that will provide attendees an alternate means to increase affordable learning opportunities during the week.
Related Posts:
Seattle SQL Pro Workshop...
2016-10-24
14 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