Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,1134,1144,1154,1164,117»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Monday, September 2, 2013 4:37 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 3,420, Visits: 5,347
dwain.c (9/1/2013)
Brandie Tarvin (8/30/2013)
YAY! I have a new computer at work.

Which means I have just spent all morning recovering all my SSMS options, importing my email files, etc. etc. And now I have to figure out how to force BIDS to open up T-SQL into SSMS.

I did it once. I just can't remember where the setting is hiding.


Ah, the pain and pleasure of getting a new PC. Just returned from vacation and there's a new one sitting on my desk.

Pain: Already noted.

Pleasure: Has SQL 2012 installed. Yep! Look out. Time to play.


More pain not previously noted. The bozos installed 32 bit versions of everything. Grrrr!



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1490584
Posted Monday, September 2, 2013 10:42 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:41 PM
Points: 31,080, Visits: 15,525
dwain.c (9/2/2013)
dwain.c (9/1/2013)
Brandie Tarvin (8/30/2013)
YAY! I have a new computer at work.

Which means I have just spent all morning recovering all my SSMS options, importing my email files, etc. etc. And now I have to figure out how to force BIDS to open up T-SQL into SSMS.

I did it once. I just can't remember where the setting is hiding.


Ah, the pain and pleasure of getting a new PC. Just returned from vacation and there's a new one sitting on my desk.

Pain: Already noted.

Pleasure: Has SQL 2012 installed. Yep! Look out. Time to play.


More pain not previously noted. The bozos installed 32 bit versions of everything. Grrrr!


Does it matter? Not sure for SQL Server and most things it does







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1490664
Posted Monday, September 2, 2013 11:24 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 13,017, Visits: 10,800
Steve Jones - SSC Editor (9/2/2013)
dwain.c (9/2/2013)
dwain.c (9/1/2013)
Brandie Tarvin (8/30/2013)
YAY! I have a new computer at work.

Which means I have just spent all morning recovering all my SSMS options, importing my email files, etc. etc. And now I have to figure out how to force BIDS to open up T-SQL into SSMS.

I did it once. I just can't remember where the setting is hiding.


Ah, the pain and pleasure of getting a new PC. Just returned from vacation and there's a new one sitting on my desk.

Pain: Already noted.

Pleasure: Has SQL 2012 installed. Yep! Look out. Time to play.


More pain not previously noted. The bozos installed 32 bit versions of everything. Grrrr!


Does it matter? Not sure for SQL Server and most things it does


SSAS Tabular might need more than 4GB of RAM.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1490668
Posted Monday, September 2, 2013 3:15 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 26, 2014 3:23 PM
Points: 2,116, Visits: 6,439
Steve Jones - SSC Editor (9/2/2013)
dwain.c (9/2/2013)
dwain.c (9/1/2013)
Brandie Tarvin (8/30/2013)
YAY! I have a new computer at work.

Which means I have just spent all morning recovering all my SSMS options, importing my email files, etc. etc. And now I have to figure out how to force BIDS to open up T-SQL into SSMS.

I did it once. I just can't remember where the setting is hiding.


Ah, the pain and pleasure of getting a new PC. Just returned from vacation and there's a new one sitting on my desk.

Pain: Already noted.

Pleasure: Has SQL 2012 installed. Yep! Look out. Time to play.


More pain not previously noted. The bozos installed 32 bit versions of everything. Grrrr!


Does it matter? Not sure for SQL Server and most things it does


Not so sure about that. Yes, 64 bit Windows machines are able to run 32 bit versions of the same software, but they have to thunk down to 32 bit mode, so that's an additional overhead. Correct me if I'm talking rubbish. Plus as Koen mentioned, they are limited to 4GB of memory (3GB if run on a 32 bit OS). Why would you want to limit yourself in that way if you have the same software as a 64 bit version available on the same DVD?


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1490692
Posted Monday, September 2, 2013 4:25 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:05 AM
Points: 17,710, Visits: 15,580
Koen Verbeeck (9/1/2013)
GilaMonster (8/31/2013)
Just ....

Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.


Sent late on a Friday night, right before a USA long weekend.

At least I no longer have to worry about budgeting for the upgrade exam.


That's just sad.


For those that haven't seen it yet

Connect Item on the Retirement of MCM
https://connect.microsoft.com/SQLServer/feedback/details/799431/please-dont-get-rid-of-the-mcm-and-mca-programs

