Another month and another opportunity to write about an interesting topic. This month hosting TSQL Tuesday is Argenis Fernandez (Blog | Twitter). This month, Argenis has invited us to...
2012-03-13
9 reads
Another month and another opportunity to write about an interesting topic. This month hosting TSQL Tuesday is Argenis Fernandez (Blog...
2012-03-13
873 reads
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at HASSUG.
Here is the PowerPoint presentation: Scaling SQL...
2012-03-13
728 reads
UPDATE 2012-09-12 : For my latest adventures with TSQL Parsers please see this post
Every once in a while, I hit an issue...
2012-03-13
11,101 reads
It’s that time of the month again, T-SQL Tuesday Tuesday. This month Argenis Fernandez, MCM, and big round SQL teddy-bear...
2012-03-13
1,175 reads
This month, Argenis Fernandez (blog, @DBArgenis) is hosting our monthly T-SQL Tuesday, and he wants to know: Are you specialized?...
2012-03-13
957 reads
Every month the folks of the SQL Server community get together for a virtual block party of sorts called T-SQL...
2012-03-13
703 reads
Argenis Fernandez (blog | twitter) is hosting the latest T-SQL Tuesday and asking about specialization. For the earlier part of my career I was doing application development while really...
2012-03-13
29 reads
Argenis Fernandez (blog | twitter) is hosting the latest T-SQL Tuesday and asking about specialization.
For the earlier part of my career...
2012-03-13
705 reads
When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows...
2012-03-13
542 reads
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers