SSMS Keyboard Shortcut Fun
Andrea Allred (@RoyalSQL) just gave her SQL tips and tricks session at SQL Saturday Salt Lake City, and a great time was had by all! I learned some things...
2019-08-03
67 reads
Andrea Allred (@RoyalSQL) just gave her SQL tips and tricks session at SQL Saturday Salt Lake City, and a great time was had by all! I learned some things...
2019-08-03
67 reads
So we got to playing around with PowerShell last week – one son is making a game hack, and the other...
2018-11-19
232 reads
11:48am This will be starting shortly! We’re stuffing our faces, first. Today’s featured speaker is Lauri Bingham, Director of Technology Engineering...
2018-11-08
221 reads
Hello yet again! I’ve been writing about our time this week in Seattle, for the PASS Summit. Saturday, I wrote that we’re here...
2018-11-08
203 reads
Hello again! Sunday, I wrote that we’re here in Seattle for the PASS Summit, and that it’s my tenth year. AND that...
2018-11-05
201 reads
We are at PASS Summit 2018 in Seattle, and I will write a bit about each day I'm here, just...
2018-11-04
214 reads
I re-discovered something very cool while using RegEx in SSMS today: tagging expressions and referencing them in the same line! I’ll take...
2018-10-15
391 reads
I have a #sqlhelp question that requires some code. So hey, blog post time! TL;DR: the geometry::STGeomFromText graph provides too wide...
2018-09-26
386 reads
PowerShell provides an easy way to search for and/or delete just the files you want. Let's look at navigating in...
2018-09-24
746 reads
Here are the things you must/should probably know about PASS Summit 2018, as told by me. First Timers Read this...
2018-09-19
260 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