SQL Server 2005 Index Maintenance
Index maintenance procedure using rebuild or reorganized based on fragementation level.
2011-10-26 (first published: 2008-03-28)
3,545 reads
Index maintenance procedure using rebuild or reorganized based on fragementation level.
2011-10-26 (first published: 2008-03-28)
3,545 reads
Many times we need to generate html query for a given SQL query for that we need to use ASP, Java. Now you can use this SP to generate HTML.
2011-10-25 (first published: 2007-10-01)
4,578 reads
This script reverse engineers SQL statements to recreate database permissions.
2011-10-24 (first published: 2011-10-07)
16,375 reads
Search for String Occurence with this script in your stored procedures.
2011-10-20 (first published: 2008-06-08)
5,448 reads
I have several problems with my corporate network and therefore need to do all my backups locally, and to make matters worse, still use SQL Server 2005.
2011-10-17 (first published: 2011-09-30)
454 reads
2011-10-14 (first published: 2011-08-24)
539 reads
Gets Detail table information such as partition information, compression, and partition range.
2011-10-13 (first published: 2011-09-30)
1,273 reads
2011-10-12 (first published: 2011-08-31)
968 reads
This script lets you to know how much disk space will be left after the next database grow taking in account the free space left in the database.
2011-10-11 (first published: 2011-09-13)
1,058 reads
2011-10-10 (first published: 2011-08-24)
848 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