2010-12-27 (first published: 2010-12-10)
1,201 reads
2010-12-27 (first published: 2010-12-10)
1,201 reads
2010-12-23
3,494 reads
I have added 2 functions here, one for email validation and another to split the string by specified separator by user.
2010-12-23 (first published: 2010-12-11)
1,724 reads
A Stored Procedure for your tools database. It lists uncompressed tables and indexes and also generates the SQL to compress them.
2010-12-22 (first published: 2009-08-27)
986 reads
Report unusual conditions that may be filling up your transaction log.
2010-12-22
585 reads
A generic character padding function. Useful for situations where you need fixed width formatting e.g. email reports.
2010-12-20 (first published: 2010-03-31)
2,357 reads
Script to get a list of publications an article is in
2010-12-17 (first published: 2010-12-08)
3,812 reads
This script reveals the state of your indexes. It breaks down the indexes where they are partitioned, matching the index to it’s partition and filegroup.
2010-12-16 (first published: 2010-04-22)
7,620 reads
This function evaluates the statement like '4+5*6-3' and returns the numeric value.It is just like Eval funcction in javascript.
2010-12-15 (first published: 2010-12-08)
1,088 reads
2010-12-14 (first published: 2010-11-30)
3,879 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