Get each table space and their rows count
Sometime we need to know how much table space are used to store the data and also wish to know...
2016-04-11
178 reads
Sometime we need to know how much table space are used to store the data and also wish to know...
2016-04-11
178 reads
DECLARE @year INT
SET @year = 2016
;WITH months AS(
SELECT 1 AS Mnth, DATENAME(MONTH, CAST(@year*100+1 AS VARCHAR) + '01') AS monthname
UNION ALL
...
2016-04-11
230 reads
Code coverage gives you an indication of how well tested a particular area is. It is not a measure of...
2016-04-11
455 reads
Code coverage gives you an indication of how well tested a particular area is. It is not a measure of...
2016-04-11
46 reads
Code coverage gives you an indication of how well tested a particular area is. It is not a measure of...
2016-04-11
55 reads
Code coverage gives you an indication of how well tested a particular area is. It is not a measure of code quality and having a statement covered by a...
2016-04-11
13 reads
In similar context to my previous blog I'm providing a list of UNIX basic commands which you may find handy...
2016-04-11
675 reads
In the previous post, I talked about how we can revamp the backup infrastructure for SQL to backup directly to Azure,...
2016-04-15 (first published: 2016-04-11)
2,212 reads
In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is SQL. Now let us start with basic of...
2016-04-10
58 reads
In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is...
2016-04-10
592 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