Terry-bites
A new technology could be a boon for database servers, dramatically increasing the amount of memory available for SQL Server.
2008-03-04
32 reads
Editorial - MP3
2008-03-03
33 reads
It's the Bits
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware.
2008-03-02
32 reads
Locking Your Disk
How important is disk encryption to you? Do you think about all those replicated or copied databases on laptops? Let us know.
2008-02-28
36 reads
Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
2008-02-26
32 reads
2008-02-25
41 reads
Not Connected
Do you know how to suggest improvements or features for SQL Server? Or report bugs? You use Connect, but it needs some work before it will really help the product.
2008-02-24
29 reads
Give and Take
This Friday Steve Jones asks about capital at work and does it affect the way you do business.
2008-02-21
29 reads
2008-02-19
37 reads
2008-02-18
37 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