August 24, 2015 at 11:20 am
GilaMonster (8/24/2015)
I think it's in anticipation of my Star Wars RPG tonight. The puny resistance movement will be crushed under the might of the Imperial Army. The Emperor has foreseen it!
You need to change your icon. 😉
August 24, 2015 at 11:30 am
djj (8/24/2015)
GilaMonster (8/24/2015)
I think it's in anticipation of my Star Wars RPG tonight. The puny resistance movement will be crushed under the might of the Imperial Army. The Emperor has foreseen it!You need to change your icon. 😉
Unless that's an evil clone of Qui-Gon Jinn created to confuse the rebels. :hehe:
August 24, 2015 at 11:58 am
Aside from the obvious spelling error can you explain exactly how this is "Handling" an error? This looks more like error squelching to me.
catch (WebException e)
{
//Error handeling
}
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 24, 2015 at 12:03 pm
Maybe that's a result of using a template which included that part. Or probably it was just included to comply with code standards that only require a catch block without validating the correct handling of errors.
August 24, 2015 at 12:06 pm
Sean Lange (8/24/2015)
Aside from the obvious spelling error can you explain exactly how this is "Handling" an error? This looks more like error squelching to me.
catch (WebException e)
{
//Error handeling
}
Oh! I thought you said HIDING an error. :w00t:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 24, 2015 at 1:27 pm
Grant Fritchey (8/24/2015)
Jeff Moden (8/24/2015)
Grant Fritchey (8/24/2015)
Threadizens, please don't skip posting your top scripts. I need help on this article.I thought you just wanted commands. As for "top scripts", I'm not using anyone else's. I've written all my own such as sp_ShowWorst and sp_WhatsRunning, not to mention backups, index maintenance, etc, etc, ad infinitum.
It could be anything really. The point of the article is to highlight the top 10 scripts that, frankly, you need to do what you've done, write 'em correctly once and then use 'em over and over rather than type them. It's supposed to be illustrative of the common tasks you do, but ought to automate. But that's also why I didn't want anyone's proprietary stuff. I just wanted to focus on the generic work for the beginner.
Ahhh...Now that sounds like a cool article. I'll have to change my post.
August 25, 2015 at 4:02 am
Jeff Moden (8/24/2015)
I've written all my own such as sp_ShowWorst and sp_WhatsRunning...
Care to share 🙂
Far away is close at hand in the images of elsewhere.
Anon.
August 25, 2015 at 4:15 am
djj (8/24/2015)
GilaMonster (8/24/2015)
I think it's in anticipation of my Star Wars RPG tonight. The puny resistance movement will be crushed under the might of the Imperial Army. The Emperor has foreseen it!You need to change your icon. 😉
Well...
The small, rag-tag group of rebels took out an AT-ST walker and a heavily guarded comm center, so I suspect Emperor was foreseeing something else.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2015 at 5:02 am
GilaMonster (8/25/2015)
djj (8/24/2015)
GilaMonster (8/24/2015)
I think it's in anticipation of my Star Wars RPG tonight. The puny resistance movement will be crushed under the might of the Imperial Army. The Emperor has foreseen it!You need to change your icon. 😉
Well...
The small, rag-tag group of rebels took out an AT-ST walker and a heavily guarded comm center, so I suspect Emperor was foreseeing something else.
YAY on rebels!
What character type do you play?
August 25, 2015 at 6:06 am
Brandie Tarvin (8/25/2015)
GilaMonster (8/25/2015)
djj (8/24/2015)
GilaMonster (8/24/2015)
I think it's in anticipation of my Star Wars RPG tonight. The puny resistance movement will be crushed under the might of the Imperial Army. The Emperor has foreseen it!You need to change your icon. 😉
Well...
The small, rag-tag group of rebels took out an AT-ST walker and a heavily guarded comm center, so I suspect Emperor was foreseeing something else.
YAY on rebels!
What character type do you play?
All of them (I'm the GM)
Game's set 3 1/2 years after Revenge of the Sith, so resistance against the Empire is still small and isolated. The Rebel Alliance won't be founded for another ~12 years.
Group consists of a human bounty hunter, Mon Calamari Jedi, Zabrak ex-pirate, human pilot and a Wookie.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2015 at 8:33 am
Ed Wagner (8/13/2015)
Sean Lange (8/13/2015)
Every table name and every column name are exactly 6 UPPER case letters.I feel your pain. Baan's tables were named using a multi-part naming convention that made it a bit silly to try and remember. Example:
t$ttdsls040400
t$ttdsls041400
t$ = Prefix necessary for all tables and columns.
t = Prefix that does nothing except add another "t" to the table name.
td = Package the table is a part of. TD, logically, means Triton Distribution.
sls = Module the table is a part of. SLS means Sales.
040 = Which table it is. Naturally, 040 is Sales Orders and 041 is Sales Orders Lines. Not Sales Order Lines, but Sales Orders Lines.
400 = The company number. You can have multiple companies set up in one database, each with their own set of tables. The company number is the suffix for everything.
The columns where not quite as bad, but almost:
t$orno
t$pono
t$txta
t$txtb
t$ = Prefix necessary for all tables and columns.
next 4 = Field name. Clearly, orno = Order Number, pono = Position Number, txta = pointer to the text table for the this text entry. Note I didn't say foreign key, because where were none.
The text table was: t$tttxt001400.
Obviously, the package "tt" is Triton Text, the module "txt" is Text and the table was 001. There was no 002.
And yes, the whole thing was case sensitive in both object names and values.
See why it gave me nightmares?
Ah, how I miss that ...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
August 25, 2015 at 9:15 am
Brandie Tarvin (8/24/2015)
Grant Fritchey (8/24/2015)
I don't know. That's weird. But the site seems a little off today. A disturbance in the force perhaps.It's as if a thousand bits cried out at once, and were suddenly silenced.
Or someone pulled the server plug.
Some weird network issues in the afternoon. Pinged out IS group. They were seeing like 15-20% packet loss between SQL Server and IIS hosts. Strange.
August 25, 2015 at 10:03 am
OP is looking for: "... I just looking for good understandable explanation by pptx slides for (Index internals & Isolation levels as well) and some demo scripts for the same."
Why am I thinking he has a good reason for not saying why he needs the PowerPoint and demo scripts? 😎
https://ask.sqlservercentral.com/questions/127307/index-internals-ppt.html
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2015 at 10:13 am
Alvin Ramard (8/25/2015)
OP is looking for: "... I just looking for good understandable explanation by pptx slides for (Index internals & Isolation levels as well) and some demo scripts for the same."Why am I thinking he has a good reason for not saying why he needs the PowerPoint and demo scripts? 😎
https://ask.sqlservercentral.com/questions/127307/index-internals-ppt.html
Sheesh what a tool. The guy who responded even has demo scripts. I agree, this guy sounds like he wants to grab somebody else's presentation because he convinced somebody to let him do a presentation on a topic he isn't qualified to discuss and now is having a panic attack because it is more complicated than they realized. Would be fun to be a fly on the wall at that presentation, just make sure to bring a fire extinguisher and some popcorn.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 25, 2015 at 10:19 am
Sean Lange (8/25/2015)
Alvin Ramard (8/25/2015)
OP is looking for: "... I just looking for good understandable explanation by pptx slides for (Index internals & Isolation levels as well) and some demo scripts for the same."Why am I thinking he has a good reason for not saying why he needs the PowerPoint and demo scripts? 😎
https://ask.sqlservercentral.com/questions/127307/index-internals-ppt.html
Sheesh what a tool. The guy who responded even has demo scripts. I agree, this guy sounds like he wants to grab somebody else's presentation because he convinced somebody to let him do a presentation on a topic he isn't qualified to discuss and now is having a panic attack because it is more complicated than they realized. Would be fun to be a fly on the wall at that presentation, just make sure to bring a fire extinguisher and some popcorn.
Reminds me of a few years ago, when some MVP were caught using other people's blog post, word for word.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 15 posts - 50,341 through 50,355 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply