Connect PerfMon to a Remote Server
It seems to be a simple & easy thing to connect Perfmon to a remote server.
GO TO RUN > Perfmon > Right Click...
2013-02-14
1,265 reads
It seems to be a simple & easy thing to connect Perfmon to a remote server.
GO TO RUN > Perfmon > Right Click...
2013-02-14
1,265 reads
I had the opportunity to present the latest version of Hardware 301: Diving Deeper into Database Server Hardware two times...
2013-02-14
1,134 reads
Photo credit: Digitalnative
About a year ago, I came across an online deal for a car stereo system with a USB...
2013-02-14
1,594 reads
A slightly off topic post, but since I was asked recently, I thought I’d take my reply, make a post...
2013-02-22 (first published: 2013-02-14)
2,682 reads
Thanks to everyone who attended my presentation “DBA: Transitioning to a BI Role” at the PASS Professional Development Virtual Chapter. The recording...
2013-02-14
1,774 reads
Seems so early in the year, but it’s already time to start getting ready for this year’s PASS Summit. There...
2013-02-14
694 reads
Welcome to Day 14 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-14
2,151 reads
I promised you some PowerShell scripts this year and this post is the first one. I can see the value...
2013-02-14
6,855 reads
My Nexus 7 tablet has grown on me, though I think it’s more about having a dedicated tablet than the...
2013-02-14
631 reads
I’ve been looking into the behaviour of statistics in SQL Server 2008 – so I’d like to present an overview from...
2013-02-20 (first published: 2013-02-14)
7,126 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