T-SQL Tuesday #21 – Bringing Ugly Back
T-SQL Tuesday #21 – Bringing Ugly Back
T-SQL Tuesday #21 - I'm Bringing Ugly Back
This blog entry is participating in T-SQL Tuesday #21,...
2011-08-10
1,101 reads
T-SQL Tuesday #21 – Bringing Ugly Back
T-SQL Tuesday #21 - I'm Bringing Ugly Back
This blog entry is participating in T-SQL Tuesday #21,...
2011-08-10
1,101 reads
The Best Part of My New Job
Come to the Dark Side, We have Nutter Butters
If you had told me a...
2011-08-04
919 reads
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft - Readying on "Hadoop"
Subject:Microsoft – Readying on “Hadoop”Start Time:Thursday, July 21, 2011...
2011-07-11
1,148 reads
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft – Readying on “Hadoop”
Subject:Microsoft – Readying on “Hadoop”Start Time:Thursday, July 21, 2011...
2011-07-11
1,102 reads
Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac
Chinese Zodiac Figures by Joe Ledbetter
It’s time for July’s Meme Monday post, and...
2011-07-11
2,517 reads
Misleading Error 1475 While Setting Up Database Mirroring
Wrong Way -->
I was doing some practice work yesterday testing out some mirroring...
2011-07-11
1,170 reads
June Meeting - Data Architecture VC
Data Architecture VC presents Karen López:
Subject:You've Just Inherited a Data Model: Now What?Start Time:Thursday, June 16,...
2011-06-10
707 reads
New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO
A colleague I work with on the PQO* Operations SQL V-Team, Jonathan...
2011-05-25
1,532 reads
Getting Fast Counts of Large Service Broker Queues
This question regarding getting a fast count from a service broker queue came...
2011-01-21
1,071 reads
Multi-subnet Failover Clusters
I want to take a closer look at one of the new features in SQL Server Denali. While...
2011-01-19
2,819 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