TempDB memory leak?
I found a bug where I’m seeing TempDB use more memory than it should on multiple versions of SQL Server,...
2016-01-08 (first published: 2016-01-05)
3,369 reads
I found a bug where I’m seeing TempDB use more memory than it should on multiple versions of SQL Server,...
2016-01-08 (first published: 2016-01-05)
3,369 reads
If asked this question two years ago, my answer would have been a resounding “Yes.” At that time, the focus...
2016-01-05
542 reads
Logging & Recovery Notes from SQL Server Logging, Recovery, and the Transaction Log (pluralsight) Paul Randal
Going to share some key points...
2016-01-05
465 reads
It’s been a few years since I wrote a review of books I’ve read, so this isn’t going to list...
2016-01-15 (first published: 2016-01-05)
1,728 reads
I was interested/intrigued to see that we’ll have a Powershell Saturday on March 19th in Tampa. This will be the...
2016-01-05
630 reads
For all those still using Microsoft Word to take memos, prepare templates for email, preparing to do lists or even...
2016-01-05
986 reads
Logging & Recovery Notes from SQL Server Logging, Recovery, and the Transaction Log (pluralsight) Paul Randal
Going to share some key points...
2016-01-05
288 reads
Explore the little function called sys.fn_MSxe_read_event_stream and discover just a little bit more of what Extended Events may be doing behind the scenes with the live data viewer.
Related Posts:
Quick...
2016-01-05
34 reads
Enough talk of the GUI with Extended Events (see previous articles in the series if you want to revisit the...
2016-01-05
3,864 reads
The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney...
2016-01-04
340 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