And a lengthy summary of the whole thing
http://jasonbrimhall.info/2013/09/02/rare-species-extinction-and-the-mcm/




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1490707
Posted Monday, September 2, 2013 4:38 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:11 AM
Points: 39,968, Visits: 36,328
SQLRNNR (9/2/2013)
Koen Verbeeck (9/1/2013)
GilaMonster (8/31/2013)
Just ....

Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.


Sent late on a Friday night, right before a USA long weekend.

At least I no longer have to worry about budgeting for the upgrade exam.


That's just sad.


For those that haven't seen it yet

Connect Item on the Retirement of MCM
https://connect.microsoft.com/SQLServer/feedback/details/799431/please-dont-get-rid-of-the-mcm-and-mca-programs

And a lengthy summary of the whole thing
http://jasonbrimhall.info/2013/09/02/rare-species-extinction-and-the-mcm/


and I sent a write-up on the situation to Steve. When, where, how and if it gets published remains to be seen.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1490709
Posted Monday, September 2, 2013 4:59 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:05 AM
Points: 17,710, Visits: 15,580
GilaMonster (9/2/2013)
SQLRNNR (9/2/2013)
Koen Verbeeck (9/1/2013)
GilaMonster (8/31/2013)
Just ....

Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.


Sent late on a Friday night, right before a USA long weekend.

At least I no longer have to worry about budgeting for the upgrade exam.


That's just sad.


For those that haven't seen it yet

Connect Item on the Retirement of MCM
https://connect.microsoft.com/SQLServer/feedback/details/799431/please-dont-get-rid-of-the-mcm-and-mca-programs

And a lengthy summary of the whole thing
http://jasonbrimhall.info/2013/09/02/rare-species-extinction-and-the-mcm/


and I sent a write-up on the situation to Steve. When, where, how and if it gets published remains to be seen.


Hopefully sooner rather than later.

Pins and needles seeing the strike-through on your MCM in the signature.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1490712
Posted Monday, September 2, 2013 5:05 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:11 AM
Points: 39,968, Visits: 36,328
SQLRNNR (9/2/2013)
Pins and needles seeing the strike-through on your MCM in the signature.


I'll remove the strikeout in a week or two. Just making a point.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1490714
Posted Monday, September 2, 2013 5:41 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 11:28 PM
Points: 35,263, Visits: 31,750
I'll probably never go for the MCM or any other certification that MS has to offer (now that I've seen what MS does with the cream of the crop, I'm certain of it) but I voted up the CONNECT item asking to keep it. I encourage anyone that sees this to do likewise because, like Gail, Grant, Tom, and a couple of other people that I have a huge respect for have all stated, it's about the only MS cert that I respect and the people that busted a hump to get it deserve for it to be preserved. This is like saying that a PHD from MIT is null and void and too bad for all you Seniors that have been studying. The people that have been studying for it for the last year or so deserve to at least take the test. One month notice certainly isn't enough warning.

Here's the link that Steve posted to the CONNECT item on the MCM thread...
https://connect.microsoft.com/SQLServer/feedback/details/799431/please-dont-get-rid-of-the-mcm-and-mca-programs


Shifting gears, my hat is off and I bow deeply to all of you that have either attained the MCM or have studied your butts off getting ready for it. I know a great many of you and it won't help you get a job or a deserving title but, in my eyes and in the eyes of a majority of the community, all of you were MCMs long before you even took a shot at it. Please don't let this huge mistake by Microsoft change that.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1490715
Posted Monday, September 2, 2013 6:20 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:49 PM
Points: 728, Visits: 5,226
GilaMonster (8/31/2013)
Just ....

Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.


Sent late on a Friday night, right before a USA long weekend.

At least I no longer have to worry about budgeting for the upgrade exam.


Just popped in today to check on this thread, and saw this...

First, to Gail: You will *always* be a SQL Master to me (maybe I could be your Padawan? )

Second, WTF is going on at MS? First, they go and kill off the Technet subscription, pissing of scads of people of various levels (from consultants who used the subscription software for testing out upgrade scenarios, to home / self-learners like myself,) now they go and kill off *THE* top certification, really the one which people in the industries would respect from MS (and I say this having several MS certs of the MCITP / MCSA variety.) You'd think MS execs are *trying* to drive the company under...

Lastly, I did vote for the Connect item to save the MCM program, but found the 2nd workaround someone posted somewhat amusing. A link to the Oracle Master certification...

Regardless, to all the MCMs here: (we need a saluting smiley)
Post #1490718
« Prev Topic | Next Topic »

Add to briefcase «««4,1134,1144,1154,1164,117»»»

Permissions Expand / Collapse