Buying A Plane
There's been a lot of bad press about 'corporate jets' in the news over the past year. Not that planes...
2009-03-31
1,481 reads
There's been a lot of bad press about 'corporate jets' in the news over the past year. Not that planes...
2009-03-31
1,481 reads
The call for speakers is still open and will close April 6th, there's still from for a few more sessions....
2009-03-31
1,342 reads
This SQL School video from MVP Andy Warren shows you how to use the OpenRowSet command to access data stored outside of SQL Server.
2009-03-31
3,198 reads
Note: I was working on this at the Summit and then it got lost in the draft folder, so unfashionably...
2009-03-30
1,484 reads
This was an interesting year to watch the local Code Camp. Shawn Weisfeld organized it the previous two years, but...
2009-03-29
1,448 reads
My friend Brian writes Databases, Infrastructure, and Security and like me, he writes about an eclectic mix that goes beyond...
2009-03-26
1,454 reads
In this new video, learn how to loop through your databases and tables. MVP Andy Warren shows how some system stored procedures included by Microsoft can push out the same code to a group of objects.
2009-03-26
4,715 reads
I've been slowly looking at and experimenting with LinkedIn to see if it has value and if so, how to unlock it in a way that works for me. I mentioned it during my series on networking and since I've evolved a strategy that I think is interesting...
2009-03-26
2,334 reads
I'm been in tactical mode lately, building an advertising management system for one of our projects. Actually it's v2, the...
2009-03-25
1,617 reads
Yesterday I was commenting on how a big part of stress for me is getting that sudden burst of work...
2009-03-24
835 reads
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...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
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