Apologies in advance
This is a quick post to apologise in advance if all my historical blog posts get republished.
Recently it appears that...
2017-04-06
338 reads
This is a quick post to apologise in advance if all my historical blog posts get republished.
Recently it appears that...
2017-04-06
338 reads
Microsoft recently introduced a handy new feature to query plans: waitstats. That’s right, you can get actual runtime waitstats for...
2017-04-05
510 reads
Since becoming a Database Administrator I’ve always looked at Microsoft MVP’s as the giants in our field. I never once...
2017-04-05
343 reads
If there’s one thing that SQL Server is really good at, it’s relationships. After all, a relational database management system...
2017-04-05
128 reads
Last night I had the privilege to present to the Ohio North SQL Server User Group about JSON in SQL Server 2016. There was a great crowd present (they...
2017-04-05
16 reads
If you’ve been involved in technology for any length of time you are aware of outside threats to your network...
2017-04-05
381 reads
I think SQL Clone is a useful, handy product. It’s what I’ve needed in a number of organizations, or it’s...
2017-04-05
653 reads
Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. No...
2017-04-05
510 reads
Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have been wanting to write on...
2017-04-05
443 reads
One of the questions that I was asked at SQL Saturday Iceland was “how can I view the filesystem within...
2017-04-05
182 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...
Jl. Zainul Arifin No.78, Sukoharjo, Kec. Klojen, Kota Malang, Jawa Timur 65118
Jl. Thamrin No.8, Lawang, Kec. Lawang, Kabupaten Malang, Jawa Timur 65211
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