Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues
I encountered an interesting question over on the MSDN forums concerning a poster that was reporting experiencing an issue whereby...
2014-02-19
3,524 reads
T-SQL Tuesday #051: Bets and Results
The line for this months TSQL Tuesday required wagers be made concerning the risks and bets that have either been made or not made. At close, we saw 17...
2014-02-19
16 reads
T-SQL Tuesday #051: Bets and Results
The line for this months TSQL Tuesday required wagers be made concerning the risks and bets that have either been...
2014-02-19
1,801 reads
The Challenge of Customer Service
Friday night I took my wife out for Valentine’s Dinner. We had a reservation for 9 pm and I hoped...
2014-02-18
648 reads
PASS SQLSaturday Events: March 2014
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2014-02-18
613 reads
Data Scientist versus Data Engineer #datascience #bigdata #analytics
One of the main differences between a data scientist and a data engineer has to do with ETL versus DAD:
ETL...
2014-02-18
1,173 reads
SSPI Handshake Failed
A fellow community member sent me an email saying he was having trouble authenticating with Kerberos. Here is the error...
2014-02-26 (first published: 2014-02-18)
4,176 reads
Walmart Store Openings through Power Map
A couple weeks back, I was taking a look at a map that had been put together on Flowing Data...
2014-02-21 (first published: 2014-02-18)
2,396 reads
PolyBase explained
PolyBase is a new technology that integrates Microsoft’s MPP product, SQL Server Parallel Data Warehouse (PDW), with Hadoop. It is designed to...
2014-02-25 (first published: 2014-02-18)
18,213 reads
Hilux – @BBC #TopGear
May drives a modified Hilux to the rim of that unspellable Icelandic volcano that subsequently shut down Europe’s airspace
via Search...
2014-02-18
357 reads
Blogs
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...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
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
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
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