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 «««3,9683,9693,9703,9713,972»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Tuesday, May 14, 2013 3:54 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:33 PM
Points: 23,277, Visits: 31,997
Me thinks someone is in a bit of pickle here.

Gail, you may want to see if you could help. I can't think of much off hand.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1452870
Posted Tuesday, May 14, 2013 5:04 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:13 AM
Points: 36,978, Visits: 31,499
jcrawf02 (5/14/2013)
Jeff, wanted to thank you (and everyone who helped) again for the delimitedsplit8k function, I just had an experience at work where you made me look really good.

file with completely 0NF data (abnormalized? lol) where two or three columns had CSV lists of specialties, FIPS codes for service areas, etc.

I was able to take the file as it existed, break out the data and create multiple records for each provider, specialty, location in order to create maps that we needed urgently.

My solution was supposed to be a fail-safe, ended up looking better than the original solution because I could get all that data out and generated within 24 hours. (~40 maps)

Thanks!!!


VERY cool! Thanks for the feedback and very happy to have been able to help.


--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 #1452882
Posted Wednesday, May 15, 2013 4:57 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 2:17 PM
Points: 53, Visits: 161
Stefan Krzywicki (5/14/2013)
The Dixie Flatline (5/14/2013)
Stefan Krzywicki (5/14/2013)
The Dixie Flatline (5/14/2013)
Stefan Krzywicki (5/14/2013)
The Dixie Flatline (5/14/2013)
We're all fungible.


Not me! I used anti-fungis cream.


Does that mean you're not a fun guy?


Right. I'm more of a tree really.


Binary or balanced?


Decisionduous.


On that note, I'm going for coneheadiferous.
Post #1453009
Posted Wednesday, May 15, 2013 6:06 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 5:06 PM
Points: 8,713, Visits: 9,259
dbursey (5/15/2013)
Stefan Krzywicki (5/14/2013)
The Dixie Flatline (5/14/2013)
Stefan Krzywicki (5/14/2013)
The Dixie Flatline (5/14/2013)
Stefan Krzywicki (5/14/2013)
The Dixie Flatline (5/14/2013)
We're all fungible.


Not me! I used anti-fungis cream.


Does that mean you're not a fun guy?


Right. I'm more of a tree really.


Binary or balanced?


Decisionduous.


On that note, I'm going for coneheadiferous.

Cone head bearing? Surely that means "pointy headed"?

If you're really going for Dilbert's boss, please don't bring him here!

Or does "going for" have its other meaning?


Tom
Post #1453035
Posted Wednesday, May 15, 2013 7:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 7:10 PM
Points: 12,909, Visits: 32,012
On a completely unrelated note, I started making a post asking someone for a working example of a linked server for Access using the ACE drivers; about halfway through creating my example test harness, i figured out what i was doing wrong.

like so many other posts, just by going through the motions of making my question comprehensible to others, i resolved my own question.

As A reward, I'll tell myself I can go home early today, thank you.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1453074
Posted Wednesday, May 15, 2013 7:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, August 25, 2014 7:14 AM
Points: 7,197, Visits: 6,341
Lowell (5/15/2013)
On a completely unrelated note, I started making a post asking someone for a working example of a linked server for Access using the ACE drivers; about halfway through creating my example test harness, i figured out what i was doing wrong.

like so many other posts, just by going through the motions of making my question comprehensible to others, i resolved my own question.

As A reward, I'll tell myself I can go home early today, thank you.


Congratulations! You deserve that reward.


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 #1453078
Posted Wednesday, May 15, 2013 7:36 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 5:06 PM
Points: 8,713, Visits: 9,259
I've seen a lot of ranting about how the different UI in Windows 8 makes it very difficult for someone used to older versions of Windows to use it, so I'd been wondering whether to use Windows 7 for my next laptop.

I was in the UK (where it's easy to buy decent machines - not ay all like here) for a few days recently and my ancient laptop needed replacing. To start with it's XP-based, so unable to install SQL Server 2012, and the manufacturer won't provide a BIOS for Windows Vista, let alone for Windows 7 or 8; on top of that the hard disc is much too small and too finicky to replace, it overheats now and again, it takes for ever to reboot - and half of forever to shut down; the battery is kaput - about 65 seconds life from fully charged to no power at all, and it is rather slow.

Anyway, I decided to bite the bullet and jump from XP to Windows 8 - why start of with Windows 7 when it is clearly obsolescent, and anyway there are better deals available with Windows 8 than with Windows 7.

Now can someone tell me what all the fuss is about? Please? I just don't understand what the difficulties are, in fact I suspect they were unreal problems dreamt up by bone-headed old dinosaurs who have forgotten how to adapt to new things. It's a nice slick interface, easily usable with a mouse and actually slightly more useable with a finger pad than XP is. Installing stuff is a lot less painful than XP (actually that's been true ever since Vista and knew about it because I set up my wife's system with Vista many years ago) because there's no need to go through the slow and overweight switch user dialogue to get the privileges needed for the install. The help is pretty good. It takes maybe 5 or 10 minutes for someone definitely XP-based like me to be up and running without problems.

I also switched from Office XP (or maybe Office 2003 - I can't remember which I installed all those years ago) to Office 2013; I remember all the screams about Office UI changes years ago, and again I can't see what all the fuss was about - the UI is different, some of the changes are improvements and some are not. Also from Mozilla (with Gàidhlig UI) to IE 10 (with US English UI) because IE 10 is supposedly more secure, and find that a pain (wrong language, plus I miss the detailed control over what sites can use client side JS or VBS).

So far I hit only four real problems, none of which appears to be a Windows 8 issue.
1) I forgot to check which edition of Office 2013 had what in it, discovered that the edition I had acquired didn't include Outlook, so bought Outlook form MS online. Installing it on top of Office H&S was an out-and-out pain; it hangs horribly in mid-install - just stops doing things, and at this point it has deleted Word; apparently this is an extremely common problem; telling it to uninstall Office H&S then results in the expected error - can't uninstall until the previous office install has either completed or rolled back. Of course Outlook isn't on the list of programs that can be uninstalled. But it's an MS install error; reboot and try again and if that gives the same result as before, reboot again and ask it to repair the office installation, then forget about it for an hour or two (while connected to internet and logged into MS account, but using the machine for something else - eg copying files over from old machine via nasty slow pen drives or reading stuff from SQLServerCentral). That worked.
2) Configuring Outlook is still as much of a pain as it always was, just a different pain; a long time ago I did it gradually over weeks and weeks - just fixing things (like international fonts, default encodings, keyboard shortcuts for special characters, killing off the preview pane, what happens when the current open message is deleted, and so on) as and when they annoyed me (and having to hunt through help documentation and/or MSDN to do it) and I guess I will go through the same slow and irritating process again; the UI changes don't make any difference here, as it's not stuff I'm the least bit interested in remembering and even if the UI hadn't changed I would have forgotten how to do it by now.
3) Getting files from the old machine to the new machine is a pain - it takes the old machine an inordinate amount of time to copy stiff to a pen drive; USB 1 is so slow.
4) SQLServer 2012 Developer Edition is not available from MS online store in Europe. I guess I will have to download the evaluation edition instead, and hope MS have made developer edition available this side of the pond before that expires.

Anyway, I reckon Windows 8 is super. I can install both 32-bit (eg PasswordSafe, MS Office - why does MS recommend always installing that as 32-bit?) and 64-bit (some games) software and it all runs well and a lot faster than it would on similar hardware under XP (either the path length bloat has been reduced or Windows 8 handles parallelism better than xp did), I can do most things from the desktop that I want to do from the desktop, control panel, command window, admin tools, and all that stuff are easily started and aren't much different from before, task manager is much improved compared with XP, and so on. None of the difficulties people have claimed make converting from earlier versions of Windows are real.


Tom
Post #1453093
Posted Wednesday, May 15, 2013 8:13 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 3:10 PM
Points: 409, Visits: 2,401

Now can someone tell me what all the fuss is about? Please?

Not a big web user eh? Its not like people haven't been discussing this to death.

I think with Start8 and maybe some more gadgets , Windows 8 would probably regain a UI that I like, but I'm personally shocked that a scrappy little company like that could eat Microsoft's lunch on this. I suspect Microsoft has some serious problems going on with leadership and have run out of cluebats.

