Viewing 15 posts - 2,656 through 2,670 (of 7,506 total)
raj acharya (11/11/2010)
can you help me for how to set data file or log file autogrowth.
actually till now we never faced problem of autogrowth most of database are set to...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 11, 2010 at 12:15 am
With mirroring, only one of both databases can be available at an instance at a single point in time.
So the other is awaiting for log entries, hence in "restoring"...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 10, 2010 at 11:49 pm
I don't think so. simple reason ... this cannot be "at run time" but must be persisted, so a trigger is the only way.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 10, 2010 at 11:41 pm
I'm sorry I couldn't reply earlier, but I was in class the rest of the day.
As always I'm glad others jumped in and helped out.:cool:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 10, 2010 at 7:51 pm
- have a look at Jeff Modens article on tally tables or moving averages.
Those should get you started. http://www.sqlservercentral.com/Authors/Articles/Jeff_Moden/80567/
- maybe row_number() can get you a good enough solution. Check books...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 10, 2010 at 4:42 pm
Define "copy":
if that is the same objects without content, just script out your full db ( rightclick in your object browser hovering over the dbname, choose "all tasks" select generate...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 9, 2010 at 2:23 pm
The kb addresses sql2005 having this issue.
OP stated his server is sql2008.
But it is indeed a good hint on posting the @@version info of this instance.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 9, 2010 at 8:43 am
I would also double check if there is no concurrent full database backup running at the same time. Although the errormsg doesn't state it explicitly ... I would just check...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 8, 2010 at 9:02 pm
cpatel (11/8/2010)
I will try this but tell me that if I have to execute stored procedure in trigger with async than how can I call that.Thanks
Don't rush in to...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 8, 2010 at 8:56 pm
No, the message only states something is wrong.... which we already knew 😉
Can you check the maintenance plan log, or enable it ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 8, 2010 at 5:43 pm
Don't just rely on the ddl trigger taking for granted it is active.
Set up a sqlserver event monitoring, so you detect when the trigger is being disabled ("disable trigger"...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 8, 2010 at 4:42 pm
as you have noticed any trigger is "in transation".
Your transaction will not complete until your trigger is completed.
Check out SQLServer service broker to get a async solution for this.
Service broker...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 8, 2010 at 4:35 pm
Keep in mind you posted in a SQL2005 forum. Maybe ask SSC to shift it to a SQL2008 one.
- please post the actual backup error message (check your sqlserver logs)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 8, 2010 at 4:29 pm
Have a look at SQLCMD in books online !
hmm ... so you're going to have users write your sqlscript and direct upload/update your prod db ??
If that user just needs...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 7, 2010 at 5:36 pm
I would double check this query using a simple select.
Select COUNT(*) nRows
FROM dbo.convertr$
inner JOIN dbo.tbl_RadioRates
ON SUBSTRING(dbo.convertr$.STA_CODE, 2, 4) =...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 7, 2010 at 5:25 pm
Viewing 15 posts - 2,656 through 2,670 (of 7,506 total)