Schedule Announced for SQLSaturday #151 in Orlando
We had 45 speakers submit sessions this year. Sticking to our tradition here in Orlando, we accepted as many speakers...
2012-08-13
353 reads
We had 45 speakers submit sessions this year. Sticking to our tradition here in Orlando, we accepted as many speakers...
2012-08-13
353 reads
Around April this year, my men's accountability group was talking about a shared pain: income taxes. We were all worried...
2012-08-13
1,717 reads
Lately I’ve hit a couple blogs that wanted me to enter some kind of credentials before I could post a...
2012-08-13
381 reads
This one comes straight from the email bag. A friend recently had a problem, they were placing TDE on a...
2012-08-17 (first published: 2012-08-13)
5,766 reads
I developed the below script to find the details of a AD user and the AD groups he is associated...
2012-08-13
7,926 reads
This is one of the powershell script I have been using quite regularly from the day I developed. Most of SQL...
2012-08-13
2,167 reads
Do you still use trace flag 1204 and 1222 to monitor Deadlock? or using profile to capture deadlock? Now we...
2012-08-16 (first published: 2012-08-12)
18,099 reads
I wrote the following query that returns the list of all CLR functions/procedures/objects exists inside your database:
SELECT o.object_id AS [Object_ID]
...
2012-08-12
1,324 reads
We can either use SQL Server Management Studio or use Transact-SQL query to find any SQL Agent jobs that have...
2012-08-12
2,676 reads
If you’re interested in woodworking, read on!
I’ve been thinking of making a hand plane out of wood and was doing...
2012-08-12
819 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