New T-SQL Fixed Width "Splitter"
A brand new tally table based, fixed width "splitter" that can be used for much more than just string splitting
2016-06-22 (first published: 2016-05-14)
2,016 reads
Scripts
Script to Find String in Database object
Script that searches every object in a database for a specific string.
2016-06-20 (first published: 2016-05-02)
1,101 reads
Query to find tables with Forwarded Records
Use below query to find tables that need to be optimized based on number of forwarded records.
2016-06-16 (first published: 2016-05-05)
610 reads
2016-06-14 (first published: 2016-05-02)
1,901 reads
Data Sample Scripter
Generates code for INSERTs as well as generating data form tables for INSERT. Will also find and script all dependencies recursively, present all scripts in dependency order, and generate a reverse-dependency order set of conditional DELETE statements.
2016-06-13 (first published: 2015-06-04)
2,177 reads
PatExclude8K
Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)
2016-06-10 (first published: 2014-10-27)
4,764 reads
Log and report on table growth for trending
Log and report on table growth for trending, so you can track exactly which table(s) are your hotspots for growth.
2016-06-09 (first published: 2016-05-05)
1,817 reads
2016-06-08 (first published: 2016-04-28)
923 reads
Table Comparison Procedure
Procedure to compare two tables , getting table names and rows to display
2016-06-07 (first published: 2016-05-06)
1,079 reads
Replication-Quick way to determine the articles
Replication related script- quick way to determine the publication name, Article and column which are part of the different publications.
2016-06-06 (first published: 2016-05-09)
919 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers