Early Christmas
At least for me 🙂
My wife and I put an offer in on a house this past Monday and spent...
2005-12-16
1,408 reads
Missing some folks
In a community the size of SQL Server Central, it's natural for people
to come and go, especially with contributions to...
2005-12-15
1,346 reads
Anyone want to handle this?
I get a lot of email at SQLServerCentral.com on a variety of topics. Complaints about my writing, comments on the...
2005-12-14
1,470 reads
Simple script to show what drives all databases are on
Had a need for this the other day. We just needed a quick dump of which
drives each database was using....
2005-12-09
1,385 reads
Denver Launch
I wrote a little in the editorial, but I wanted to drop some other observations here.
First, apologies for not blogging...
2005-12-07
1,475 reads
New SQL Server 2005 Books Online available
I saw this first on Karen Watterson's blog. Microsoft has released an update to SQL Server 2005's Books Online:
Download
A quick...
2005-12-07
1,489 reads
SQL 2005 Certified
Maybe not certified, but I took the 70-441 test today and I thought it was relatively easy. The format was...
2005-12-02
1,393 reads
Updated my professional site
Slowly reworking my professional site at http://www.truthsolutions.com/
but as of right now it's more of a brochure site than anything else....
2005-11-30
1,314 reads
64-bit
I wrote an editorial on the 64-bit decision by Exchange to not release
their next version in 32 bit. Only 64....
2005-11-29
1,456 reads
Update on MSSQL::OlleDB - Name Change
SQL Server MVP Erland Sommarskog has announced
a name change to MSSQL::OlleDB. It's now known as Win32::SQLServer.
This is to bring it...
2005-11-27
1,358 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