Find a text string in any column in a database
Find a string in any "string" (char, varchar, nchar etc) column in the database.
2012-05-22 (first published: 2007-12-19)
5,283 reads
Scripts
2012-05-22 (first published: 2012-05-01)
806 reads
Payment due date function
Calculates the nth due date for any given date, while accounting for weekends.
2012-05-16 (first published: 2007-10-11)
3,715 reads
Effectively mapping primary key – foreign key relations
This script maps the primary key - foreign key relations regardless if the column names are the same or not.
2012-05-15 (first published: 2007-11-07)
2,931 reads
sa_help_rev.erse.sa.login
A script to generate a recovery script for setting your sa account back to the password it is using at the time of running this script.
2012-05-14 (first published: 2012-04-09)
980 reads
sp_Find2
Searches database for up to 4 keywords. It will search through SPs, UDFs, Triggers, SSIS packages, jobs, table names, and column names.
2012-05-10 (first published: 2012-04-18)
2,164 reads
2012-05-09 (first published: 2012-04-19)
1,325 reads
Identify Bad Characters in a Table Column
An interesting recursive CTE to list out the non-alphanumeric characters in a column of a table.
2012-05-08 (first published: 2012-04-12)
2,968 reads
Next grow for all databases per disk
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.
2012-05-08 (first published: 2011-09-13)
1,005 reads
2012-04-30 (first published: 2012-04-04)
668 reads
Blogs
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
Forums
(Alone) #call #girl In 0562088713 downtown Dubai
(Alone) #call #girl In 0562088713 Downtown Dubai (Alone) #call #girl In 0562088713 Downtown Dubai
(Alone) #call #girl In 0562088713 Downtown Dubai
(Alone) #call #girl In 0562088713 Downtown Dubai (Alone) #call #girl In 0562088713 Downtown Dubai
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers