April 21, 2011 at 4:58 pm
Steve Jones - SSC Editor (4/21/2011)
Oh. Em. Gee.Are you guys having a deep technical discussion on some type of performance testing? Shouldn't that be a thread somewhere else besides The Thread?
Heh, the original purpose was to share an amusing moment and ask a generic question about running into issues while exploring something. So to answer your question, yes.
And OMG? You've been hanging out with the kids too much. 😛
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 21, 2011 at 7:44 pm
I have been hanging with the kids. That's how my daughter says it to me. "Oh Em Gee, Dad"
April 22, 2011 at 7:41 am
Craig Farrell (4/20/2011)
You know, this is why I'm never quite sure if I should write tech articles. ...So for the rest of you tech article writer/bloggers, instead of helping me on this, what the heck do you do when you go sailing headfirst into things of this nature? 😀
Ran into something like that very recently. My expected result on an article I'm writing was completely different from my actual result, on some performance testing. Since my expected result was based on just about every review I've ever seen of one of the things I was testing, this was quite a surprise. So I dumped the article I was writing, and wrote something about the surprise instead.
Jeff saw a very rough draft of it, so he knows what I'm talking about. Everyone else will just have to wait till I get off my lazy butt and finish a more final draft and submit it. Which should be next week some time.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 22, 2011 at 8:21 am
Koen Verbeeck (4/20/2011)
Stefan Krzywicki (4/20/2011)
Under your table name, click on the Columns folder and drag it to your query window and you get a complete list of all your columns. A time saver and makes me less likely to use * even in quick queries I don't intend to use more than once.:w00t: That's awesome!
Another neat little trick is selecting code with the ALT pressed. It allows you to select a block of code, so you can easy allign it with something else.
(maybe you all know this already :-))
Did you know that most windows programs (including SSMS; not Notepad) allow you to select COLUMNS of text? Position the cursor at the starting position, and while holding down the ALT key, drag to select across multiple rows/columns and release the ALT key. Then that selected text can be deleted, indented, etc.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 22, 2011 at 9:41 am
New SQLPeople Interview posted: http://bit.ly/eFMj6C
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
April 22, 2011 at 10:32 am
Another handy little tip.
If you run SQL Server on a personal laptop / PC with the services set to MANUAL instead of AUTOMATIC, starting the SQL Server Agent Service will force the SQL Server Service to start also (since the former is dependent on the later).
This saves a little time because you don't have to start both services. Just start the dependent one and it will start both without additional clicking.
April 22, 2011 at 11:24 am
I haven't gone through all the QotDs yet. Can someone tell me if there's been one on identities and transactions?
April 22, 2011 at 12:21 pm
Brandie Tarvin (4/22/2011)
I haven't gone through all the QotDs yet. Can someone tell me if there's been one on identities and transactions?
Just on transactions (not specifically including identities)
1. Published 2009-12-22
2. Published 2010-11-24
April 22, 2011 at 12:37 pm
WayneS (4/22/2011)
Koen Verbeeck (4/20/2011)
Stefan Krzywicki (4/20/2011)
Under your table name, click on the Columns folder and drag it to your query window and you get a complete list of all your columns. A time saver and makes me less likely to use * even in quick queries I don't intend to use more than once.:w00t: That's awesome!
Another neat little trick is selecting code with the ALT pressed. It allows you to select a block of code, so you can easy allign it with something else.
(maybe you all know this already :-))
Did you know that most windows programs (including SSMS; not Notepad) allow you to select COLUMNS of text? Position the cursor at the starting position, and while holding down the ALT key, drag to select across multiple rows/columns and release the ALT key. Then that selected text can be deleted, indented, etc.
:w00t: I did not know that.
Intedesting!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 22, 2011 at 2:15 pm
Koen Verbeeck (4/22/2011)
WayneS (4/22/2011)
Did you know that most windows programs (including SSMS; not Notepad) allow you to select COLUMNS of text? Position the cursor at the starting position, and while holding down the ALT key, drag to select across multiple rows/columns and release the ALT key. Then that selected text can be deleted, indented, etc.:w00t: I did not know that.
Intedesting!
Most people don't. Makes it a lot easier for capitalizing SQL code if it's formatted nicely to begin with. 😉
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 22, 2011 at 4:24 pm
WayneS (4/22/2011)
Koen Verbeeck (4/22/2011)
WayneS (4/22/2011)
Did you know that most windows programs (including SSMS; not Notepad) allow you to select COLUMNS of text? Position the cursor at the starting position, and while holding down the ALT key, drag to select across multiple rows/columns and release the ALT key. Then that selected text can be deleted, indented, etc.:w00t: I did not know that.
Intedesting!
Most people don't. Makes it a lot easier for capitalizing SQL code if it's formatted nicely to begin with. 😉
That's one of the ones I'm always worried they're going to get rid of with the next version of MS products since so few people know about it.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 22, 2011 at 4:30 pm
Stefan Krzywicki (4/22/2011)
WayneS (4/22/2011)
Koen Verbeeck (4/22/2011)
WayneS (4/22/2011)
Did you know that most windows programs (including SSMS; not Notepad) allow you to select COLUMNS of text? Position the cursor at the starting position, and while holding down the ALT key, drag to select across multiple rows/columns and release the ALT key. Then that selected text can be deleted, indented, etc.:w00t: I did not know that.
Intedesting!
Most people don't. Makes it a lot easier for capitalizing SQL code if it's formatted nicely to begin with. 😉
That's one of the ones I'm always worried they're going to get rid of with the next version of MS products since so few people know about it.
It's a quite handy trick that I like.
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
April 22, 2011 at 9:50 pm
What? I didn't know that. Man, after all these years, I think I need to read a modern Windows manual once again.
Thanks for the tip!
Jim
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
April 23, 2011 at 12:52 am
So now we have someone saying don't REORG indexes only REBUILD and you don't need to do statistics maintenance.
http://www.sqlservercentral.com/Forums/Topic1094168-146-3.aspx
I hope my reply isn't too terse. I made it at 2:30am my time, but I couldn't not respond.
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
April 23, 2011 at 5:33 am
Jack Corbett (4/23/2011)
So now we have someone saying don't REORG indexes only REBUILD and you don't need to do statistics maintenance.http://www.sqlservercentral.com/Forums/Topic1094168-146-3.aspx
I hope my reply isn't too terse. I made it at 2:30am my time, but I couldn't not respond.
Just returned from the pub ?
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/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 25,891 through 25,905 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply