Viewing 15 posts - 33,361 through 33,375 (of 59,102 total)
SQLRNNR (7/5/2011)
Jeff Moden (7/2/2011)
GilaMonster (7/1/2011)
Thanks everyone. Wasn't actually planning on announcing it here.Congratulations, Gail. This means that the top two non-employee posters for SSC have been selected again. 🙂
Congrats...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 5:49 pm
SanDroid (7/5/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 5:44 pm
Nope. The thing that Paul and Tom came up with is nothing more than an error checking method. It also happens to help guarantee functionality, but there was...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 5:11 pm
yasubmj (7/5/2011)
So the big question here is, the anchor only executes once, then why is this making such a big difference?
Because recursive CTE's suck. 😀 They're actually worse than...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 9:11 am
If you have to drop PK's, FK's, and/or Indexes for ETL, then you're doing something drastically wrong.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 8:52 am
steveb. (7/5/2011)
sanjeev_krs2004 (7/5/2011)
sometimes because of memory issue otherwise space issue.Thanks,
Sanjeev.
to be honest this sounds like an 'ambulance at the bottom of the cliff' solution , you should look...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 5:41 am
Along with the other good suggestions on this thread, please take the time to read the articles at the link that Gila-Monster posted above. It should be required reading...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 5:22 am
lepoto.masedi (7/5/2011)
What is the quickest and most effective way of learning T-SQL?
As boring as it sounds, do the one thing that most people do not do when beginning their studies...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 5:13 am
Craig Farrell (7/4/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2011 at 10:26 pm
TheSQLGuru (7/4/2011)
Given that a flaw was found what, a two years or more, after the "quirky update" was first put out there how many incorrect results were calculated?
So, what's...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2011 at 12:58 pm
turner.phillip3 (7/4/2011)
Several times I have faced the questions like- What is reason for change?
At most cases one does it for hike in salary, but you cant...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2011 at 12:54 pm
crackbridge (6/27/2011)
but trust me best practice to help in the forum is do not issue banal views when the answer is not known
Actually, it IS a best practice to "issue...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2011 at 8:51 am
I'm no SAN or storage expert but I have to ask... Is there a reason why the new disks can't simply be assigned to the current "E" drive or why...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2011 at 8:35 am
CELKO (7/4/2011)
T-SQL is about a decade behind Oracle and DB2. We only got part of the window clause for aggregates; the full syntax is:
You said a mouthful there! ...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2011 at 8:27 am
BWAA-HAA!!! Actually, that's a pretty good definition! Well done.
However, I'd bet credits to Navy beans that if something goes wrong, the Business User will blame the Developers and...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2011 at 8:17 am
Viewing 15 posts - 33,361 through 33,375 (of 59,102 total)