Refreshing the SQL Server PowerShell Provider
Sometimes SSMS gives you stale results and there you have the Refresh button to fix that.
In SQL PowerShell, the same...
2017-01-06
552 reads
Sometimes SSMS gives you stale results and there you have the Refresh button to fix that.
In SQL PowerShell, the same...
2017-01-06
552 reads
One of the things that I’ve seen DBAs query for is free space in a database. In fact, this is...
2017-01-20 (first published: 2017-01-06)
3,101 reads
In my ongoing series on ETL Best Practices, I am illustrating a collection of extract-transform-load design patterns that have proven...
2017-01-16 (first published: 2017-01-06)
2,524 reads
Continuation from the previous 93 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post will talk about some...
2017-01-06
588 reads
Happy New Year to all of you out there! I know, I know it’s a week late but hey I’ve...
2017-01-06
347 reads
As SQL developer, you must have often come across a scenario where you need to remove the empty spaces at...
2017-01-06
2,090 reads
For those of you on the Denver SQL Server User Group e-mail list, you probably heard the news I am...
2017-01-05
358 reads
If you're lucky enough to have SQL Server 2016, go on and upgrade to SP1....you get extra-lucky special database snapshots...
2017-01-05
626 reads
At last year’s SQL in the City, I played the part of a manual DBA making changes and deploying those...
2017-01-12 (first published: 2017-01-05)
1,569 reads
Have you ever heard the phrase “Hold The Fort”? Long ago in battle supply routes were targeted by enemy regiments...
2017-01-12 (first published: 2017-01-05)
1,346 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