How to Use xp_dirtree to List All Files in a Folder - Part 2
In a previous blog post, I demonstrated how you can use an undocumented stored procedure, master.sys.xp_dirtree, to list all files...
2012-12-31
22,982 reads
In a previous blog post, I demonstrated how you can use an undocumented stored procedure, master.sys.xp_dirtree, to list all files...
2012-12-31
22,982 reads
New Year begins,
Let us pray that it will be a year with new peace, new happiness and abundance of new...
2012-12-31
1,046 reads
It is Monday today but its no ordinary Monday. Today is New Years Eve, its the end of December and...
2012-12-31
1,808 reads
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.
Here’s an excerpt:
About 55,000 tourists visit Liechtenstein every...
2012-12-31
1,494 reads
I just discovered a few posts calling out a bug in the vSphere 5.1 vCenter performance statistic rollup procedure for...
2012-12-31
1,507 reads
SQLBits XI has been announced for the 2-4th of May 2013. Having taken place in London this year, it is moving back North to the Midlands at the East...
2012-12-31
16 reads
Hello folks, welcome to a post focusing on one of the future features of SQL Server. SQL Server 2012 is barely a year old, yet there is already talk...
2012-12-30
30 reads
SQL Server MVP Jeremiah Peschka posted 2 articles about Hadoop, which makes me be interested on the nosql skill.
I don't have much knowledge...
2012-12-29
2,861 reads
One of my previous posts, I covered how to create a really big database with just garbage data in it....
2012-12-29
1,170 reads
As you might be aware, SQL Server 2012 Standard Edition has some hardware-related licensing limits that I think should be...
2012-12-29
7,591 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