Grasshopper
During a recent class I happened to mention something about grasshopper, and a student wasn't familiar with the reference to...
2008-12-25
1,788 reads
During a recent class I happened to mention something about grasshopper, and a student wasn't familiar with the reference to...
2008-12-25
1,788 reads
I'm enjoying today with family and hope you are as well. Nothing complicated today, just some appropriate music!
Bruce Springsteen - Santa...
2008-12-24
1,473 reads
It was only a year ago that I moved from the Blackjack to the Blackberry Curve and overall I was...
2008-12-23
1,422 reads
SQL Agent is one of the handiest subsystems in SQL Server. This video shows how you can schedule a one-time job to handle something without you being there.
2008-12-23
3,916 reads
I guess I'm stuck in the past, but the Office Ribbon still hasn't grown on me. I think it makes...
2008-12-22
750 reads
There's one report that I look at every day to assess how things are going on a project we launched...
2008-12-21
630 reads
Last and not least this week, The Snowball: Warren Buffett and the Business of Life. This is an authorized biography...
2008-12-18
721 reads
My friend Jack has been blogging for almost a year now and is looking for feedback. If you're a blogger...
2008-12-18
605 reads
I'm still finishing up two books that I'll mention today. Most non-technical books I read straight through, anything technical/learning based...
2008-12-17
553 reads
Magazines today instead of books, but hopefully you'll count that as close enough to my theme of the week. I...
2008-12-17
549 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