Skip to content
SQLInsight

SQLInsight

We Do SQL Right!

  • What’s New
  • Power BI Gallery
  • PowerPoint Downloads
  • About Us
  • Contact Us
  • Home
  • 2011
  • August

Month: August 2011

Character selection by location in a string

August 31, 2011 Steve Schneider

Suppose you had a 4 character field (prefx), and you wanted to find all those records where the 2nd and 4th characters were numeric, with the other two being alphabetic.  Here’s a neat, simple solution: select * from TableName where prefx…

Read more

SQL 2005, SQL 2008, SQL AdministrationSQLLeave a Comment on Character selection by location in a string

Monitoring Log File Growth in SQL Server

August 19, 2011 Steve Schneider

We recently had to ‘migrate’ a vendor supplied database with a vendor-supplied process.  We were warned that the database log file could grow some 10,000% !!!!  Not finding that particularly palatable, I upped the transaction log backup to every minute.  I…

Read more

SQL 2005, SQL 2008, SQL AdministrationLeave a Comment on Monitoring Log File Growth in SQL Server

Dba’s Memory Assistant

August 12, 2011 Steve Schneider

I can’t always remember ok, make that i frequently forget things.   Can i use SSMS to help me?  Yes!

SQL 2008, SQL AdministrationAdministrationLeave a Comment on Dba’s Memory Assistant

Error formatting query, probably invalid parameters

August 5, 2011 Steve Schneider

Ok, so what the heck does that error mean? 

SQL 2008Leave a Comment on Error formatting query, probably invalid parameters

Creating an instance of the COM component Error with SSMS

August 3, 2011 Steve Schneider

For the 4th time, I’ve tried to open a job step and been prevented with this mysterious error “Creating an instance of the COM component” …  The fix is normally simple, just navigate to the C:\Program Files\Microsoft SQL Server\100\DTS\binn directory and…

Read more

SQL 2005, SQL 2008SQL 2008 SSMSLeave a Comment on Creating an instance of the COM component Error with SSMS
Copyright SQL Insight 2017 © All rights reserved.
Business Era by mProThemes