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,1114,1124,1134,1144,115»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Friday, August 30, 2013 12:18 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 7,133, Visits: 6,295
Sean Lange (8/30/2013)
Brandie Tarvin (8/30/2013)
ARGGGGH!

The crappy thing about a new computer?

Trying to remember what I did many years ago to get the CTRL-SHIFT-C and CTRL-SHIFT-R combinations to comment out code in SQL 2008. I can't freaking find it and Google is hopeless.

I tried setting the keyboard schema to SQL 2000, but it's not working. Grrr.


I don't remember how to change it but you could just use the native shortcuts. (ctrl+k+c and ctrl+k+u). The upside is that if you use visual studio the keyboard shortcuts are the same.


Those commands, they do not do what you think they do...

The first one (c) includes execution plan. The second highlights the database drop down box.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1490255
Posted Friday, August 30, 2013 12:20 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 7,133, Visits: 6,295
So my new machine is Win 7. I have SQL 2008 installed fresh. Interestingly enough, the Open File with New Connection icon is not on the toolbar in Win 7 where it is in XP (my old box)...

Has anyone else noticed stuff like this when swapping between work boxes?


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1490257
Posted Friday, August 30, 2013 12:29 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 13,130, Visits: 11,967
Brandie Tarvin (8/30/2013)
Sean Lange (8/30/2013)
Brandie Tarvin (8/30/2013)
ARGGGGH!

The crappy thing about a new computer?

Trying to remember what I did many years ago to get the CTRL-SHIFT-C and CTRL-SHIFT-R combinations to comment out code in SQL 2008. I can't freaking find it and Google is hopeless.

I tried setting the keyboard schema to SQL 2000, but it's not working. Grrr.


I don't remember how to change it but you could just use the native shortcuts. (ctrl+k+c and ctrl+k+u). The upside is that if you use visual studio the keyboard shortcuts are the same.


Those commands, they do not do what you think they do...

The first one (c) includes execution plan. The second highlights the database drop down box.


That depends on which keyboard schema you are using. You must still be on SQL 2000. If you change it back to Standard those shortcuts work.



_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1490262
Posted Friday, August 30, 2013 12:29 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:55 AM
Points: 1,220, Visits: 6,570
Brandie Tarvin (8/30/2013)
Sean Lange (8/30/2013)
Brandie Tarvin (8/30/2013)
ARGGGGH!

The crappy thing about a new computer?

Trying to remember what I did many years ago to get the CTRL-SHIFT-C and CTRL-SHIFT-R combinations to comment out code in SQL 2008. I can't freaking find it and Google is hopeless.

I tried setting the keyboard schema to SQL 2000, but it's not working. Grrr.


I don't remember how to change it but you could just use the native shortcuts. (ctrl+k+c and ctrl+k+u). The upside is that if you use visual studio the keyboard shortcuts are the same.


Those commands, they do not do what you think they do...

The first one (c) includes execution plan. The second highlights the database drop down box.


Check CodePlex for BIDS Helper.
That was the first thing we would load in for some of the tweaks it offers.
Post #1490263
Posted Friday, August 30, 2013 12:43 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:46 AM
Points: 8,573, Visits: 9,078
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.


Well, that's something that happens every 3 or 4 years - you should be used to the pain by now.

Jan Van der Eecken (8/30/2013)
Congrats. I just got a new laptop. Now I need to come to terms with Windows 8...

Windows 8 isn't hard to come to terms with. If you simultaneously upgraded to Office 15 you may find some pain, though: Office Picture Manager is no more, no replacement except Windows Photo Gallery which omits rather a lot of OPM's features; Outlook seems to have some problems with recognising encodings (I think this is a bug, but of course it may be a "feature" ).


Tom
Post #1490265
Posted Friday, August 30, 2013 2:18 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 4:55 AM
Points: 2,441, Visits: 6,432
Sean Lange (8/30/2013)
Brandie Tarvin (8/30/2013)
ARGGGGH!

