Billing rates – other side of the fence
The following is a guest post by Tim Morgan from Sullexis in response to a resent blog of mine:
Thanks for letting...
2012-11-27
1,686 reads
The following is a guest post by Tim Morgan from Sullexis in response to a resent blog of mine:
Thanks for letting...
2012-11-27
1,686 reads
A sound indexing strategy is paramount to performance in an OLTP system. Not having the correct indexes in place can...
2012-11-27
2,568 reads
When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a...
2012-11-27
1,651 reads
In this article We are going to INSERT a record in a simple table and try reading Transaction log record.
Note:...
2012-11-27
4,549 reads
Folks have cited the recent InformationWeek article on how South Carolina's Department of Revenue was hacked because the SC state government...
2012-11-27
3,186 reads
Did you know that a SQL Saturday in Fargo is in the works? If not them, hey… there’s a SQL...
2012-11-30 (first published: 2012-11-26)
1,186 reads
I’m in the middle of reading a good book on DMVs, “SQL Server DMVs in Action” http://www.manning.com/stirk by Ian W....
2012-11-30 (first published: 2012-11-26)
4,638 reads
There’s a one day sale going on at Apress today, 11/26/12. All their eBooks are $15. This means you can...
2012-11-26
1,113 reads
As you may know, SQLskills has been creating a lot of great new courses about SQL Server for Pluralsight. Nearly...
2012-11-26
1,198 reads
Whilst working at a client site, I hit upon one of those issues that you are not sure if that...
2012-11-29 (first published: 2012-11-26)
2,287 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