Password Resets
I read this piece from Troy Hunt, which is a long look at the password reset process for a web...
2012-07-31
1,687 reads
I read this piece from Troy Hunt, which is a long look at the password reset process for a web...
2012-07-31
1,687 reads
One of the most amazing features to an old SQL Server 4.2 guy was the addition of DDL triggers to...
2012-08-07 (first published: 2012-07-31)
2,803 reads
I just composed and sent this message to eleven members of a single California-based recruitment company. I’ll let the email...
2012-07-31
1,756 reads
Reading Excel data isn't easy. It should be, but there's a lot of unfortunate barriers in the way that I've discussed before. They boil down to one main reason:...
2012-07-31
1,789 reads
Welcome back, folks!
Ok so, now that we’ve covered the basics of creating a SQL Audit and viewing the output, let’s...
2012-08-06 (first published: 2012-07-31)
6,746 reads
BCP, or bulk copy program, has been around in SQL Server for a long time. It is a great way...
2012-08-03 (first published: 2012-07-31)
10,917 reads
OLAP PivotTable Extensions is a really cool free add-in for Excel that’s been around for quite a while now. It...
2012-07-31
1,918 reads
I’m having a little fun with documenting basic information about indexes in my current project. I’m posting the scripts here...
2012-07-31
2,108 reads
Reading Excel data isn't easy. It should be, but there's a lot of unfortunate barriers in the way that I've...
2012-08-02 (first published: 2012-07-31)
4,807 reads
As a DBA, we have to take various actions based on huge amount of information received. In one perspective, our...
2012-07-31
1,908 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