By Steve Bolton
…………In the first installment of this wide-ranging series of amateur tutorials, I noted that the Hartley function indeed...
2017-08-31
944 reads
David has recorded and published a video of his presentation on SQL Server Graph Database. In his video which you...
2017-08-31 (first published: 2017-08-21)
2,674 reads
SARG is short for Search Argument. This is an important tuning term and something every developer and DBA should know....
2017-08-31
4,790 reads
The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be...
2017-08-31 (first published: 2017-08-18)
3,820 reads
Continuation from the previous 110 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
The topic of the Segment Elimination (aka...
2017-08-30
703 reads
Now that SSDT (SQL Server Data Tools) has been installed the next step is to create a project. First, open...
2017-08-30 (first published: 2017-08-16)
1,902 reads
I had a spreadsheet of data that contained hyperlinks. In this case, it was a series of Microsoft Knowledge Base...
2017-08-30
734 reads
Guten Tag!
OK, switching back to English for the rest of this.
I’m going to be spending a few weeks in Germany...
2017-08-30
541 reads
Hello friends, you can find the post at below link – https://social.technet.microsoft.com/wiki/contents/articles/40010.how-to-create-a-virtual-machine-in-microsoft-azure-using-powershell-part-2.aspx Tagged: Azure, Microsoft Azure, Powerhsell, Powershell, SQL Azure, Virtual...
2017-08-30
796 reads
On my last article I shared how we can now Contribute to Microsoft Documentation. Today I bring another quick tip...
2017-08-30
3,165 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
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