An open letter to the PASS community (2017)
PASS is our community.
It may sound a little cliche, especially with the current political climate in the US and other...
2017-09-20
364 reads
Blog Posts
Columnstore Indexes – part 112 (“Linked Servers”)
Continuation from the previous 111 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is focusing on the Server...
2017-09-20 (first published: 2017-09-14)
1,726 reads
Dieser Blog ist umgezogen // This Blog has moved: http://andreas-wolter.com/blog/
http://andreas-wolter.com/blog/
Liebe Leser dieser Blog ist hiermit nur noch „Archiv“ und wird nicht mehr weiter gepflegt. Seit August 2017 finden sich neue Artikel ausschließlich unter der neuen URL:http://andreas-wolter.com/blog/
Dear Readers this...
2017-09-20
36 reads
Dieser Blog ist umgezogen // This Blog has moved: http://andreas-wolter.com/blog/
http://andreas-wolter.com/blog/
Liebe Leser
dieser Blog ist hiermit nur noch „Archiv“ und wird nicht mehr weiter gepflegt.
Seit August 2017 finden sich...
2017-09-20
354 reads
Do what I say, not what I do
I told you not to use NOLOCK even though I use it sometimes.I told you not to shrink databases, even...
2017-09-20
444 reads
Does rebuilding my clustered index also rebuild my non-clustered indexes?
I’ve been working with SQL Server for many years now, and up until recently, I assumed that rebuilding any clustered...
2017-09-20
454 reads
Help! My query is too fast!
Said no one ever. Well, maybe. I have had occasions where I needed a brief pause in the middle of...
2017-09-20 (first published: 2017-09-14)
3,258 reads
UNDERCOVER TOOLBOX: sp_Snapshot – The Easy Way To Create Database Snapshots for One or Many Database
sp_Snapshot is a procedure that we’ve written to quickly and easily create a database snapshot of one or multiple databases.
Prerequisites
sp_Snapshot...
2017-09-20
170 reads
Azure, PowerShell, Databases and the PASS Summit
I am quite honored to say that I am speaking at the single largest and most important Microsoft Data Platform...
2017-09-19
447 reads
Clustered Index Uniquifier Existence and Size
In SQL Server, each and every row in a table needs to be accessible by itself, whether or not you...
2017-09-19
2,002 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