Getting ready for interview
Interview is a three stage process. Before => Interview => After
A. Before Interview -
1. Most important, ready your Resume/CV. Be confident about...
2016-03-26
180 reads
Interview is a three stage process. Before => Interview => After
A. Before Interview -
1. Most important, ready your Resume/CV. Be confident about...
2016-03-26
180 reads
I’m all like:
Because I saw this on an eval:
I’ve been trying to ramp up to take advantage of my MSDN...
2016-03-25
1,154 reads
Recently I have posted a article in SQLServerCentral on Fixing Maintenance Plan Error code 0x534
Read My Article "Here"
For more updates:
Subscribe for...
2016-03-25
161 reads
Thank you to everyone that attended my webinar with the PASS Excel BI Virtual Chapter today! I’d also like to...
2016-03-25
571 reads
Database Mirroring in SQL Server is deployed as a method to increase the availability of a SQL Server database in...
2016-04-05 (first published: 2016-03-25)
97,676 reads
I decided to revisit my framework to see if I could improve the performance and possibly increase the number of scenarios this framework could be used in. Turns out...
2016-03-24
47 reads
A frequent request I receive is to pull a list of logins/users with certain accesses, role memberships, etc.
I had a...
2016-04-07 (first published: 2016-03-24)
1,462 reads
Time flies. I didn’t notice that I hadn’t posted an update in February.
There’s been a lot going on since I...
2016-03-24
436 reads
I’ve been playing around with partitioning quite a lot recently and wanted to write a quick post about how it...
2016-04-05 (first published: 2016-03-24)
1,772 reads
The very first SQLSaturday in Belgium is over and it was a great event. I saw some interesting sessions, especially...
2016-03-24
506 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