Auto compression all indexs on all online db
Auto compression of index, if index includes > 1 million rows.
2012-04-11 (first published: 2012-03-19)
967 reads
Auto compression of index, if index includes > 1 million rows.
2012-04-11 (first published: 2012-03-19)
967 reads
Generates a script to remove logins from a SQL Instance. Handles cases where logins own schemas.
2012-04-05 (first published: 2012-03-26)
1,392 reads
2012-03-30 (first published: 2008-04-21)
3,252 reads
Script find all foreign key without index in database and create new one for them.
2012-03-29 (first published: 2008-01-25)
3,432 reads
Query Servers using 1 sql statement. Will make your job easy!!!
2012-03-28 (first published: 2008-01-16)
3,398 reads
Reindex all tables, showing statistics before and after reindexing, table name optional.
2012-03-27 (first published: 2008-01-30)
3,140 reads
2012-03-26 (first published: 2008-01-23)
3,292 reads
You Can Find Some Date Functions and extracting the different Date Formats using the Convert and Cast
2012-03-23 (first published: 2007-10-26)
3,713 reads
Split Function for T-SQL Server to break the Job History Message into Table.
2012-03-22 (first published: 2012-03-05)
1,123 reads
A small retake on the popular percent complete script which tell how much more time an executing command will take.
2012-03-21 (first published: 2012-03-07)
1,658 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