Friday Followup For February 7, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-02-07
449 reads
Parent-Child SSIS Architecture
This is the first in a series of technical posts on using parent-child architectures in SQL Server Integration Services. The...
2014-02-07
2,225 reads
What Drives Microsoft’s Data Platform Vision?
FEATURED POST BY: Quentin Clark, Corporate Vice President, The Data Platform Group, Microsoft Corporation
If you follow Microsoft’s data platform work,...
2014-02-07
1,532 reads
MDX+SSAS #37–Ignore unrelated dimension or not
In Adventure Works cube 2008 or 2012, in the Dimension Usage tab, you will see that many intercepts of measure...
2014-02-07
2,556 reads
SQL Server Diagnostic Information Queries for February 2014
I improved the file-level latency query this month and made some other small improvements to a few other queries. Rather...
2014-02-06
1,191 reads
Murder in Richmond
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2014-02-06
7 reads
Murder in Richmond
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2014-02-06
831 reads
Rollback DBCC CHECKDB REPAIR !
I learned something new today while I was listening to one of the courses on corruption authored by the master,...
2014-02-06
1,596 reads
Virtual Lab – Design and Setup
This is part of a series where I set up a virtual lab for testing and misc work. The other...
2014-02-06
1,298 reads
24 Hours of PASS: Business Analytics Edition videos online
On February 5, 2014 business intelligence experts took to the virtual stage for the 24 Hours of PASS: Business Analytics Edition to...
2014-02-06
746 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