SQL Server Error Log Reader
Reading the SQL Server Error Log is miserable. It contains very useful information you should address as soon as possible,...
2015-11-16
745 reads
Reading the SQL Server Error Log is miserable. It contains very useful information you should address as soon as possible,...
2015-11-16
745 reads
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
230 reads
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
224 reads
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
330 reads
There many reasons for creating copies of existing relational database tables. Sometimes you create duplicate tables for the purposes of...
2015-11-14
3,598 reads
I’m taking a short break from technical talk today to spend a few minutes thinking about life. My wife started...
2015-11-13
556 reads
Page splits can slow down your queries and increase the amount of I/O needed to retrieve your data.
So, how do...
2015-11-13
2,203 reads
Read My Article "Here"
For more updates:
Subscribe for Blog posts [Click Here]
Follow FB Page [Click Here]
Follow FB Group [Click Here]
For Suggestion & Feedback mail us at gana20m@gmail.com
2015-11-13
106 reads
This question has two crinkle answers –· When the table is already created.
· When the table is to be created run...
2015-11-13
159 reads
I wrote recently on Git Push in SQL Source Control (SOC), and now wanted to add the other side of...
2015-11-12
1,342 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