Setup windows firewall for SQL Server
On Windows 2008 R2, the windows firewall will turn on by default which causes connection issure for the remote client, here...
2012-06-01
5,432 reads
On Windows 2008 R2, the windows firewall will turn on by default which causes connection issure for the remote client, here...
2012-06-01
5,432 reads
I finally got my standing desk working last weekend and started on Tuesday (after Memorial Day) working at it on...
2012-06-01
1,123 reads
I wrote a post earlier this week telling you all about my trip to Ottawa last week, during my trip...
2012-06-01
878 reads
The Columbus GA SQL Users Group will be hosting their first ever SQL Saturday on September 8th 2012 at Columbus...
2012-05-31
1,725 reads
One of the most interesting things I've found as a DBA is learning about features in other RDBMS platforms. Sure...
2012-05-31
2,626 reads
Last time I went through my script to gather server information for my inventory. Today I’m going to go through...
2012-05-31
4,187 reads
Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or...
2012-05-31
1,827 reads
With the new Project Deployment Model in SSIS developers are gaining the benefit of a new design time only feature...
2012-05-31
3,806 reads
Denali – Day 31: Discontinue and Breaking/Behavior change features Discontinue Features: As discussed about Deprecated will going to discontinue with that...
2012-05-31
1,762 reads
This whole concept of the clustered index as a foundational structure within SQL Server is just plain nuts. Sure, I...
2012-05-31
2,393 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