CPU-Z 1.60 Released
Pretty much right on schedule, Frank Delattre has released CPU-Z 1.60, which has support for some new and upcoming processors...
2012-03-04
841 reads
Glenn Berry
What I Want For My Birthday
Dell has teased us with some images of their upcoming 12th Generation servers (that will support the Intel Sandy Bridge-EP...
2012-02-29
1,807 reads
SQL Server 2008/2008 R2 Diagnostic Queries for March 2012
Since it is nearly March, I will go ahead and jump the gun by a few days and post an...
2012-02-28
1,858 reads
New Cumulative Updates For SQL Server 2008 R2
On Feb 22, 2012, Microsoft released SQL Server 2008 R2 SP1 Cumulative Update 5, which is Build 10.50.2806. This CU...
2012-02-24
948 reads
Behemoth of the Server Room?
Back during the PASS 2011 Summit in Seattle, I was interviewed by Tony Davis, Andrew Clark, and Rodney Landrum about...
2012-02-10
878 reads
Behemoths of the server room: An interview with Glenn Berry
At the last PASS summit, we cornered SQL Server MVP Glenn Berry, and found out his views on the impact of virtualization, solid state disks and SAN administrators on the life of a DBA, and what led him to write a book all about SQL Server Hardware.
2012-02-10
1,827 reads
Building or Buying a Desktop Based Development and Test Database Server
Back in April of 2011, I wrote a post that compared the merits of using an ancient, but actual rack...
2012-02-06
1,430 reads
AMD 2012-2013 Server Roadmap
AMD had their 2012 Financial Analyst Day today, which is basically a dog and pony show for stock analysts.
Previously,...
2012-02-03
1,187 reads
January 2012 SQL Server 2008/2008 R2 Diagnostic Information Queries
Since Microsoft recently released a couple of new Cumulative Updates for SQL Server 2008, I thought it was finally time...
2012-01-23
1,187 reads
Database Mirroring From SQL Server 2005 to SQL Server 2008 R2 SP1 CU3
I recently ran into a production instance of SQL Server 2005 SP2 (Build 3042) that is running in a two...
2012-01-12
2,680 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 BCA KCP Pejaten Hub/Wa. 0817-819-444
Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No. 98F & 98G,...
Alamat BCA KCU SUBANG Hub/Wa. 0817-819-444
Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
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