SQLSat153 Recap
You may not know that this past Saturday ( October 20, 2012) was SQLSaturday 153 in Salt Lake City. If you...
2012-10-24
762 reads
You may not know that this past Saturday ( October 20, 2012) was SQLSaturday 153 in Salt Lake City. If you...
2012-10-24
762 reads
Michael Webster from longwhiteclouds.com reported that VMware Global Support Services told him a few days ago that the Extended Oracle...
2012-10-24
685 reads
This week I completed a six-part blog series (more like five plus one) on the path to virtualizing your business-critical...
2012-10-29 (first published: 2012-10-24)
2,373 reads
I have just recently changed employers and in doing so, I’ve changed my role from Data Architect to DBA/BI Developer. ...
2012-10-24
1,944 reads
In a previous post, we looked at how to take the the binary page values in sysindexes and convert the...
2012-10-24
1,183 reads
On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call...
2012-10-24
1,153 reads
New version of SQLTreeo SSMS Add-In was released. We fixed few bugs and include also one major change – SQL Server...
2012-10-24
976 reads
This is one of my most closely held DBA secrets.
Do you use PAL? You should.
Clint Huffman is a golden god...
2012-10-24
1,291 reads
Over the weekend I received an email supposedly from Microsoft Live wanting me to verify my account and provided a...
2012-10-26 (first published: 2012-10-24)
1,669 reads
I’ve been living with my Mac Air for a few weeks now, thought I’d share some quick thoughts:
I miss the...
2012-10-24
820 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