Viewing 15 posts - 17,191 through 17,205 (of 19,560 total)
Jeffrey Williams-493691 (2/17/2010)
Sorry - quoted wrong post. Meant to post the one above yours.
Are you referring to mine or GT-897544?
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
February 17, 2010 at 5:04 pm
Anybody want to chime in on this one?
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
February 17, 2010 at 4:14 pm
GT-897544 (2/17/2010)
Yes\No, because it is very rare you restore system databases, but no harm in taking system databases as they take little space. Include them in maintenance job.EnjoY!
No harm in...
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
February 17, 2010 at 4:13 pm
Yes backup the system databases. Only master, model, and msdb are necessary. They don't need to be backed up as frequently as the user databases - but must...
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
February 17, 2010 at 3:20 pm
Shriji (2/17/2010)
it is a requirement of a project.
IMHO, the project should be revised. SQL2000 is 10 yrs old and only supported through Extended Support agreements.
With SQL 2005 you could...
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
February 17, 2010 at 3:16 pm
Is it requisite that you install SQL 2000?
-OR-
Will SQL 2005 work for you?
If you are licensed for SQL 2005, I would install that.
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
February 17, 2010 at 3:00 pm
Jeff Moden (2/17/2010)
Even if the triggers aren't necessary, I want to see them because so many folks write RBAR triggers by mistake.
This would appear to be a simple transformation from...
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
February 17, 2010 at 2:27 pm
Kaushik Majumder (2/17/2010)
Thank you so much. I appreciate your views...and solely believe being honest is the best stepping stone to start on.Regards
You're welcome.
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
February 17, 2010 at 12:55 pm
It might be worth a shot. Just curious. I am already registered for this year's event.
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
February 17, 2010 at 12:54 pm
Which app is best suited for the crackberry and twitter?
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
February 17, 2010 at 12:53 pm
Alvin Ramard (2/17/2010)
Twitter certainly is entertaining today.
Thanks Alvin - I would like to see what is going on - but twitter is blocked by websense.
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
February 17, 2010 at 12:46 pm
GilaMonster (2/17/2010)
CirquedeSQLeil (2/17/2010)
GilaMonster (2/17/2010)
Roy Ernest (2/17/2010)
Does each User group get a free pass or something? I hope so... 🙂
Each PASS chapter gets, for the chapter leader. You have to be...
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
February 17, 2010 at 12:45 pm
Kaushik Majumder (2/17/2010)
Not very sure if this will be entirely ethical but with so many knowledgeable people around I found the lure too tempting to refuse, to seek some advice/guidance.....apology...
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
February 17, 2010 at 12:43 pm
Maybe you should have seen it coming. I believe she is still out guarding Lynn's tent.
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
February 17, 2010 at 12:37 pm
Alvin Ramard (2/17/2010)
Jason, don't argue with the Hippo either. And, where's my hula hoop?
Holding in place the hippos pink tutu.
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
February 17, 2010 at 12:30 pm
Viewing 15 posts - 17,191 through 17,205 (of 19,560 total)