Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations
There are a couple process hungry operations that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data...
2012-08-27
3,914 reads
The Embarcadero – SQL in the City San Francisco
I love San Francisco. It was one of the cities that I thought I might live in someday. My kids...
2012-08-27
1,086 reads
PASS Election Season
Did you know that it’s election season for PASS? Did you know that you can pose questions to the potential...
2012-08-27
626 reads
SQL Server 2012 and SharePoint 2013: Installing on a Virtual Machine
With the preview of SharePoint 2013 now available, I have updated my post SQL Server 2012: Installing on a Virtual Machine to...
2012-08-31 (first published: 2012-08-27)
15,711 reads
Create a SQL Server Reporting Services (SSRS) Catalog Report in 15 Minutes
One big question I have gotten often is “I need data, what kind of reports do you have?” It is...
2012-08-27
486 reads
Re-Using Phone Numbers at the Office
I’ve been with my current client for just over a year and I still get calls for the previous occupant...
2012-08-27
707 reads
Five Applicants for the PASS Board
If you haven’t reviewed the list, head to the PASS Election Page. One incumbent, two appointees, one previous candidate, and...
2012-08-27
577 reads
When Can You Be Considered As A Senior DBA
As a DBA, when can you consider yourself as a senior DBA?
If you read online posts, you will find most...
2012-08-27
3,483 reads
SQL Saturday 125 OKC
This weekend I traveled three hours north to Oklahoma City to participate in SQL Saturday 125, the second annual event...
2012-08-27
402 reads
SQL Saturday 125 OKC
This weekend I traveled three hours north to Oklahoma City to participate in SQL Saturday 125, the second annual event...
2012-08-27
828 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