SQL Pi
A mildly humorous title, spawned by a link my friend Jon sent me about calculating Pi using a batch file....
2009-02-10
795 reads
A mildly humorous title, spawned by a link my friend Jon sent me about calculating Pi using a batch file....
2009-02-10
795 reads
Last week I posted Update #3 that discussed my first board meeting, but I didn't have time to cover my goals, so I 'll do that and add some other minor items as well.
2009-02-10
968 reads
As I mentioned last week I drove to Miramar for the South Florida Code Camp, arriving in time for the...
2009-02-09
532 reads
Forwarding on a note from my local MS Developer Evangelist Joe Healy about his next series of free presentations coming...
2009-02-08
789 reads
Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to...
2009-02-08
1,276 reads
Last week I posted Update #3 that discussed my first board meeting, but I didn't have time to cover my...
2009-02-05
411 reads
I've been busy with other projects and haven't had time to focus as much as I'd like on my SQLSaturday...
2009-02-05
494 reads
If you're thinking about taking a job as a manager there are two questions that will help you quickly understand...
2009-02-04
962 reads
The fifth annual South Florida Code Camp is coming up this Saturday, Feb 7, 2009, at Devry University, 2300 SW...
2009-02-04
287 reads
If you could list all the reasons I work, the number one reason would be to support my family. My definition of support includes spending an appropriate amount of time with family, not just working to support it. I suspect most of you would agree with that as a goal.
2009-02-04
1,886 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