August 25, 2015 at 10:22 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.
Sterrett's stuff is pretty good. He even recommended the MCM videos. If the OP really just wanted to learn, the provided information was more than adequate.
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
August 25, 2015 at 10:26 am
SQLRNNR (8/25/2015)
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.
Sterrett's stuff is pretty good. He even recommended the MCM videos. If the OP really just wanted to learn, the provided information was more than adequate.
Agree, but you don't need PPTs to learn. 😀
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:28 am
Alvin Ramard (8/25/2015)
SQLRNNR (8/25/2015)
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.
Sterrett's stuff is pretty good. He even recommended the MCM videos. If the OP really just wanted to learn, the provided information was more than adequate.
Agree, but you don't need PPTs to learn. 😀
True. But I provide my ppts after sessions I give. It is a nice tool for review for some. On the flip side, I have put less and less information on my slides anyway. So looking at my deck will be less useful to somebody trying to reproduce the session for themselves. 😀
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
August 25, 2015 at 10:37 am
Alvin Ramard (8/25/2015)
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.
Yeah was thinking the same thing. It is really shocking how hard it is to shake that perception once it has been demonstrated to be fact. I have a hard time with that given blog still just because of that.
_______________________________________________________________
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:58 am
andrew gothard (8/25/2015)
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 ...
It makes me both happy and sad to know that someone else knows the pain.
August 25, 2015 at 11:01 am
I don't know if it's just me, but SSC has been having some blocks of time where it's very slow recently. I had one this morning where it took about 30 seconds to load a single page. It seemed to go away after about 10 minutes, but I remember seeing the same thing last night. Other sites function normally, so I'm wondering if there's a job running or new process that's slowing things down.
August 25, 2015 at 11:36 am
Ed Wagner (8/25/2015)
I don't know if it's just me, but SSC has been having some blocks of time where it's very slow recently. I had one this morning where it took about 30 seconds to load a single page. It seemed to go away after about 10 minutes, but I remember seeing the same thing last night. Other sites function normally, so I'm wondering if there's a job running or new process that's slowing things down.
It's the stock market activity slowing things down. 😀
Kidding. I've noticed the same. Maybe the garbage filter is getting clogged. 😀
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 1:09 pm
Alvin Ramard (8/25/2015)
Ed Wagner (8/25/2015)
I don't know if it's just me, but SSC has been having some blocks of time where it's very slow recently. I had one this morning where it took about 30 seconds to load a single page. It seemed to go away after about 10 minutes, but I remember seeing the same thing last night. Other sites function normally, so I'm wondering if there's a job running or new process that's slowing things down.It's the stock market activity slowing things down. 😀
Kidding. I've noticed the same. Maybe the garbage filter is getting clogged. 😀
Thanks. At least I know I'm not the only one seeing it.
August 25, 2015 at 1:18 pm
Ed Wagner (8/25/2015)
Alvin Ramard (8/25/2015)
Ed Wagner (8/25/2015)
I don't know if it's just me, but SSC has been having some blocks of time where it's very slow recently. I had one this morning where it took about 30 seconds to load a single page. It seemed to go away after about 10 minutes, but I remember seeing the same thing last night. Other sites function normally, so I'm wondering if there's a job running or new process that's slowing things down.It's the stock market activity slowing things down. 😀
Kidding. I've noticed the same. Maybe the garbage filter is getting clogged. 😀
Thanks. At least I know I'm not the only one seeing it.
Nope. Been happening for me sporadically for months and months now.
_______________________________________________________________
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 8:33 pm
Sean Lange (8/25/2015)
Ed Wagner (8/25/2015)
Alvin Ramard (8/25/2015)
Ed Wagner (8/25/2015)
I don't know if it's just me, but SSC has been having some blocks of time where it's very slow recently. I had one this morning where it took about 30 seconds to load a single page. It seemed to go away after about 10 minutes, but I remember seeing the same thing last night. Other sites function normally, so I'm wondering if there's a job running or new process that's slowing things down.It's the stock market activity slowing things down. 😀
Kidding. I've noticed the same. Maybe the garbage filter is getting clogged. 😀
Thanks. At least I know I'm not the only one seeing it.
Nope. Been happening for me sporadically for months and months now.
Yes, it's been around for some time. But it seems to have got worse in the last few days.
Tom
August 25, 2015 at 10:19 pm
TomThomson (8/25/2015)
Sean Lange (8/25/2015)
Ed Wagner (8/25/2015)
Alvin Ramard (8/25/2015)
Ed Wagner (8/25/2015)
I don't know if it's just me, but SSC has been having some blocks of time where it's very slow recently. I had one this morning where it took about 30 seconds to load a single page. It seemed to go away after about 10 minutes, but I remember seeing the same thing last night. Other sites function normally, so I'm wondering if there's a job running or new process that's slowing things down.It's the stock market activity slowing things down. 😀
Kidding. I've noticed the same. Maybe the garbage filter is getting clogged. 😀
Thanks. At least I know I'm not the only one seeing it.
Nope. Been happening for me sporadically for months and months now.
Yes, it's been around for some time. But it seems to have got worse in the last few days.
It seems to be particularly bad this evening.
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
August 26, 2015 at 5:30 am
SQLRNNR (8/25/2015)
TomThomson (8/25/2015)
Sean Lange (8/25/2015)
Ed Wagner (8/25/2015)
Alvin Ramard (8/25/2015)
Ed Wagner (8/25/2015)
I don't know if it's just me, but SSC has been having some blocks of time where it's very slow recently. I had one this morning where it took about 30 seconds to load a single page. It seemed to go away after about 10 minutes, but I remember seeing the same thing last night. Other sites function normally, so I'm wondering if there's a job running or new process that's slowing things down.It's the stock market activity slowing things down. 😀
Kidding. I've noticed the same. Maybe the garbage filter is getting clogged. 😀
Thanks. At least I know I'm not the only one seeing it.
Nope. Been happening for me sporadically for months and months now.
Yes, it's been around for some time. But it seems to have got worse in the last few days.
It seems to be particularly bad this evening.
It's happening again right now. I agree that it's gotten bad over the past few days.
Steve - Are you running something new or interesting?
August 26, 2015 at 6:51 am
Doing experiments this morning. I've got to update a table to fix data problems introduced by a bad file. So I'm in test and realize that Things Are Getting Complicated. I have a CASE statement with 9 WHEN clauses, 8 of which check 3 columns. One of these columns is a LEFT(mycol,2) check. And I'm thinking to myself, that's gotta kill the processor.
So I build two queries. One is the plain vanilla with the LEFT in each of the WHEN clauses. The other uses a CTE to grab the LEFT and then I do a join to the main table and use the column in the CTE as my WHEN comparison. I run these queries with the Execution Plan and discover...
That I need to stop over-complicating things. Apparently SQL likes the LEFT in each of the WHEN clauses better than me jumping through hoops with a CTE to simplify. Not only is the execution plan cleaner, but the execution time is a second less than the CTE query.
Huh. I guess functions don't always kill a query.
August 26, 2015 at 7:03 am
Nope. Only when they're on a join or where clause predicate which prevents index usage.
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 26, 2015 at 8:25 am
Brandie Tarvin (8/26/2015)
Doing experiments this morning. I've got to update a table to fix data problems introduced by a bad file. So I'm in test and realize that Things Are Getting Complicated. I have a CASE statement with 9 WHEN clauses, 8 of which check 3 columns. One of these columns is a LEFT(mycol,2) check. And I'm thinking to myself, that's gotta kill the processor.
Sounds like you might be better off with some lookup tables, even ones you drop, and doing JOIN's.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 15 posts - 50,356 through 50,370 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply