Give Your Valentine Some Discounted Indexing
Looking for that special gift for Valentine’s day and wanting to really change things up? How about getting your loved...
2013-02-13
571 reads
SQL Server Naming Standards
Want to start a fight between a bunch of DBAs or database developers? Ask them where the comma should be...
2013-02-18 (first published: 2013-02-13)
3,566 reads
A Month of PowerShell – Day 13 (Databases: Adding Schemas, Tables and Indexes)
Welcome to Day 13 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-20 (first published: 2013-02-13)
2,969 reads
Become an expert in SQL Server Performance Tuning & Troubleshooting!
Since September 2012 I’m a Microsoft Certified Master SQL Server 2008, which is the highest technical certification for SQL Server...
2013-02-13
824 reads
Become an expert in SQL Server Performance Tuning & Troubleshooting!
Since September 2012 I'm a Microsoft Certified Master SQL Server 2008,
which is the highest technical certification for SQL Server that...
2013-02-13
1,054 reads
Introduction to Microsoft’s Master Data Services (MDS) Presentation Slides
Thanks to everyone who attended my presentation “Introduction to Microsoft’s Master Data Services (MDS)” at the Houston Area SQL Server User Group...
2013-02-13
1,908 reads
Speaking at PASS Virtualization Virtual Chapter on Wednesday
This Wednesday I will be presenting for the PASS Virtualization Virtual Chapter at 11AM CST on one of my favorite...
2013-02-13
678 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 7: Clustering
by Steve Bolton
In last week’s installment of this amateur series of self-tutorials on SQL Server Data Mining (SSDM), we...
2013-02-19 (first published: 2013-02-12)
3,330 reads
T-SQL Tuesday #39 - Use PowerShell To Copy A Database To Another Instance
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-02-12
2,072 reads
#CISPA’s Coming Back: Time to Pay Attention Again
Update: The President’s cybersecurity Executive Order was signed and released today (see the Wired article). “Although the order comes after...
2013-02-12
867 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