SQL Server Data Services Announcement (Competitor to Amazon SimpleDB)
Mary Jo Foley reports that MS is signing up testers for a hosted SQL Server solution called SQL Server Data...
2008-03-06
736 reads
Mary Jo Foley reports that MS is signing up testers for a hosted SQL Server solution called SQL Server Data...
2008-03-06
736 reads
My friend Shawn Weisfeld is expecting more than 400 attendees at Orlando Code Camp this year. There will be at...
2008-03-04
351 reads
If you look at my blog roll Jeff Dunntemann is one of the ones recommend. Nothing about SQL Server there, but he...
2008-03-03
374 reads
I've read with interest some of Steve's editorials about SQL 2005 SP3 and in large part agree with him that...
2008-03-02
606 reads
I'm headed back to Orlando after a quick trip to Charlotte. Flew in yesterday and spent some time with my...
2008-02-28
1,306 reads
Longtime replication expert Andy Warren takes a look at the initial snapshots involved with replication and dives into an explanation of what's involved.
2008-02-26
2,661 reads
Snapshots Part 1 covers the basics of doing a snapshot regardless of what type of replication is being used. In...
2008-02-26
1,258 reads
Not a SQL related topic today.
I first noticed Tripit on Joels Blog and so far it solves a problem I've...
2008-02-26
1,297 reads
Free oil changes, extra week of vacation when you get married, etc, etc, all things mentioned in this article someone...
2008-02-25
1,435 reads
I posted earlier about the event being a great success with more than 200 attendees, in this post I want...
2008-02-24
1,489 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