Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
A methodology is described to bring out the best in database monitoring through System Center Operations Manager 2007 customization.
2008-10-13
10,218 reads
Blocking
DB Connection Killer
This script opens a little cursor that will clean out connections to any DBs you specify.
2008-09-09 (first published: 2008-07-21)
1,426 reads
Unable to create Publication
Hello,I am having a strange problem. I am unable to create ANY new publication on any of the databases. I try to add it using the SQL Enterprise Manager or Query Analyzer and get the following error for exec sp_addpublication :Server: Msg 14294, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 24 Supply either @job_id or @job_name […]
2005-05-03
3 reads
RE: Why Generic Error Handling?
Is this the same question as on SQL Server Performance.com?http://www.sommarskog.se/error-handling-II.htmlhttp://www.sommarskog.se/error-handling-I.htmloffer a good insight on error handling.
2005-05-03
RE: Re: Problem w/ the cursor in sproc
exactly... also you should convert it to int (unless it's impossible with the data). Also even some have disagreed about this I've seen a huge speed improvement in changing my primary keys from char(6) to int on a orders table (yup crappy set-up but I can't change it). I simply copied the data to a […]
2005-04-12
RE: How to check whether cusor is open or not?
Try using "IF Cursor_Status('variable', '@my_cursor') = -1"
2005-04-08
1 reads
RE: SQL Server Restore
Hi again... Now it'sServer: Msg 3206, Level 16, State 1, Line 1 No entry in sysdevices for backup device 'f:\cp.bak'. Update sysdevices and rerun statement. Server: Msg 3013, Level 16, State 1, Line 1 VERIFY DATABASE is terminating abnormally. The backup is NOT from that server... undestand ?
2005-03-14
RE: String Tokening
Not aware of a function, per se but you could try thisSELECT CASE WHEN PATINDEX('%[^0-9]%',[Input])>0 THEN LEFT([Input],PATINDEX('%[^0-9]%',[Input])-1) ELSE [Input] END
2005-03-14
2005-03-14
2005-03-09
Blogs
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Goal Progress for Jan 2023
By Steve Jones
The grade for January is a D. Details below, but just not making a...
Context Info Across Databases–#SQLNewBlogger
By Steve Jones
Does Context Info work across databases? This post shows it does. Another post for...
Forums
Storing a text file in a VARCHAR(MAX) column
I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX)...
"ID" primary key from two separate tables as a foreign key in a new table
I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...
blocking issue
Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...
Ask SSC