SSC Moving
As if it weren't enough that I was moving my home, the SSC site is also moving. I'll drop some...
2006-01-18
1,435 reads
PromptSQL Review
I had the opportunity recently to take a look at PromptSQL and offer a
review on it. That review hit SSC.com's...
2006-01-18
1,443 reads
A Funny Thing Happened at Starbucks
I decided to commit to the book, so I'm waiting on some information and a contact from my co-author and...
2006-01-12
1,473 reads
Awesome Interview on Windows Vista Kernel Architecture
This actually premiered on Channel 9 right before Christmas. It is an
interview with Rob Short, a Microsoft VP in charge...
2006-01-07
1,531 reads
To Write or Not to Write
That's the decision to be made.
Apress contacted me about the update for my book. I wrote 1/2 of the Designing...
2006-01-05
1,510 reads
Guidance on .WMF patch from Mike Nash, Microsoft Corporate VP
There is a new posting from Mike Nash on the Microsoft Security Response Center blog:
http://blogs.technet.com/msrc/archive/2006/01/05/416980.aspx
Relevant quote:
So the thing that I...
2006-01-05
1,478 reads
Microsoft .WMF Security Patch Releasing Today (out-of-cycle)
Microsoft has announced they will release a security hotfix at 2 PM PST for the WMF design flaw. More details...
2006-01-05
1,431 reads
Remote DBA
I'm getting ready to look for a new cell phone and I got lots of suggestions from my editorial on...
2006-01-05
1,537 reads
Simple Script to Report Tables Sizes in a SQL2K Database
Last week we had an issue with a database growing unexpectedly. The
database in question supported an infrastructure type 3rd party
application...
2006-01-04
1,358 reads
Sample Chapter from Professional SQL Server 2005 Integration Services
Brian Knight posted a sample chapter for Professional SQL Server 2005 Integration Services
to his blog a few days ago. Last...
2006-01-04
1,487 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCU TEGAL Telp:0821°7555°651
Telp/Wa 628217555651 Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim., Kota Tegal, Jawa...
Kantor Resmi BCA KCU SALATIGA Telp:0817°825°533
Telp/Wa 62817825533 Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo, Kota Salatiga, Jawa Tengah 50711
Question of the Day
Switching Schemas I
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