Install MongoDB 3.2 on Windows
We can install MongoDB as a windows service. The steps are given below
Prerequisite –
Install Hotfix kb2731284 on the MongoDB Server...
2016-01-05
2,098 reads
We can install MongoDB as a windows service. The steps are given below
Prerequisite –
Install Hotfix kb2731284 on the MongoDB Server...
2016-01-05
2,098 reads
Over the past few years one of the big drives and innovations in the SQL Server world, has been to bring...
2016-01-05
456 reads
Next Wednesday, January 13th, at 1pm Eastern the PASSVirtualization Virtual Chapter will be holding an open questions and answers session on...
2016-01-05
451 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
One...
2016-01-05
1,714 reads
In just a few weeks… on January 30th, I’m going to be jumping into White Bear Lake in Minnesota. Now...
2016-01-05
422 reads
I often get asked the questions “What is SSDT" and I have wanted to have a single reference as to...
2016-01-11 (first published: 2016-01-05)
4,476 reads
I often get asked the questions “What is SSDT” and I have wanted to have a single reference as to what it is as it is actually pretty big....
2016-01-05
19 reads
I often get asked the questions “What is SSDT” and I have wanted to have a single reference as to...
2016-01-05
68 reads
I often get asked the questions “What is SSDT” and I have wanted to have a single reference as to...
2016-01-05
53 reads
I found a bug where I’m seeing TempDB use more memory than it should on multiple versions of SQL Server, especially on servers set up with common best practices. There’s a...
2016-01-05
26 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