Viewing 15 posts - 1 through 15 (of 160 total)
actually it was purely from a poor schema design viewpoint i.e column names which have reserved words and then if you need to call them in a delimited string etc
one...
January 30, 2012 at 9:47 am
sorry yes phrased rather badly ... the current amount of free page space
I hang my head in shame
October 17, 2011 at 9:26 am
ahhh we frequently turn them on /off on dev enviornments to shoe horn data in ... just want to add some automatic checks to ensure we turn them back...
June 29, 2011 at 10:47 am
I trust you... you like babylon 5 !
but yes I did run a trace with those events selected and it causes a cachemiss so guessing the whitepaper is slighlty out...
April 11, 2011 at 8:53 am
so the assertion that it does in the paper is incorrect or am I reading it wrong to start with ? 🙂
April 11, 2011 at 8:41 am
http://msdn.microsoft.com/en-us/library/ee343986%28v=sql.100%29.aspx
if you go to the section
Recompilations due to SET option changes
and Im tracing
SP:Starting
SP:StmtStarting
SP:Recompile
...
April 11, 2011 at 8:36 am
so based on all your feedback Ive slightly altered Michael's script and I now have :
SET NOCOUNT ON
DECLARE @DBsysname,
@Namevarchar(100),
@Recoveryvarchar(100),
@SQLvarchar(MAX)
SET @SQL = ''
DECLARE db_cur CURSOR FOR
SELECT name
FROM master.sys.databases
wherename like '%cust%'
order...
November 2, 2010 at 4:52 am
thank you Gail 🙂
November 2, 2010 at 3:55 am
that looks just the ticket with its nested cursor to work out the logfile names
I've added the caveat that "file_id = 2" and will have a further play...
November 1, 2010 at 10:28 am
yep just dev/test servers and log space can run away with itself .. not a "real" one 🙂
November 1, 2010 at 9:56 am
many thanks Paul ... god I was making life complicated with my code...
~simon
April 7, 2010 at 4:30 am
thank you all for your help
Paul thats great I'll go for that appraoch ... far simpler !
~simon 🙂
March 31, 2010 at 3:47 am
as for why I was trying to avoid dymanic sql it was due to the potential for performance hits etc
November 24, 2009 at 2:24 pm
Viewing 15 posts - 1 through 15 (of 160 total)