Trick or Treat...Have I got an IT Training treat for you...
It Trick or Treat on Monday...Two days on and I have a treat for you. Learning Tree's Great Value IT...
2016-11-02
497 reads
It Trick or Treat on Monday...Two days on and I have a treat for you. Learning Tree's Great Value IT...
2016-11-02
497 reads
In my last post I showed you how to conduct an assessment using DMA – Database Migration Assessment tool v2.0 This...
2016-11-02
596 reads
The Dynamic Management View (DMV) named sys.dm_db_index_usage_stats that track index usage details of the database. This DMV gives an information about...
2016-11-01
641 reads
* originally published in our old blog in August 2011 - updated with SQL Server 2016 reference
As a SQL Server developer you are often faced with the need to...
2016-11-01
46 reads
* originally published in our old blog in August 2011 - updated with SQL Server 2016 reference
As a SQL Server developer you...
2016-11-01
1,048 reads
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set...
2016-11-01
850 reads
SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself...
2016-11-11 (first published: 2016-11-01)
1,685 reads
A performance tuning tip I saw recently said, “Views don’t perform as well as stored procedures.”
<sigh>
Let’s break this down, just...
2016-11-09 (first published: 2016-11-01)
3,744 reads
I am proud to announce the availability of our new training offerings! We are launching a live web-based version of our...
2016-11-01
479 reads
In this module you will learn how to use the Sparkline Power BI Custom Visual. The Sparkline allows you to...
2016-11-01
682 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