Top 10 Recommended Books…
So the title says it all, right? Well, only really partially. Recently an article was published listing the top 10 most recommended books for SQL Server. That’s the part...
2014-07-29
15 reads
Top 10 Recommended Books…
So the title says it all, right? Well, only really partially.
Recently an article was published listing the top 10 most...
2014-07-29
1,160 reads
Rename or Change SQL Server Standalone Named Instance
Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance. Renaming or Changing SQL Server Standalone Named Instance is almost same as...
2014-07-29
21 reads
How to Edit Read-Only Non-clustered Columnstore Data
As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well...
2014-08-06 (first published: 2014-07-29)
8,139 reads
Rename or Change SQL Server Standalone Named Instance
Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance.
Renaming or Changing SQL...
2014-08-05 (first published: 2014-07-29)
9,160 reads
Clustered Columnstore Indexes – part 36 (“Maintenance Solutions for Columnstore”)
Continuation from the previous 35 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
At the 12th Edition of SQLBits around 1 week ago I have...
2014-07-29
617 reads
The Growth Of SQLSaturday
A recent Connector showed the following stats for SQLSaturday for the fiscal year ending June 30, 2014 and mentioned 86...
2014-08-04 (first published: 2014-07-28)
7,634 reads
Building The SQLSaturday Orlando Marketing Plan-Part 26
More notes:
In hindsight it’s easy to see we should have worked on the email template first, then the flyers. Email...
2014-07-28
1,256 reads
Last Weeks Top “Reading” Links #94
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-07-28
1,025 reads
What is ANSI_NULLS and why will I be glad when it finally goes away?
Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and...
2014-08-04 (first published: 2014-07-28)
22,390 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