Scaling SQL Server 2012 in Lisbon, Portugal
I had the opportunity to present a full-day preconference session on Friday, March 15, 2013 for SQLSaturday #188 in Lisbon,...
2013-03-16
737 reads
Apply CU2 for SQL2012 SP1 – Fix for Windows Installer starting repeatedly and causing CPU spikes !
CU2 for SQLServer 2012 SP1 is one key update which you should review and deploy if found necessary. I have...
2013-03-19 (first published: 2013-03-15)
2,465 reads
Mastering Reporting Services Expressions, March 26
As part of SQL Server Pro eLearning series, I’ll be presenting three 75 minute sessions on March 26th on using...
2013-03-15
800 reads
Reblog: March 8 to March 14
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-15
718 reads
Successful BI for Educational Institutions
Do you work for US Education? Are you interested in Learning about Microsoft BI? If so, please join me as...
2013-03-15
1,278 reads
Exploring Excel 2013 for BI Tip #3: Flash Fill
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-03-15
1,186 reads
Self Hosting WCF Services With Transport Security
When developing and debugging transport security WCF services it’s a real pain if each developer on the team needs to...
2013-03-15
223 reads
Renaming Server with SQL
I recently had to rename my laptop on which I have two SQL server instances. I have a default instance...
2013-03-14
1,702 reads
The STUFF function
While I was at the 2011 Pass Summit I was given the following piece of code to create a comma...
2013-03-14
911 reads
Customizing SSMS – Hiding the panels
This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned...
2013-03-14
1,164 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...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
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