Why I just became a Microsoft Employee
I have been an independent consultant (IC) for quite a while now. In an amazing number of coincidences, or just plain...
2014-02-11
1,512 reads
Impala Performance Update: Now Reaching DBMS-Class Speed #cloudera #bigdata
Since the initial beta release of Cloudera Impala more than one year ago (October 2012), we’ve been committed to regularly...
2014-02-11
501 reads
#TSQL2sDay – Data marts across a shaky WAN link
It sounded good in principle, especially given the requirements and the limitations:
We needed our various sites to be able to...
2014-02-11
712 reads
How Big Data Will Transform Coaching in the NBA #miamiheat #bigdata #nba
There’s a staggering amount of information an NBA coach would have to hold in his head to do his job...
2014-02-13 (first published: 2014-02-11)
1,666 reads
Calculating the length of a hash in SQL Server
Some time ago I added a script component to a few SSIS packages to compare rows with each other using...
2014-02-11
2,617 reads
T-SQL Tuesday #51: Doubledown disaster
Jason Brimhall is hosting the 51st T-SQL Tuesday this month with “Place your bets!.
It’s always a gamble when buying a...
2014-02-14 (first published: 2014-02-11)
1,586 reads
DELETE operations on tables
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-02-11
917 reads
[SQL Snacks Video] The What, Why, and How of Instant File Initialization with SQL Server
Instant File Initialization (IFI) is an interesting topic with regards to how SQL Server works with storage. It is an...
2014-02-11
654 reads
Correlation Does Not Imply Causation
One of the biggest mistakes we can make when troubleshooting is to confuse the necessary responsibility of observing activity that...
2014-02-11
1,513 reads
T-SQL Tuesday#51 - Place Your Bets - In-Place Upgrade.
I’m not much of a
betting man, but if I had to bet that I would participate in this month’s T-SQL
Tuesday...
2014-02-11
2,020 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