Viewing 8 posts - 1 through 8 (of 8 total)
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTERPROCEDURE[dbo].[usp_SEARCH_DATABASE_FOR_STRING]
(
@SearchStringVarchar(1000),
@SearchTypeVarchar(6)= 'EQUALS',
@StringTypeVarchar(8)= 'Text'
)
AS
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--
--PURPOSE:THIS PROCEDURE WILL SEARCH THE ENTIRE DATABASE AND IDENTITY THE TABLE AND COLUMN THAT CONTAINS A SPECIFIC SEARCH STRING AND THE COUNT OF THE...
April 8, 2013 at 3:46 am
The sql job id from the subscription does not match the @eventdata parameter you inputed into your procedure execution statement. Shouldn't this match the guid from the sql job...
March 19, 2013 at 2:01 am
What tools are you using to monitor the tempDB, perfmon, trace, DMVs and what perf objects are looking at to determine is you should separate logs from data files?
December 23, 2012 at 11:48 pm
where do you download sqldiag and perfstats from?
July 5, 2011 at 6:05 pm
Ditto!
July 14, 2010 at 1:56 pm
I don't follow your Subject Title "How to Improve Performance by 3 Orders of Magnitude without Indexes".
An "Indexed View" by definition utilizes an "Index".
July 14, 2010 at 12:36 pm
Hi Paul,
I have a similiar situation only worse, the corruption is so bad id causes a fatal error and shuts down sql server so I can't set the database into...
April 11, 2009 at 7:38 pm
Viewing 8 posts - 1 through 8 (of 8 total)