T-SQL Tuesday #51: Is this a bet worth making?
On the second Tuesday of each month, the SQL Server universe all comes together to blog about a topic. Known...
2014-02-14 (first published: 2014-02-11)
1,818 reads
Scalar functions can be the hidden boogie man
Ran across a comment the other day that scalar functions prohibit parallelism for a query when included. I thought it...
2014-02-11
863 reads
175 Analytic and Data Science Web Sites #bigdata #freedata #analytics #datascience
Following is a list (in alphabetical order) of top domains related to analytics, data science or big data, based on...
2014-02-11
466 reads
Review: Tell Me How I’m Doing
I found Tell Me How I’m Doing by Richard L. Williams at the local library. It’s a book about giving...
2014-02-11
613 reads
Who are your victims?
Or….deadlock notifications.
In my previous post I talked about having your own database(s) and what information you could be collecting. One...
2014-02-11
602 reads
HDFS Explorer – Manage HDFS Storage from Windows
f you’re planning to use HDFS Explorer with the Hortonworks Sandbox or Cloudera VM, you’ll need to define your Hadoop...
2014-02-11
1,511 reads
Why is Your SQL Server Slow? Here’s a Hint
I was talking recently with my friends and former colleagues at Idera about the things that slow down SQL Server....
2014-02-11
1,093 reads
T-SQL Tuesday #51 – Place Your Bets
It’s T-SQL Tuesday time again and Jason Brimhall is hosting this month’s event. He used to live in Las Vegas,...
2014-02-11
792 reads
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
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