Medical Claims Analysis System
“Reddy Software Solutions provided in-depth project analysis and planning that resulted in realistic delivery dates and cost estimates. The development process was thoughtful, collaborative, responsive, and professional. They met my goal of a high-quality, useful, and reliable IT solution. I will continue to rely on their proven expertise.”
 ~Patricia A. Gelnar, Founder, Graphic Surgery, LLC.
 Call Center Database Performance Tuning
“When our call center operations began to suffer due to database issues a colleague recommended Reddy Software Solutions. The service provided went above and beyond my expectations. The gains we realized were incredible. The consultant was thorough, courteous, and very open to sharing his knowledge with my team. I highly recommend these guys.”
 ~Natalya MacMorran, Senior DBA, Realtime Results
 U.S. Currency Inspection System
“The engineer at Reddy Software Solutions that worked on my project was highly motivated and extremely knowledgeable. He worked very well with our team as well as our valued client. Reddy Software Solutions is clearly abreast of the latest technologies. I look forward to working with them again.”
 ~Reed Hannebaum, Senior Project Manager, MAVERICK Technologies
 Trustworthy Partner
“We've used Reddy Software Solutions over the years to provide a number of development services - an automated web-based reporting system, our corporate intranet, and most recently an eLearning program to help train and test employees. They've turned vision into reality for us many times over. We will being doing business with them again very soon”
 ~Mike Van Well, IT Director, Mitch Murch's Maintenance Management Co.
 Extra Horsepower
“We run a very dynamic and growing business. ReddySS steps in during busy times to help us with SQL Server and .NET development tasks, effectively eliminating the need for us to hire an additional full-time employee. They're responsive, professional, and efficient. I would recommend them to anyone requiring quick turn-around on their IT projects.”
 ~Kevin Feager, Senior Analyst/Project Manager - HAL Systems,Inc.
 
 
  |  
Help Yourself to My SQL Code

 

Search
spUtil_SearchText
Thumbnail

This stored procedure will search all fileds in all tables for the occurence of a value or part of a value.



File size 3 K
Downloads 1483
Date Tue 03/09/2010 @ 09:44
Author Reddy Software Solutions, Inc.
EMail scripts@reddyss.com
RATING:   COMMENTS (4)  DOWNLOAD

spUtil_ActiveSQL
Thumbnail

This stored procedure reports back all T-SQL currently running against the server.



File size 1 K
Downloads 69
Date Tue 03/09/2010 @ 07:05
Author Reddy Software Solutions, Inc.
EMail scripts@reddyss.com
RATING:   COMMENTS (0)  DOWNLOAD

spUtil_Occur
Thumbnail

This script searches a database for every occurence of text in all database objects.  For instance, you could search for any instance of 'InvoiceID'.  The proc would return a report indicating tables in which the field existed, procs that use the field, commented code, etc.



File size 4 K
Downloads 204
Date Tue 03/09/2010 @ 07:05
Author Reddy Software Solutions, Inc.
EMail scripts@reddyss.com
RATING:   COMMENTS (0)  DOWNLOAD

spUtil_EnableDisableJob
Thumbnail

This stored procedure can be used to enable or disable SQL Server Agent jobs by name.



File size 1 K
Downloads 30
Date Tue 03/09/2010 @ 07:05
Author Reddy Software Solutions, Inc.
EMail scripts@reddyss.com
RATING:   COMMENTS (0)  DOWNLOAD

spUtil_GetNumCPUs
Thumbnail

This stored procedure returns the # of CPU cores on the current server.



File size 1 K
Downloads 35
Date Tue 03/09/2010 @ 07:05
Author Reddy Software Solutions, Inc.
EMail scripts@reddyss.com
RATING:   COMMENTS (0)  DOWNLOAD

spUtil_ListClusteredIndexes
Thumbnail

This stored procedure lists all clustered indexes in a database.



File size 1 K
Downloads 35
Date Tue 03/09/2010 @ 07:04
Author Reddy Software Solutions, Inc.
EMail scripts@reddyss.com
RATING:   COMMENTS (0)  DOWNLOAD

spUtil_TrimTable
Thumbnail

This stored procedure trims leading and trailing spaces off every field in a table.



File size 1 K
Downloads 53
Date Tue 03/09/2010 @ 07:04
Author Reddy Software Solutions, Inc.
EMail scripts@reddyss.com
RATING:   COMMENTS (0)  DOWNLOAD

spUtil_UnindexedFKs
Thumbnail

This stored procedure returns all foreign keys in a database that have no index.  I often use this as part of performance analysis routine.



File size 4 K
Downloads 60
Date Tue 03/09/2010 @ 07:04
Author Reddy Software Solutions, Inc.
EMail scripts@reddyss.com
RATING:   COMMENTS (0)  DOWNLOAD

< BACK  1 of 1  NEXT >
 
);