SQL Server Cumulative Update
Microsoft today announced the latest round of SQL Server Cumulative Updates
SQL Server 2012 CU 5 – You can get more information...
2012-12-28
840 reads
Closing the Results Window in SSMS
This is a guest post by David Postlethwaite.
I’ve been wondering how to do this for years. At SQL Bits and...
2012-12-28
1,059 reads
It’s Another 24 Hours of PASS
With the upcoming PASS Business Analytics Conference, it only makes sense for there to be a 24 Hours of PASS...
2012-12-27
1,144 reads
I Pulled a Forest Gump
Last Friday I went for a quick run before we packed up and headed to Steamboat Springs for a week’s...
2012-12-27
1,792 reads
PASS Summit 2012 session videos online
If you are interested in viewing the recorded sessions for the PASS Summit 2012, you can order them on a USB flash...
2012-12-27
1,995 reads
Predictions for 2013
I’m on holiday, but I have a set of predictions for 2013 coming on Jan 1. This is a little...
2012-12-27
985 reads
Big Data: An Introduction with Hive
Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible file systems. Hive provides...
2012-12-27
47 reads
Big Data: An Introduction with Hive
Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large...
2012-12-26
420 reads
NULL Values Impact the Performance of MAX() and MIN()
We know that we need to take special attention about NULL values while writing queries because they may lead us into...
2012-12-26
2,352 reads
Querying the Procedural Cache: Just in Time for the New Years’
I sincerely wish that everyone enjoyed their recent holidays and recent downtime with family, and pass on my hope for...
2012-12-26
1,517 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...
BCA KCP Banjaran Adiwerna Hub/Wa. 0817-819-444
Jl. Raya Utara Adiwerna No.304, 306, Pejagan, Adiwerna, Kec. Adiwerna, Kabupaten Tegal, Jawa Tengah...
BCA KCP Ketanggungan Timur Hub/Wa. 0817-819-444
Jl. P. Diponegoro No.141, Dukuhtengah, Dukuh Tengah, Kec. Ketanggungan, Kabupaten Brebes, Jawa Tengah 52663
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