SQL Server Free eBooks, Softwares, Tutorials and Websites
When we start working as developer or learning, we often
face this issue. Where is the best tutorials, books and other...
2017-04-10
317 reads
When we start working as developer or learning, we often
face this issue. Where is the best tutorials, books and other...
2017-04-10
317 reads
We all know that SQLSaturday events are good for career networking, professional development, and technical education. Sometimes the perfect story...
2017-04-10
490 reads
In this post we’re going to create some encrypted columns in a table in a test database and look at some of the practicalities and limitations of working with...
2017-04-10
16 reads
Its been an interesting weekend at gethynellis.com I have been attempting to put together a SQL Server YouTubechannel. I’m planning...
2017-04-10
329 reads
So SQLBits is over and I have to say that I really enjoyed attending on the Saturday, hopefully next year...
2017-04-10
180 reads
So SQLBits is over and I have to say that I really enjoyed attending on the Saturday, hopefully next year...
2017-04-10
305 reads
Missing index :- Scripts will help you to get all the missing index and prepare script for new index.
/*
Description:- This Query...
2017-04-10
692 reads
One of my clients came up with the requirement to isolate the replication traffic from the public network. The advantage of using a separate network for replication is reduced...
2017-04-10
22 reads
One of my clients came up with the requirement to isolate the replication traffic from the public network. The advantage...
2017-04-10
903 reads
My new course “LFCE: Network and Host Security” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right...
2017-04-09
19 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Jl. Zainul Arifin No.78, Sukoharjo, Kec. Klojen, Kota Malang, Jawa Timur 65118
Jl. Thamrin No.8, Lawang, Kec. Lawang, Kabupaten Malang, Jawa Timur 65211
Has anyone ever seen this before? I have sysadmin permission on a server. 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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers