Get Performance Counters from within SQL Server
I think most DBAs know that you can use the Windows Performance Monitor to capture performance metrics for your SQL...
2012-12-04
928 reads
Blog Posts
How to create site directly in new content db
Hey Friends,
Sometime when we build a new SharePoint site or site collection. We may feel to create in a new...
2012-12-04
406 reads
On the Advantages of DateTime2(n) over DateTime
Starting with SQL 2008, we database developers started becoming more familiar with datetime2. Sometimes folks need convincing though, so here...
2012-12-04
12,287 reads
SQL Server Policy Based Management Alerts
SQL Server Policy Based Management Alerts
Problem
Policy-Based Management is used to enforce standards on SQL Servers and it's great. But not...
2012-12-04
4,358 reads
HDInsight, Finally
See this:
That’s right. The install worked. All I had to do was get a completely clean server set up. No...
2012-12-03
1,391 reads
Last Weeks Top 10 “Reading” Links #9
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-03
1,025 reads
Lost in Translation – Deprecated System Tables – sysprocesses
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-12-03
2,125 reads
MDX #22 – What to use for explicit sorting on dimensions
I often think that I am lucky to work in a profession that I enjoy very much. It makes everything...
2012-12-03
701 reads
MDX #23 – “Hello World!” Lesson in MDX
Almost every tool we learned has some sort of “Hello World!” tutorial lesson.
So here comes the “Hello World!” lesson in...
2012-12-03
1,092 reads
OT: Space Exploration and the Future of Humanity
I am old enough to remember watching the Apollo 11 landing in 1969 as a young child. Before and after...
2012-12-03
1,491 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