Rules of Holes #2: You Are Still in a Hole
OK. So you followed the First Rule of Holes -you stopped digging yourself in deeper. But now what? You are still in a Hole. Your situation has not changed...
2012-11-14
20 reads
T-SQL Tuesday #36 – Community
Chris Yates (@YatesSQL / blog) is hosting the T-SQL Tuesday blogging party this month, and he wants to know “What does...
2012-11-13
738 reads
Instant File Initialization with TDE
If you are using Transparent Data Encryption TDE and have Instant File Initialization turned on, you are not getting the...
2012-11-13
962 reads
T-SQL Tuesday: What Does the SQL Community Mean to You?
Today is T-SQL Tuesday #36, hosted by Chris Yates (B | T). The topic this month is ‘What Does the SQL...
2012-11-13
799 reads
Rules of Holes #2: You Are Still in a Hole
OK. So you followed the First Rule of Holes -you stopped digging yourself in deeper. But now what? You are...
2012-11-13
625 reads
PASS Summit 2012 Review
Life is finally returning to normal after a great week in Seattle for PASS Summit 2012. The entire year is...
2012-11-23 (first published: 2012-11-13)
1,623 reads
PASS Summit 2012 - Done!!!
Thursday afternoon
Thursday afternoon concluded with How to run SSRS in Sharepoint integration mode, Enriching Tabular with DAX and Monitoring SSAS....
2012-11-23 (first published: 2012-11-13)
1,200 reads
SharePoint 2010 Setup Error
Sometimes in life things happen when you least expect them. This was my experience some few weeks ago when I...
2012-11-13
1,121 reads
T-SQL Tuesday #36 – SQL Community
T-SQL Tuesday #36 – SQL Community
T-SQL Tuesday #36 - SQL Community
This blog entry is participating in T-SQL Tuesday #36, hosted this month...
2012-11-13
972 reads
How to obtain the version and license for a Red Gate SQL BACKUP install
/*
here is a little script I've hobbled together that I use to get version and license info for a Red...
2012-11-13
1,163 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCU TEGAL Telp:0821°7555°651
Telp/Wa 628217555651 Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim., Kota Tegal, Jawa...
Kantor Resmi BCA KCU SALATIGA Telp:0817°825°533
Telp/Wa 62817825533 Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo, Kota Salatiga, Jawa Tengah 50711
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