It's always something
As Phill posts in his blog, we've had a couple interesting threads in the forums where the respect and tolerance...
2005-07-11
1,461 reads
As Phill posts in his blog, we've had a couple interesting threads in the forums where the respect and tolerance...
2005-07-11
1,461 reads
2005-07-08
1,462 reads
I got a note that someone thought they shouldn't have to register on
the site and get a newsletter to read...
2005-07-07
1,396 reads
When I wrote the editorial for today on A Humbling Experience,
I was sure that it would generate a bunch of...
2005-07-07
1,523 reads
Two in a month? Steve Jones brings us another mistake made by a DBA in SQL Server. Everyone makes them and we may not like to admit to them, everyone that we print hopefully helps a few other SQL Server DBAs avoid that particular mistake. This one looks at the dangers of sorting by aliases.
2005-07-06
13,522 reads
Andy and I had an interesting question on this today. He's trying to
hire a DBA and he had his first...
2005-07-05
1,600 reads
2005-07-05
1,294 reads
2005-07-04
4,279 reads
DTS is an incredible package for moving data in the SQL Server world. One feature that is missing, however, is the ability to send files using FTP to a remote server. This article looks at a technique for sending files via FTP.
2005-07-01 (first published: 2001-11-01)
38,089 reads
2005-07-01
1,755 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