Pratical Use of a SQL Server Database Snapshot
I was doing a database code deployment the other night and the first step in the release plan was “Take...
2015-09-29 (first published: 2015-09-23)
7,356 reads
I was doing a database code deployment the other night and the first step in the release plan was “Take...
2015-09-29 (first published: 2015-09-23)
7,356 reads
As I’ve mentioned before, living in Louisville offers up great opportunities to various events within the SQL Community. This weekend...
2015-09-23
536 reads
I want to drive home the importance of the predicate order when dealing with Extended Events. This is an important topic because it can be very helpful in maintaining...
2015-09-23
54 reads
I have mentioned predicate order previously and wanted to make sure I drive home the importance of the predicate order...
2015-09-29 (first published: 2015-09-23)
3,202 reads
I’ve you’ve run a query similar to the following:
SELECT *
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle);And gotten an error similar to:
Msg 321, Level...
2015-09-23
1,052 reads
The next version of SSIS is on the horizon. Are you ready?
In next Tuesday’s webinar, I’ll be reviewing and demonstrating...
2015-09-23
594 reads
I am going to ignore the fact that people don't want to install visual studio on a build server, in...
2015-09-23
539 reads
I am going to ignore the fact that people don’t want to install visual studio on a build server, in...
2015-09-23
45 reads
I am going to ignore the fact that people don’t want to install visual studio on a build server, in...
2015-09-23
68 reads
I am going to ignore the fact that people don't want to install visual studio on a build server, in the future there will likely be a way to...
2015-09-23
16 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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