The Story of the TV Stand
We all have those things that happen at work that somehow turn into something other than expected, and sometimes in...
2009-01-15
659 reads
We all have those things that happen at work that somehow turn into something other than expected, and sometimes in...
2009-01-15
659 reads
It's been about two weeks since I posted PASS Update #1, so time for another update on my activities as...
2009-01-14
757 reads
There are times that you do not want indexes to be updated and used. Brian Knight shows how you can accomplish this with a new SQL School video.
2009-01-13
3,292 reads
One of my goals for the year is to update my blog roll some and try to recognize new/interesting bloggers....
2009-01-13
659 reads
I'm a technology guy, but one lesson I've learned is that not all solutions can be solved by throwing technology...
2009-01-12
726 reads
I decided to attend to see how the group was doing and learn a little more about Dot Net Nuke...
2009-01-11
638 reads
I ran across the AlphaSmart Neo in The Writer magazine. It's a $219 "laptop" that is for writing only, basically...
2009-01-08
679 reads
I've been meaning to do this for a year, finally caught up with Eric Johnson of Consortio Services to do...
2009-01-08
727 reads
Yesterday I started discussing networking and the idea that it's time invested with no guarantee of a return on that...
2009-01-07
758 reads
This post, and the next couple in the series (which may not be this week) are me talking through what...
2009-01-06
669 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