Looking for Incremental Improvements
If you've read my blog much you'll know that I'm deeply involved in trying to figure out how to build...
2008-05-01
553 reads
If you've read my blog much you'll know that I'm deeply involved in trying to figure out how to build...
2008-05-01
553 reads
I grabbed Pro SQL Server 2005 High Availability by Allan Hirt recently to add to the library and I've been...
2008-04-30
1,376 reads
Raffle tickets have become a mainstay of our events, making it easy to handle the large volume of items donated...
2008-04-29
1,624 reads
Two weeks ago I did five posts on mentoring, and based on that I received a couple interesting notes, here...
2008-04-28
1,388 reads
Just checked the registrations and we're at 354, with plenty of room for more! Brian has been busy tweaking the...
2008-04-28
1,371 reads
My friend Ken Tucker invited me to speak on June 11, I'll be doing a short presentation on SQL performance...
2008-04-28
1,573 reads
I attended this on Friday along with fellow oPASS members Mike Antonovich and Ulysses Vasquez to represent PASS, and we...
2008-04-27
1,525 reads
The April 15, 2008 edition of SDTimes (PDF download here) has some information about SSDS, the SQL Server in the...
2008-04-27
1,514 reads
Steve Jones recently posted an editorial about LINQ and the resulting discussion encapsulates most of the points of view on...
2008-04-24
1,790 reads
Ran across this in the Mar/Apr ACM Queue, http://www.eecs.berkeley.edu/IPRO/JimGrayTribute/ will be held at UC Berkeley on May 31st, 2008. Jim Gray...
2008-04-24
1,368 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