What’s the Age Limit for Becoming a DBA?
I received an email from a nice chap recently, concerning a subject that I’m often asked about and I wanted...
2013-10-01
1,189 reads
I received an email from a nice chap recently, concerning a subject that I’m often asked about and I wanted...
2013-10-01
1,189 reads
I received an email from a nice chap recently, concerning a subject that I’m often asked about and I wanted to share my thoughts with you here. Since I only...
2013-10-01
44 reads
It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week!
Some of you may have noticed that I’ve...
2013-08-09
1,248 reads
It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week! Some of you may have noticed that I’ve been a tad quieter in the SQL community...
2013-08-09
20 reads
When there’s something worth celebrating, such as a birthday or achieving the Microsoft Certified Master (MCM) SQL Server certification, I like...
2013-08-08 (first published: 2013-08-06)
1,468 reads
Test your SQL Server knowledge in a fun and unique way with this exclusive crossword.
2013-08-06
22 reads
Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major...
2013-07-01 (first published: 2013-06-25)
2,884 reads
Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major problem.
In this post I share with you what I...
2013-06-25
24 reads
For me, one of the most rewarding things about blogging are the conversations we have together.
The opportunity to connect, share...
2013-05-21
765 reads
For me, one of the most rewarding things about blogging are the conversations we have together. The opportunity to connect, share and grow with passionate people from all over...
2013-05-21
13 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