Wildcards and Indexes
I was asked a good question the other day, one that I wasn’t sure of the answer. The question was...
2013-05-22
1,751 reads
Connecting a service between Publishing and Consuming SharePoint 2010 farm
Hello Friends,
As discussed in my previous blog the new architecture of Service Application in 2010. Let’s today discuss about connecting...
2013-05-22
717 reads
Do you check to see if an SSIS package has been modified?
Andy Leonard (blog | twitter) and I are putting together a presentation on protecting the entire ETL (Extract, Transform, Load) pipeline, specifically...
2013-05-22
2,732 reads
SSAS Event Type Calculation Dimension
Calculation dimensions in SSAS are used to store calculations that can be applied to any measure in the cube. For...
2013-05-22
1,285 reads
Blocking – Capturing and Monitoring
If a query is taking longer to run than normal, there’s a good chance it’s being blocked by something else....
2013-05-22
707 reads
SSIS 2012 Deployment Fail
(Update: Part 2 focuses on clearing out the SSISDB by creating new stored proc based on the one used by the maintenance job. If your Maintenance Job is taking...
2013-05-22
21 reads
Digby’s Top 10 reasons you need a DBA
Digby! helps to demonstrate the top 10 reasons you need a dedicated SQL Server DBA.
They can handle unexpected database growth...
2013-05-21
464 reads
There is currently a lease on the blob and no lease ID was specified in the request
I’ve been using the backup to Azure feature that shipped with SQL2012 SP1 CU2 and generally it works really well,...
2013-05-21
5,959 reads
Get synonym definitions for all databases in server
If you want to audit your enviroment to look at all your synonyms and see where they are pointing, you...
2013-05-21
831 reads
SQL Server Security Webcast Questions – Series Introduction
Earlier this month, I presented an Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s. A video...
2013-05-21
727 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