T-SQL Tuesday #49: Topic is … Wait for It …
Have you been waiting to hear about this month’s T-SQL Tuesday topic? Here’s the announcement, right here and right now....
2013-12-05
1,028 reads
Have you been waiting to hear about this month’s T-SQL Tuesday topic? Here’s the announcement, right here and right now....
2013-12-05
1,028 reads
The final day of this six part series, Introduction to Integrity, sponsored by Idera and their new free tool SQL...
2013-09-19
1,122 reads
We’re approaching the end of our six part series Introduction to Integrity, sponsored by Idera with our last two postings...
2013-09-17
1,153 reads
Have you been putting off running integrity checks on your databases? Are you unsire where to start or what to...
2013-09-16
1,214 reads
It’s day four of our six part series Introduction to Integrity, sponsored by Idera, and tonight’s topic is going to...
2013-09-12
1,152 reads
For day three of this six part series Introduction to Integrity, sponsored by Idera, we will take a look at...
2013-09-10
1,234 reads
Welcome back for day two of this six part series Introduction to Integrity, sponsored by Idera. In this post, I...
2013-09-05
994 reads
I want to start a short 6 post series to serve as an introduction to integrity in SQL Server. Most...
2013-09-03
959 reads
The Certified Master and Architect community was collectively notified Friday, August 30, 10 PM Pacific Time (Microsoft Time) that the...
2013-09-01
948 reads
I’m setting my course for a new adventure, my mind on a new … undertaking. My apologies if you thought this...
2013-08-14
945 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...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
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