Speaking at SQL Saturday #183 – Albuquerque
I’ve been accepted to speak at SQL Saturday #183 in Albuquerque, NM on Feb 9, 2013. This is the first...
2013-01-04
1,170 reads
Blog Posts
SQL Server Contracting and Business Network Wales - LinkedIn Groups Updates
I have been doing some work on some LinkedIn groups that I manage and look after over the holidays. There...
2013-01-04
873 reads
SSRS #73 – Use Calculated Field to Dynamically Set Default for Parameters
Calculated Field has existed in Reporting Services since version 2005. SSRS 2005 did not have the most attractive user interface...
2013-01-04
11,504 reads
T-SQL Tuesday #38 – Standing Firm
Introduction
Welcome back for the 38th installment in the wildly popular blog party for the SQL Server community. This is the...
2013-01-04 (first published: 2013-01-02)
1,587 reads
What happen, If SQL Server new instance try to use exitsing named instance name?
We all know that SQL Server can have 1 default instance & many named instance.
But I want to check, How SQL...
2013-01-04
1,213 reads
When is a whitespace not a whitespace ?
As I'm sure I must have mentioned in the past, I’m presently involved in a large ALM project at a...
2013-01-04
1,539 reads
A Rickety Stairway to SQL Server Data Mining, Part 0.2: How to Dig Out of a Data Mining Cave-In
This third part in my series of self-tutorials in SQL Server Data Mining (SSDM) was delayed for several weeks due...
2013-01-03
1,930 reads
Checking the Instance Fill Factor
I was reading a post from Paul Randal recently and noted that he recommends not changing the instance’s default fill...
2013-01-03
2,530 reads
Heap might take more space than clustered Index when inserting row
Sometimes when you insert row on heap, even if the page has enough free space, the new row can not...
2013-01-03
981 reads
List of Disks and Free Space
Recently I have been supporting our move from TFS from 2010 to TFS 2012. The database instances is stored on a server that I do not have log on...
2013-01-03
20 reads
Blogs
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...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
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