Monday Morning SQL Break – July 18, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-07-18
822 reads
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-07-18
822 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-07-18
142 reads
I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Louisville on...
2016-07-18
416 reads
The Common Table Expression (CTE) is a great tool in T-SQL. The CTE provides a mechanism to define a query that...
2016-07-21 (first published: 2016-07-18)
3,618 reads
Really late linking to it, Should I Stay or Go is about being more assertive about making the decision to...
2016-07-18
365 reads
If you’re in Louisiana or Texas this is one SQL Saturday you won’t want to miss. This annual event is...
2016-07-18
315 reads
Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options...
2016-07-18
450 reads
Hi friends, in this blog I will discuss another limitation of In Memory OLTP in SQL Server 2016. Once you...
2016-07-17
487 reads
Last week Karla Landrum announced that she will be leaving her position as Community Evangelist later this year after five...
2016-07-22 (first published: 2016-07-17)
1,661 reads
Free SQL Server, SharePoint and .NET training
SQLSaturday is a global event to bring Information Technology speakers and professionals together for...
2016-07-16
458 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...
Telp/Wa 628217555651 Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Telp/Wa 62817825533 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
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