The crappy thing about a new computer?

Trying to remember what I did many years ago to get the CTRL-SHIFT-C and CTRL-SHIFT-R combinations to comment out code in SQL 2008. I can't freaking find it and Google is hopeless.

I tried setting the keyboard schema to SQL 2000, but it's not working. Grrr.


I don't remember how to change it but you could just use the native shortcuts. (ctrl+k+c and ctrl+k+u). The upside is that if you use visual studio the keyboard shortcuts are the same.


Yeah, go with the times, Brandie. At least Ctrl-Insert, Shift-Delete, Shift-Insert as per the original IBM UAM guide (or whatever it was called, got the book somewhere) still work everywhere (mostly).


--------------------------------------------------------------------------
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 #1490304
Posted Saturday, August 31, 2013 3:43 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 42,479, Visits: 35,547
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.



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 #1490365
Posted Saturday, August 31, 2013 3:53 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:27 AM
Points: 15,556, Visits: 27,928
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.


Cool. That relieves a lot of pressure. I haven't taken a single Microsoft certification. Now, since the only one I respect is gone, I don't have to.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1490368
Posted Saturday, August 31, 2013 9:58 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:46 AM
Points: 8,573, Visits: 9,078
Grant Fritchey (8/31/2013)
Cool. That relieves a lot of pressure. I haven't taken a single Microsoft certification. Now, since the only one I respect is gone, I don't have to.

I like that attitude. I thought there were two probably respectable certs though, MCM (or MCSM) and MCA. Even those, of course, are were about ability to do things with MS products, not about broader ability to do things with, say, a number of different DBMSs running on different platforms (at least two out of Windows, Linux, mainstream UNIXes, and IBM operating systems). Actually, anyone who has MCM and MCA has to be extremely good, and so does anyone with just MCM, but people that good are generally known by reputation (I didn't know until today that Gail was MCM, but I certainly knew the was at least that good) so I don't see the value of the certification unless it was taken for fun, as a challenge.

I have a somewhat jaundiced view of MS Certs, anyway. I've never attempted any, couldn't see the value - if I needed to know something I could learn it without wanting a certification for it, and the outfits I wanted to work for were outfits that would understand that. So while I think some may be respectable, I never saw the point in someone like me going for them. It would have been a waste of either my time and money or of my time and my employer's money, unless the firm had so few MS certified people that we couldn't get the right partnership deals with MS (having a couple of junior guys in the shop hold pretty basic level MS certs is useful from that point of view, it saves senior people from having to waste time and money on certifications, and satisfies MS requirements for partnership deals).

I guess certs get pulled because MS is no longer making enough revenue from them; presumably a replacement (not quite the same as what it replaces, of course, that would be a bit too obvious) will appear in due course, to refresh the revenue stream.

edit:fix typo


Tom
Post #1490398
Posted Saturday, August 31, 2013 10:37 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Yesterday @ 8:06 PM
Points: 36,786, Visits: 31,243
Grant Fritchey (8/31/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.


Cool. That relieves a lot of pressure. I haven't taken a single Microsoft certification. Now, since the only one I respect is gone, I don't have to.


Ditto that. I also thought that having to renew the MCM every couple/three years was a bit unfair to those that busted a hump to attain it in the first place. It should be more like a Masters Degree where you always have it and it's understood that you will improve with experience and other training.

Gail, my hat's off to you for getting the MCM. Even when the cert goes away, you'll always have my respect not only as someone who achieved the MCM, but someone that was, in my eyes, an MCM even before the cert became available.

Grant, you're just as amazing. No "real" formal training but a great speaker on multiple subjects and you've written two of the best books on Execution Plans that there will ever be.


--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 #1490406
« Prev Topic | Next Topic »

Add to briefcase «««4,1114,1124,1134,1144,115»»»

Permissions Expand / Collapse