No XP, but Look Forward To 7
A look back at the news of the past week including Windows 7, SSD performance, April Fools, and consistency in SQL Server.
2008-04-05
191 reads
Editorial - MP3
2008-04-03
770 reads
Try To Be More Inefficient
Steve Jones is recommending that you don't work the most efficient way at your job. Sometimes.
2008-04-02
41 reads
A Scary Comparison
What changes are coming in the editions for SQL Server 2008. Steve Jones finds a rather scary piece of literature.
2008-04-01
40 reads
The Credit Debate
As databases grow, we store more and more types of data. This Friday's poll asks what types of data you don't want to store.
2008-03-27
34 reads
Social Software
More and more companies are looking to use social software, like Facebook, to link employees, but is this a good thing?
2008-03-26
32 reads
Bad Automation
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
2008-03-25
40 reads
March Madness
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
2008-03-24
30 reads
A Bad Report Card
The Federal Communications Commission doesn't get a good report on it's data handling and management processes.
2008-03-23
32 reads
2008-03-22
168 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat Telp BCA KCP Jatiwangi Hub/Wa. 0817-819-444
Jl. Jend. A. Yani No.224, Jatiwangi, Kec. Jatiwangi, Kabupaten Majalengka, Jawa Barat 45454
Alamat BCA KCP Rengasdengklok Hub/Wa. 0817-819-444
Jl. Raya R.Dengklok No.27, RT.049/RW.011, R.Dengklok Sel., Kec. R.Dengklok, Karawang, Jawa Barat 41352
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