Thanks Space Coast SQL User Group
I want to thank the Space Coast User Group for having me over to speak on the Default Trace last...
2009-09-11
371 reads
I want to thank the Space Coast User Group for having me over to speak on the Default Trace last...
2009-09-11
371 reads
This question:
Created script to send mails using sp_send_dbmail- working like a charm.
Now searching for a way to get...
2009-09-10
950 reads
I have the privilege of presenting, Dive into the Default Trace, at the Space Coast User Group, tomorrow evening (Sept....
2009-09-09
313 reads
This is just a quick note, almost a continuation of my Access Denied, Not Possible post. I have been working...
2009-09-08
383 reads
Over the last few weeks I’ve had several instances where I’ve had to learn new things and, in my struggles,...
2009-09-05
480 reads
From 7:45 pm (Eastern DST) on Tuesday, September 1st until 8:00 pm on Wednesday, September 2 PASS provided free online...
2009-09-03
613 reads
Well, I had a pretty good week this week. I made an effort and met all my goals:
Eat smaller portions...
2009-08-31
1,330 reads
Event Record
This is the third year that Orlando has hosted a SQLSaturday. In 2007, I was an attendee; 2008, I...
2009-08-28
349 reads
What’s going on here?
When trying to open Default Trace files on Windows 7 and SQL Server 2008 I got the...
2009-08-26
1,215 reads
As part of my professional development and to help raise my professional profile, I have become more involved with my...
2009-08-25
616 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
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