SQL Server database basics
So today I'll talk about some of the basic items for SQL server that helps to understand the reason of some performance recommendations. This first post will list and...
2017-09-16
25 reads
Blog Posts
SQL Server database basics
So today I'll talk about some of the basic items for SQL server that helps to understand the reason of...
2017-09-16
161 reads
Error Processing Tabular – Method Not Found
Very quick blog post today. While setting-up a development server at a client who is still using SQL Server 2012,...
2017-09-15
391 reads
Friday Reading 2017-09-15
Excited for next week as I’m heading down to Cork to speak at the User Group there. Over 3 years...
2017-09-15
379 reads
I want a new gadget with less features
Years ago I bought a Pebble smartwatch. I didn’t back the Kickstarter, but a few friends did and I liked...
2017-09-15
916 reads
Offtopic: Lifehack: Old tech has many purposes
For those that don’t know, I live in Texas. Been here all my life. There are two main things north...
2017-09-15 (first published: 2017-09-11)
1,631 reads
PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed
PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual...
2017-09-15
373 reads
PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed
PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual...
2017-09-15
170 reads
The Code Coverage Report
I had someone that told me recently that they needed to find a way to get code coverage in T-SQL....
2017-09-15
871 reads
What is networking, really?
I am still trying to get up to speed on blogging after a gap. Today I managed to push myself...
2017-09-15 (first published: 2017-09-10)
1,590 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