Powershell script to create multiple SQL Server Connections
As with most of these types of things, I had a need. I want to show how using sys.dm_exec_[requests/sessions/connections] is...
2016-02-24
1,089 reads
As with most of these types of things, I had a need. I want to show how using sys.dm_exec_[requests/sessions/connections] is...
2016-02-24
1,089 reads
Okay so I already posted a round up post for this month. You can see it here. Tonight one of the participants, Rob Farley (Blog | Twitter) made me...
2016-02-24
33 reads
Okay so I already posted a round up post for this month. You can see it here. Tonight one of the participants, Rob Farley (Blog | Twitter) made me...
2016-02-24
39 reads
Okay so I already posted a round up post for this month. You can see it here. Tonight one of...
2016-02-24
446 reads
I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016.
The title is SQL Server BI Best Practices and its...
2016-02-24
700 reads
Continuation from the previous 76 parts, the whole series can be found at http://www.nikoport.com/columnstore/
I have written previously about SQL Server...
2016-02-23
699 reads
Today, thanks to a customer, I discovered one of those annoying little things that can really drive you nuts.
Basically, they were...
2016-03-01 (first published: 2016-02-23)
2,337 reads
This past weekend was SQL Saturday #478 – Albuquerque, and I was happy to have the chance to attend again. I...
2016-02-23
752 reads
This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...
2016-02-23
190 reads
This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...
2016-03-02 (first published: 2016-02-23)
2,370 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...
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