On vacation!
It was busy at work after returning from PASS which means my work day continued for 2 or 3 hours after I got...
2005-10-16
1,300 reads
Something About Nothing: NULL
You wouldn’t think that “nothing” would cause so many problems. But seriously, understanding how to correctly use NULLs is a...
2005-10-16
1,407 reads
Blogging Is Hard
Why is that? My Database Daily editorial for this week focuses on that and I thought it would be interesting...
2005-10-14
1,404 reads
Remote Access
We typically have great weather in Colorado where I live, but we do get
snow. And occassionally it causes issues. Like...
2005-10-12
1,533 reads
Minor Panic
I know, I need some stuff posted about PASS and I'll get to it. My wife
was injured (she's ok) while...
2005-10-09
1,429 reads
Using the sa account -- Just say "NO!"
Aunt Kathi knows many of you do things you know are wrong, like rolling through stop signs, littering, and using the sa...
2005-10-04
1,320 reads
Thoughts about the future
So far my posts have been non-technical musings about my life outside of work. I guess it is time to...
2005-10-03
1,260 reads
Back home after PASS
The past week at PASS was more informative and fun than I could ever have imagined. By getting involved in the...
2005-10-01
1,305 reads
PASS 2005: Day Four
Day Four wrapped up SQL Pass 2005. As a first time attendee to this event, my head was swimming by...
2005-10-01
1,393 reads
PASS 2005: Day Three
Day Three of PASS had a decidedly better start than did the previous day. After finally figuring out the effective...
2005-09-29
1,324 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