On the Fifth Day…
Today we will have a quick change of pace. This will be less about maintenance and more about internals. Today’s topic is one of particular interest to me as...
2012-12-17
15 reads
Today we will have a quick change of pace. This will be less about maintenance and more about internals. Today’s topic is one of particular interest to me as...
2012-12-17
15 reads
Today we will have a quick change of pace. This will be less about maintenance and more about internals.
Today’s topic...
2012-12-17
1,088 reads
As we approach the end of 2012 – The release year for SQL Server 2012 many of you as we approach...
2012-12-17
962 reads
We have come to the fourth day in this mini-series. So far I have laid down some under-carriage maintenance for one of our favorite databases. That database being the...
2012-12-16
15 reads
We have come to the fourth day in this mini-series. So far I have laid down some under-carriage maintenance for...
2012-12-16
893 reads
Please join this Thursday Dec 20th 2012 at noon central for Business Intelligence expert/consultant James Serra talking Master Data Services....
2012-12-16
544 reads
Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus talks about Bookmark Lookup Deadlocks...
2012-12-16
845 reads
Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus
talks about Bookmark Lookup Deadlocks in...
2012-12-16
1,521 reads
Mais Oui! But of course, we must have some french hens for today! Today we have the third day of pre-Christmas. And as was mentioned we have more undercarriage...
2012-12-15
11 reads
Mais Oui!
But of course, we must have some french hens for today! Today we have the third day of pre-Christmas....
2012-12-15
883 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