Viewing 15 posts - 9,991 through 10,005 (of 19,560 total)
Stefan Krzywicki (5/25/2011)
WayneS (5/25/2011)
GilaMonster (5/24/2011)
Steve Jones - SSC Editor (5/24/2011)
Stefan Krzywicki (5/24/2011)
Plus, if the person gets undercover help and succeeds, they're going to be asked to do more that they're...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 25, 2011 at 9:08 am
mpartridge (5/25/2011)
SQLRNNR (5/24/2011)
Try this article for some info on things you can do to troubleshoot the growth.
I do not have a problem with the transaction log, it's the actual database...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 25, 2011 at 9:03 am
This might be something worth looking into then.
http://msftscrptprodsamples.codeplex.com/wikipage?title=SS2005!Event%20Notifications%20Sample
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 25, 2011 at 9:00 am
edit: wrong thread
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 25, 2011 at 9:00 am
Try this article for some info on things you can do to troubleshoot the growth.
http://www.sqlservercentral.com/articles/Log+growth/69476/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 24, 2011 at 11:17 pm
Excellent advice. Thanks for the write-up.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 24, 2011 at 7:09 pm
remove the quotes from around your table name. Also, replace the variable in the replace statement with the column name from the table.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 24, 2011 at 2:49 pm
vradul (5/24/2011)
DECLARE @x VARCHAR(50)
SET @x='Maryland<h2></h2>'
SELECT * FROM 'table' '<h2>'+ REPLACE(@x,'<h2></h2>','</h2>')
WHERE @x LIKE '%<h2></h2>'
#1064 - You have an error in your...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 24, 2011 at 2:32 pm
vradul (5/24/2011)
yes - is the syntax different? I was under the impression it is the same...
Some syntax is, but each product has certain things that are particular to that version...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 24, 2011 at 2:30 pm
Have you tried to rollback the SP?
Can you get the exact error?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 24, 2011 at 2:20 pm
I think we would still like to see the queries you attempted with the errors you were getting.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 24, 2011 at 2:16 pm
vradul (5/24/2011)
I see that - but getting syntax errorsI appreciate the help, you guys...
Please post the query that you are using along with the syntax errors you are seeing.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 24, 2011 at 1:34 pm
Look closer at Lutz's example. He is using a '<h2>' + replace(...) which will produce the results you are seeking.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 24, 2011 at 1:19 pm
I haven't seen a valid business case yet and would be interested in more details.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 24, 2011 at 12:55 pm
Please provide sample table structure.
Also, does the data appear exactly like that or is there other data in the string?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 24, 2011 at 12:53 pm
Viewing 15 posts - 9,991 through 10,005 (of 19,560 total)