Changing to simple recovery to clear the log.
Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries...
2016-02-10
589 reads
Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries...
2016-02-10
589 reads
Earlier today I had the pleasure of speaking with the PASS Business Intelligence Virtual Chapter on getting started with Power...
2016-02-09
927 reads
What an amazing week! VMware has announced the full list of VMware vExperts for the first half of the 2016 cycle, and I’m...
2016-02-09
469 reads
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-09
162 reads
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-17 (first published: 2016-02-09)
1,939 reads
Update: For the KPI version of this report, please check Power BI KPI Report: Hospital Charge Data
How much hospitals charge...
2016-02-16 (first published: 2016-02-09)
2,224 reads
Just a short post for a Tuesday to let you that I will delivering Learning Tree’s 534 Developing SQL Queries...
2016-02-09
483 reads
Until now we have seen the windows memory addressing concepts.
http://sqlandmorewithkruti.blogspot.in/2016/01/memory-fundamentals-for-sql-server.htmlhttp://sqlandmorewithkruti.blogspot.in/2016/02/memory-fundamentals-for-sql-server-awe.html
So how exactly are user applications like SQL server assigned to...
2016-02-09
2,684 reads
Hi friends, in this blog we will discussed another limitation of In-Memory OLTP that seed and increment value other than...
2016-02-09
535 reads
Wow, Power BI is making a tidal wave in the BI industry. New features are being released regularly and blog posts...
2016-02-08
961 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