What is “SET STATISTICS TIME”?
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
464 reads
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
464 reads
Although I’ve been a regular user of SQL Server Reporting Services since it was released in the mid-2000s, I’ve done...
2016-12-18
420 reads
This weekend (10 December 2016), I went to Slovenia for a SQL Saturday. As always, it was an amazing event...
2016-12-18
838 reads
The SSIS catalog comes packaged with a rich set of built-in reports that give those monitoring Integration Services a window...
2016-12-17
426 reads
It was my office Xmas party last night so whilst recovering on my settee, I’ll be reading:-
The Most Important Role...
2016-12-17
357 reads
It’s coming towards the holiday season for me and I thought that I would wind-down a little with a non-technical...
2016-12-17
535 reads
NEWS FLASH: Power BI reports can be deployed to SQL Server Reporting Services web portal. The production-ready release is targeted...
2016-12-16
460 reads
In my last post I shared how to build a package in SSIS to perform simple file archive (zip) operations....
2016-12-16
621 reads
I look at locking resources within Azure as a safety mechanism where it can protect users from accidental deletion, it...
2016-12-16
536 reads
Next to releasing a new version of sp_WhatsupQueryStore, I just released the 1.3 version of the Query Store Database Dashboard!
Release...
2016-12-15
538 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,...
Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec. Cilandak, Kota...
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