Session Eval Results for my PASS 2007 Presentation
One of the things I discuss in my Successful Technical Speaking class (it's a
free class, usually once a quarter)...
2007-11-12
622 reads
One of the things I discuss in my Successful Technical Speaking class (it's a
free class, usually once a quarter)...
2007-11-12
622 reads
I'm just finishing up sending out thank you emails to the volunteers, speakers, and sponsors that helped make our first...
2007-11-12
621 reads
We (End to End Training) will be hosting our Celko on SQL seminar tomorrow (Nov 9th). It's not too late...
2007-11-07
698 reads
I happened to get an email asking me to vote for a product that was being featured in one of...
2007-11-07
671 reads
Replication usually involves data, but it can also include stored procedures as well. SQL Server expert trainer Andy Warren brings us a look at how you can ensure that your stored procedures move as well.
2007-11-05
7,794 reads
Most people 'set it and forget it' when it comes to replication, not realizing that changes to rows on the...
2007-11-05
435 reads
I was just reading the October 2007 issue and they have done what magazines are apt to do; redesign themselves...
2007-11-05
614 reads
Steve is the guy who wrote Code Complete (get rev 2 if you buy) which I consider to be required...
2007-11-05
492 reads
Another note from a friend. They decided to upgrade a large varchar column to varchar(max) and subsequently found strange behavior...
2007-11-05
854 reads
This is an older article that was recycled for Fri, but still seems to get a decent number of views...
2007-11-04
469 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
I wrote about this several years ago but will contribute again a life hack...
Hi I have this query that is slow during the 'not in' part of...
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