Estimate Table Size based on the Metadata from INFORMATION_SCHEMA.COLUMNS
A problem I face often is not knowing the size of a new table that I’m creating. I put some...
2013-04-24
721 reads
A problem I face often is not knowing the size of a new table that I’m creating. I put some...
2013-04-24
721 reads
This year is the first year that I have submitted a session to VMware’sVMworld 2013, to be held in San...
2013-04-24
613 reads
In July 2011 I took what felt like a big chance and a detour to lead a large and complex...
2013-04-24
742 reads
sys.dm_db_file_space_usage DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms174412.aspx
Returns space usage information for each file in the database.
It’s...
2013-04-24
3,027 reads
Thank you TriPASS for a great SQL Server Users Group session tonight! Thank you all for attending, and your questions...
2013-04-24
707 reads
We are down to the last few days before first SQL Saturday in Fargo. It’s been some work pulling it...
2013-04-23
507 reads
This topic provides and describes the quickest way to find when and what databases are being backed up recently.Backups are...
2013-04-23
1,074 reads
Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...
2013-04-23
363 reads
In last week’s post, I talked about the steps required to backup a Azure SQL Database. That post leaves us...
2013-04-29 (first published: 2013-04-23)
6,691 reads
I don’t know if I would consider myself an industry expert, but hey, it says it on the Internet, so...
2013-04-23
1,015 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