Cursors to Increase Performance?
I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In...
2007-07-06
744 reads
I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In...
2007-07-06
744 reads
I just got my author copies of the Sybex book for exam 70-444 and have to say the book looks...
2007-07-05
753 reads
My friend and former co-worker Chris Rock just posted at article over at SQLTeam.com that has a pretty good walk...
2007-06-27
1,389 reads
I'm at the bookstore today alternating some work with some professional development time and was reading some of Celko's SQL...
2007-06-20
1,434 reads
SSC had a fairly routine article up recently about The GO Command the Semi Colon Terminator which I read, and...
2007-06-18
1,392 reads
This was fun to run through, nice to see MS adding features even if in my view they didn't quite...
2007-06-12
1,340 reads
Web site just went live for this year. Brian & I both presented sessions last year and we're planning to go...
2007-06-12
1,356 reads
When I teach performance tuning I always remind students to be cautious about service packs because things you "know" may...
2007-06-04
1,778 reads
I'll be doing a spotlight session called 'Transactional Replication for Beginners' this year. I've been speaking at the Summit since...
2007-05-29
1,379 reads
I've got a new article running on SSC today with a few more book reviews: http://www.sqlservercentral.com/columnists/awarren/2998.asp.
2007-05-23
1,436 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