I can learn my way around 8, but it sure isn't nice and easy to use like 7. Obviously I'm not looking for touch right now, I'm not the only one, using touch in a desktop environment is tiresome because you have to hold your arm up and it causes fatigue.

My feeling is that Microsoft is trying to "force" the new UI for reasons that don't involve end user satisfaction, and thats much of the sentiment I'm getting from others complaining. Interestingly enough, when I started using Unity I felt resentful that there was another UI to learn just like 8, but I quickly became comfortable with it in minutes, whereas Windows 8's irritation factor doesn't seem to be decreasing for me like it did with Unity.

I think you can dismiss the significant proportion of detractors however you like, but you'll have a hard time convincing me that there aren't real issues with this release.
Post #1453118
Posted Wednesday, May 15, 2013 8:18 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:44 PM
Points: 2,762, Visits: 7,235
patrickmcginnis59 10839 (5/15/2013)

Now can someone tell me what all the fuss is about? Please?

Not a big web user eh? Its not like people haven't been discussing this to death.

I think with Start8 and maybe some more gadgets , Windows 8 would probably regain a UI that I like, but I'm personally shocked that a scrappy little company like that could eat Microsoft's lunch on this. I suspect Microsoft has some serious problems going on with leadership and have run out of cluebats.

I can learn my way around 8, but it sure isn't nice and easy to use like 7. Obviously I'm not looking for touch right now, I'm not the only one, using touch in a desktop environment is tiresome because you have to hold your arm up and it causes fatigue.

My feeling is that Microsoft is trying to "force" the new UI for reasons that don't involve end user satisfaction, and thats much of the sentiment I'm getting from others complaining. Interestingly enough, when I started using Unity I felt resentful that there was another UI to learn just like 8, but I quickly became comfortable with it in minutes, whereas Windows 8's irritation factor doesn't seem to be decreasing for me like it did with Unity.

I think you can dismiss the significant proportion of detractors however you like, but you'll have a hard time convincing me that there aren't real issues with this release.


My mother bought a Windows 8 machine, but had no desire to use 8 or touch. She said there's a way to just use it like Windows 7. That's what she does and she has no problems.


--------------------------------------
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
Post #1453121
Posted Wednesday, May 15, 2013 8:24 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 1:37 PM
Points: 21,639, Visits: 15,309
Stefan Krzywicki (5/15/2013)
patrickmcginnis59 10839 (5/15/2013)

Now can someone tell me what all the fuss is about? Please?

Not a big web user eh? Its not like people haven't been discussing this to death.

I think with Start8 and maybe some more gadgets , Windows 8 would probably regain a UI that I like, but I'm personally shocked that a scrappy little company like that could eat Microsoft's lunch on this. I suspect Microsoft has some serious problems going on with leadership and have run out of cluebats.

I can learn my way around 8, but it sure isn't nice and easy to use like 7. Obviously I'm not looking for touch right now, I'm not the only one, using touch in a desktop environment is tiresome because you have to hold your arm up and it causes fatigue.

My feeling is that Microsoft is trying to "force" the new UI for reasons that don't involve end user satisfaction, and thats much of the sentiment I'm getting from others complaining. Interestingly enough, when I started using Unity I felt resentful that there was another UI to learn just like 8, but I quickly became comfortable with it in minutes, whereas Windows 8's irritation factor doesn't seem to be decreasing for me like it did with Unity.

I think you can dismiss the significant proportion of detractors however you like, but you'll have a hard time convincing me that there aren't real issues with this release.


My mother bought a Windows 8 machine, but had no desire to use 8 or touch. She said there's a way to just use it like Windows 7. That's what she does and she has no problems.


The Windows 7 interface is sort of there under the covers. You can switch back and forth. That aside, there are some quirks with Windows 8 (like the switching back and forth) that makes it unattractive to me.

There were also some software compatibility issues and driver issues that I have seen.

I have no desire to use the swipe or touch for a work laptop and to make this OS work well you need touch.




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

Add to briefcase «««3,9683,9693,9703,9713,972»»»

Permissions Expand / Collapse