Drafting Email You’ll Never Send-Probably
It’s not uncommon to get frustrated about something at work and send out an email blasting whatever person or group...
2013-05-10
716 reads
It’s not uncommon to get frustrated about something at work and send out an email blasting whatever person or group...
2013-05-10
716 reads
I'm speaking at two user groups next week.
Tuesday - Midlands PASS - May 14
I'll be giving a presentation on PowerShell to help...
2013-05-10
1,047 reads
by Steve Bolton
It may set a SQLServerCentral record for the thickest alphabet soup of acronyms ever crammed into a...
2013-05-09
2,647 reads
I’m trying to improve.
That’s at just about everything too. I know I don’t know enough or have enough skills to...
2013-05-09
741 reads
Data cleansing can be done via SSIS as well as Data Quality Services (DQS) and Master Data Services (MDS). The...
2013-05-09
2,679 reads
Inventory allows anyone to quickly and easily assess any environment. For few servers, answering Inventory questions might not be so...
2013-05-09
1,212 reads
In my last post, I demonstrated how to mount a database with missing NDF files. In the end, we still have issues removing tables created over missing files, the...
2013-05-09
36 reads
In my last post, I demonstrated how to mount a database with missing NDF files. In the end, we still...
2013-05-09
1,564 reads
For those of you that don’t know DTA stands for Database Engine Tuning Adviser and is available from the Tools...
2013-05-15 (first published: 2013-05-09)
11,510 reads
One of the tools that Red Gate Software makes is SQL Source Control. It’s a plug in to SSMS that...
2013-05-08
8,489 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...
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