On the Third Day…
Mais Oui!
But of course, we must have some french hens for today! Today we have the third day of pre-Christmas....
2012-12-15
883 reads
The First Event of 2013 – SQL Saturday #183 – Albuquerque
I’ll be delivering the Modern Resume presentation at SQL Saturday #183 in Albuquerque, NM on February 9, 2013. I got...
2012-12-14
882 reads
Reblog: December 7 to December 13
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-12-14
645 reads
SQL Server Data Tools (SSDT) – December 2012 update
SQL Server Data Tools (SSDT) has a new update:
VS 2010: December version: 10.3.21208.0, November version 10.3.21101.1, September version: 10.3.20905.0, initial version:...
2012-12-14
1,590 reads
SQLOS Basics - Chennai User Group Meet - Presentation File Download
Chennai SQL Server User Group (CSSUG) meet is happening tomorrow (15-Dec-2012) in Microsoft Training Centre, Chennai.
You can download presenation and demo scripts here
http://www.sqlservercentral.com/blogs-admin/blogs/livingforsqlserver/CSSUG_SQLOS_Basics_15Dec2012/SQLOS_CSSUG_Meet_15Dec2012.zip
Tomorrow, I...
2012-12-14
2,256 reads
Big Data and Hadoop Part 1
Big Data Definition
As per wiki Big Data usually includes data sets with sizes beyond the ability of commonly-used software tools to capture, curate, manage, and process the data within...
2012-12-14
51 reads
On the Second Day…
Yesterday, I introduced the 12 Days of pre-Christmas. In that first article, I gave you a gift to help maintain your msdb undercarriage. Today I want to continue...
2012-12-14
19 reads
On the Second Day…
Yesterday, I introduced the 12 Days of pre-Christmas. In that first article, I gave you a gift to help maintain...
2012-12-14
1,202 reads
Cross-database Queries by Contained Users
Cross-database Queries by Contained Users
http://www.necromaticmedia.com/2007/11/containment/
I presented to the Pacific Northwest SQL Server User Group / PASS Chapter (PNWSQL) last night on...
2012-12-14
1,692 reads
Big Data and Hadoop Part 1
Big Data Definition
As per wiki Big Data usually includes data sets with sizes beyond the ability of commonly-used software tools...
2012-12-14
455 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