Accidental DBAs, the Developer Edition
I recently spoke at the OKC SQL Saturday. I had an wonderful time and the organizers, volunteers and other speakers...
2016-09-06
403 reads
I recently spoke at the OKC SQL Saturday. I had an wonderful time and the organizers, volunteers and other speakers...
2016-09-06
403 reads
Sql Server – Listing all
tables Metadata (Table Size, row count, Index Size)
Suppose you need to find out Table size, row
count , index...
2016-09-06
375 reads
This is Down Tools Week at Redgate Software, and I’m visiting the office. I had hoped to dive into a...
2016-09-06
461 reads
Top
Slowest Queries or Resource Extensive Queries
Whenever your database is facing any performance issue or resource scarcity,
the first step should be...
2016-09-06
263 reads
SQL Server 2016 has been officially launched for a little more then three month, many people are feeling excited to...
2016-09-06
1,112 reads
I recently configured a backup job to run on the principal server of a mirrored pair. The idea was to backup...
2016-09-08 (first published: 2016-09-05)
2,132 reads
On October 7 we will be presenting a full day of maintenance and backup learnin’! Register here: https://www.eventbrite.com/e/sql-saturday-564-the-lifecycle-approach-maintenance-problems-solutions-tickets-26867268724 And while you’re at...
2016-09-05
476 reads
In this post I will attempt to explore calculation of a very basic statistic based on linear relationship between two...
2016-09-08 (first published: 2016-09-05)
3,214 reads
SQL Server 2016 offers built-in support for JSON, in a similar way to the support offered for XML since SQL...
2016-09-04
656 reads
USE CASE: When we are working on TSQL or some text based scripting we may need some extra space in between...
2016-09-04
201 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...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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