SQL Community - The Site
A friend sent me a link to www.sqlcommunity.com and I think I'd list it. So far doesn't seem impressive, but...
2008-01-06
522 reads
A friend sent me a link to www.sqlcommunity.com and I think I'd list it. So far doesn't seem impressive, but...
2008-01-06
522 reads
Steve finally got the bugs worked out of the recent blog software upgrade and RSS should be available again. Note...
2008-01-03
465 reads
Just a reminder to anyone in the Tampa area, or willing to travel, that the call for speakers for the...
2008-01-03
244 reads
Most SQL Server DBAs have been taught that cursors are bad and should not be used. However there are some cases and places where they might be useful. SQL Server guru Andy Warren brings us an example of where they may be handy.
2008-01-03 (first published: 2007-01-15)
16,938 reads
Just saw that Bayer posted a note confirming that he is a 2008 MVP. I met Bayer a couple years...
2008-01-02
193 reads
Steve is a 2008 SQL Server MVP. Well deserved, I can think of few people more visible in the community...
2008-01-01
652 reads
Google has - and continues - to do some amazing things. It's easy to be awed by their products and their infrastructure,...
2008-01-01
470 reads
In working on an existing database, DBAs often look to normalize tables and correct obvious flaws in design. Recently Andy Warren was working on a consulting project and realized that defaults would prevent many issues.
2007-12-28 (first published: 2007-01-04)
7,206 reads
I purchased The Exceptional Presenter recently as part of my professional development spending. I currently work primarily as a trainer...
2007-12-27
1,507 reads
I don't have a URL handy for it, but in the latest print issue of PC Mag they announced changing...
2007-12-26
1,413 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