Announcing SQL Saturday 197 Omaha Pre-Cons!
Here is a flyer produced by someone on the team - he says it all very well:
--
Friday, April 5, 2013
Get Warmed...
2013-02-07
818 reads
Here is a flyer produced by someone on the team - he says it all very well:
--
Friday, April 5, 2013
Get Warmed...
2013-02-07
818 reads
The Resource database is a read-only database that contains all the system objects that are included with SQL Server. SQL...
2013-02-07
731 reads
I was recently asked by a project manager to lay out when DBAs would accomplish certain tasks for a particular...
2013-02-07
1,422 reads
by Steve Bolton
In last week’s installment of this series of self-tutorials on SQL Server Data Mining (SSDM), we covered...
2013-02-07
2,580 reads
Quite a few years ago my first job in the military was driving a tracked vehicle, a variant of the...
2013-02-07
771 reads
The other day one of the developers I work with gave me a script similar to this:
BEGIN TRAN
sp_rename 'tablename.columnname', 'newcolumnname'
COMMITHe...
2013-02-06
796 reads
Last month I wrote about leveraging policy based management for regular DBA compliance checks. You can read that post here.
Policy based management(PBM) is indeed...
2013-02-06
819 reads
In my previous post I walked through configuring ADFS and writing a small C# console app to authenticate with it...
2013-02-06
547 reads
It seems that many of my projects in the past year or so have required sharing files with external business...
2013-02-06
1,177 reads
Welcome to Day 6 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-06
799 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