Viewing 15 posts - 16,321 through 16,335 (of 19,560 total)
homebrew01 (3/17/2010)
Brandie Tarvin (3/17/2010)
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
March 17, 2010 at 2:54 pm
tosscrosby-60625 (3/17/2010)
crookj (3/17/2010)
Fantastic! (65% and Sunny in Colorado in March :w00t:)Joe
65%???? It's 60 degrees and sunny in Chicago too! Spring fever!
Only 71 today here.
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
March 17, 2010 at 2:53 pm
So, BOB, when is part II for this article coming out?
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
March 17, 2010 at 2:49 pm
Steve Jones - Editor (3/17/2010)
It's not a police force that's demanding to get into your house/company/computer. I certainly don't want anyone to have rights to connect or view what's on...
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
March 17, 2010 at 2:01 pm
john.campbell-1020429 (3/17/2010)
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
March 17, 2010 at 1:53 pm
Ben Moorhouse (3/17/2010)
technophobe parents not wanting their kids to risk having their household fined.
Is it technophobe parents, or cautious parents trying to protect their children?
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
March 17, 2010 at 1:45 pm
GSquared (3/17/2010)
If, for example, antivirus software were tax-deductible, for both corporations and...
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
March 17, 2010 at 1:44 pm
If you're allowed data loss is 30 minutes, then either amount of time would be fine.
With 15 minutes, less data loss = better. The backup time should be negligible...
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
March 17, 2010 at 1:40 pm
Jason Shadonix (3/17/2010)
Once you get all your requirements hashed out, your question will probably answer itself.
Agreed
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
March 17, 2010 at 1:25 pm
The answer to that is it depends. How much other transaction volume do you experience?
Personally without more info, I would lean towards every 15 minutes.
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
March 17, 2010 at 1:07 pm
jacroberts (3/17/2010)
This is probably one of the most unreadable stories and unreusable pieces of code I have ever seen in an article.
Please provide specifics if you are going to criticize...
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
March 17, 2010 at 12:59 pm
Yes. This is how you setup SSRS (NLB) on a clustered server. Though SSRS does not use IIS it is a sample of a webby app that is...
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
March 17, 2010 at 12:54 pm
lmu92 (3/17/2010)
assuming SS2K5 I'd use a table holding all reserved words I'd like to chek (e.g. from this web site: https://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.etools.ejbbatchdeploy.doc/topics/rsqlMSSQLSERVER_2005.html)
and join that to sys.syscolumns.name and sys.sysobjects.
That's about the best...
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
March 17, 2010 at 12:46 pm
forgot
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
March 17, 2010 at 12:42 pm
whug (3/17/2010)
I like the story, its a good example of how we SQL junkies get it done.I would have refused the work. ...
The art of saying NO:
I would have...
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
March 17, 2010 at 11:52 am
Viewing 15 posts - 16,321 through 16,335 (of 19,560 total)