Miscellaneous

Technical Article

Script to find a string in SP/Function/View SQL

  • Script

I mark my SQL with a 'Todo' symbol whenever I decide something needs work, but I don't have the time to do it right away. So I wrote this usp so that I can get a quick list of stored procedures, function and views that need some extra work.It also comes in handy whenever you […]

You rated this post out of 5. Change rating

2007-07-06 (first published: )

281 reads

Technical Article

Make a time value from a given float value

  • Script

Clients asked me to show a more detailed and longer text which doesn't have to be edited. So I came up with the following solution/function.This function returns a varchar time value with a description containing how many days, hours and minutes. For example 100.25 returns :'100:15( 4 Days, 4 Hours, 15 Minutes )'.I hope somebody […]

You rated this post out of 5. Change rating

2007-07-04 (first published: )

128 reads

Technical Article

Checking the REMOTE site of a database-link

  • Script

When gathering SQL server statistics on ALL our Active SQL servers the script was failing sometime when one of our servers was not reachable for one reason or another.This script is checking if the LINKED SERVER is up and running before executing the "gathering statistics" script for this particular server.

You rated this post out of 5. Change rating

2006-12-25 (first published: )

189 reads

SQLServerCentral Article

Preventing Identity Theft Using SQL Server

  • Article

Solving business problems is an interesting problem for most application developers. Usually the issues are handled in application code, but there are some places where SQL Server can be used to help. Yaroslav Pentsarskyy brings us a creative use of SQL Server functionality to prevent identity theft.

You rated this post out of 5. Change rating

2006-09-20

6,328 reads

Technical Article

Find Nth Occurrence of Character Function V3

  • Script

In the tradition of best practice & code improvement, a third iteration of a script that finds the Nth occurrence of a Target string within another string (Original author unknown, V2 author vextant).This version returns zero if an Nth occurrence is not found (similar to V1), but also provides the ability to search the string […]

You rated this post out of 5. Change rating

2007-06-29 (first published: )

440 reads

Technical Article

Enterprise Manager Configuration Import/Export

  • Script

For those that do not have SQL 2005 Management Studio, this utility reads from or writes to the SQL Enterprise Manager configuration. It can handle a Server Group hierarchy up to 5 levels deep. Usage instructions are included in the script.Run with cscript.exe.NOTE: Server registrations using SQL (not Windows) authentication write out the password in […]

You rated this post out of 5. Change rating

2006-09-13 (first published: )

221 reads

Blogs

Unused Indexes in SQL Server: Find them, vet them, and drop them safely

By

 Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...

T-SQL Tuesday #191 Round Up

By

I hosted this month, late as it turns out, but we still had a...

Come See Me at the PASS Data Community Summit

By

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

SQL Newbie HELP: The query references an object that is not supported in distr..

By WBenning

Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...

Are topic notifications working?

By Edward Casbon

This is a topic to test whether reply notifications are working or not.

Visit the forum

Question of the Day

Slip Streaming Installs

What does a slipstream installation mean?

See possible answers