T-SQL Tuesday #41 Becoming a SQL Server “Presenter” GET INVOLVED!
Hello Dear Reader! It’s been a while since I participated in a T-SQL Tuesday, and this month Bob Pusateri (@SQLBob|Blog)...
2013-04-19 (first published: 2013-04-09)
1,362 reads
Hello Dear Reader! It’s been a while since I participated in a T-SQL Tuesday, and this month Bob Pusateri (@SQLBob|Blog)...
2013-04-19 (first published: 2013-04-09)
1,362 reads
This month, Bob Pusateri (Blog | @SQLBob) is running T-SQL Tuesday on presenting. T-SQL Tuesday is a monthly blogging event where a number...
2013-04-09
573 reads
It’s time for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday is one of the...
2013-04-09
1,160 reads
Well sort of…it took a while.
I’d done some plays and singing at school but my mother made me practice...
2013-04-09
871 reads
It’s time for our monthly blogging party, commonly known as T-SQL Tuesday. This month, Bob Pusateri is providing the motivation...
2013-04-09
601 reads
Sometimes the answer is to keep going.
Forget words, figuring things out, and circumstances. Just keep moving your feet.
~Chuck
"Nothing in the...
2013-04-09
627 reads
As I was
exploring the twitter verse, I came across a post with the invitation to this
week’s TSQL
Tuesday #41, and immediately...
2013-04-09
2,323 reads
You can export data from SQL Server using BCP command for SQLCMD utility. However, these utilities does not support dynamic...
2013-04-17 (first published: 2013-04-09)
3,612 reads
Introduction
Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011....
2013-04-09
1,159 reads
Before we dive in to the post, I’d like to give a big thank you to Bob Pusateri (Blog|Twitter) for...
2013-04-09
795 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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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