Finally, it has happened…
Last month I blogged about my absence from the blogosphere. If you want, you can read about it again – here....
2012-10-04
949 reads
Last month I blogged about my absence from the blogosphere. If you want, you can read about it again – here....
2012-10-04
949 reads
Hello one, hello all. It has been quite a while since I have blogged. I am looking forward to starting...
2012-10-04
1,182 reads
Idera will be re-broadcasting that I recorded earlier in the year on meeting audits with SQL Server. It's scheduled for...
2012-10-04
1,063 reads
Today a great client asked me how to export a VM to an OVF or OVA so he could transport...
2012-10-04
1,695 reads
Hi there ho there everybody! It’s less than five (FIVE!) three (THREE!)one (ONE!!) week until the 2012 PASS Summit in Seattle,...
2012-10-03
1,225 reads
The Scenario:
You just restored a production database on a development server. You’ve told the developers that it’s restored, and you...
2012-10-03
2,743 reads
It's time once again to vote for the 3 candidates we feel will best represent the SQL Server community with...
2012-10-03
1,208 reads
What would you say if I offered you the best indexing book on the market for SQL Server 2012?
Wow, right?...
2012-10-03
715 reads
One thing to add for the 5-week countdown… are you an alumni to the PASS Summit? If so, why don’t...
2012-10-03
515 reads
Do your database users appear to be having an out of body experience? Have they lost all ties to their login? Does it feel like maybe what this baby...
2012-10-03
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