Writing More This Month
I haven’t written much in a while, having had to put more time into both personal and professional obligations over...
2016-11-07
374 reads
I haven’t written much in a while, having had to put more time into both personal and professional obligations over...
2016-11-07
374 reads
Last week I shared my custom Query Store Dashboard that can be used to view additional performance information that isn’t...
2016-11-07
2,154 reads
By Steve Bolton
…………Information on set operations like complements, intersections and unions is plentiful in the literature on fuzzy sets, which...
2016-11-07
805 reads
This
article is the part of series Mastering Index, in this particular article
we will be exploring Index on computed
columns. Take a look...
2016-11-07
579 reads
If you have created a SQL Database in Azure (PaaS) and need to make a copy of it on the...
2016-11-07
413 reads
Knowledge and ability, they are very inter-related. We born with only survival ability, ability to eat and drink, that’s pretty...
2016-11-07
1,420 reads
Open Source PowerShell is available on several operating systems, that really what’s special about the whole project! To get PowerShell to function on these various systems we need to...
2016-11-07
19 reads
Open Source PowerShell is available on several operating systems, that really what’s special about the whole project! To get PowerShell...
2016-11-07
688 reads
For the years I have been watching the SQLPASS session recording and hearing that it's really a different experience to...
2016-11-06
493 reads
Query Store collects 2 important kinds of data. They are
1) Compile time statistics - Query Plan, Estimated Costs, Estimated number of...
2016-11-06
831 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