Database Fundamentals #7: Create a Table Using T-SQL
The syntax for creating a table logically follows many of the same steps that you did when using the GUI,...
2017-08-07
195 reads
The syntax for creating a table logically follows many of the same steps that you did when using the GUI,...
2017-08-07
195 reads
The syntax for creating a table logically follows many of the same steps that you did when using the GUI,...
2017-08-07
302 reads
Are you a DBA and just inherited a SQL Server or Oracle database? Are you migrating from one or the...
2017-08-07
332 reads
I have the pleasure to announce I’ll deliver a webcast for MSSQLTips.com at the August 24th of 2017. The webinar...
2017-08-07
297 reads
Once you go cloud, there is no going back. This is false and from a database perspective you can migrate...
2017-08-07
450 reads
The Good, the Bad, and the Ugle¯e¯ (need to avoid copyright infringement ?? )
SQL Server 2017 is soon to be officially...
2017-08-07
2,379 reads
Virtual IP (VIP) is a public IP address and created when a cloud service is created. A VIP is a...
2017-08-07
601 reads
Diagraming and Documentation
Previously, I've written up on database diagramming for visualization of database structures. Check that out for more detailed...
2017-08-07
775 reads
update 2019-02-22
Image links broken. Since their product is continually improving, I'm going to just link to their product here instead so you can review their latest demo content there....
2017-08-07
26 reads
This post assumes you've already setup InfluxDB and have Grafana running.
Inserting annotations Annotations are not a special type of resource, instead it's just another metric that you query with...
2017-08-07
79 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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
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