Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,426 through 34,440 (of 59,099 total)

RE: HELP ME !

Raunak Jhawar (3/31/2011)
Moderators,
Please mark this post as a spam and request you to close this thread.
Heh... nah... let it stand to show what we won't help with. 😉
--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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 31, 2011 at 8:15 am

#1305994
RE: Loading data from .csv with blank cells

Amy.G (3/30/2011)
I opened the file in notepad to see the delimiters. Here are the top 5 rows:
title,area,month,lausemp,lausunem,lauslf,lausrate,laus_sw,lauscalc,curyear
Minnesota,ST270000,1,2711426,219041,2930467,7.5,0,7.70E+25,2011
Minnesota,ST270000,2,2728138,217404,2945542,7.4,0,7.70E+25,2011
Minnesota,ST270000,3,,,,,0,7.70E+25,2011
Minnesota,ST270000,4,,,,,0,7.70E+25,2011
Minnesota,ST270000,5,,,,,0,7.70E+25,2011
I hope this is what you were looking for.
It is, indeed! Especially since...
--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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 30, 2011 at 5:57 pm

#1305750
RE: temp table vs. table variable

jp.emvia (3/30/2011)
Its a know fact that in general we use Temp-Tables for large Data and Table variables for small data.
You can check the following link for your doubts. So 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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 30, 2011 at 5:06 pm

#1305747
RE: sudden slow down

Luk (3/30/2011)
It did get fixed. It was a third party .net DLL which we used for search. We fixed it by writing our own search engine.
Note to self:...
--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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 30, 2011 at 4:37 pm

#1305745
RE: Loading data from .csv with blank cells

Amy.G (3/30/2011)
Jeff Moden (3/28/2011)
What does the actual file look like for those 5 rows you gave an example of?
That is a copy and paste of the actual file above. Where...
--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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 30, 2011 at 9:36 am

#1305507
RE: An Introduction to Database Design

FargoUT (3/29/2011)
Jeff Moden (3/29/2011)
In the presence of the element "Administratium", it's all for naught, anyway. 😉
Is that anything like the Illuminati??
Heh... nah... at least the Illuminati get things done. 😀
--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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2011 at 8:24 pm

#1305231
RE: Updating Records Based on Select Results

Johan, Ron, Gus, and David... thanks for jumping in on this one. 🙂
--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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2011 at 8:11 pm

#1305230
RE: Query Tuning - Update Satement

Seeking For Anwser (3/28/2011)
Bro, can you be more specific? sorry just a newbie 😛
Sure... if you'll stop calling me "Bro" and start calling me "Jeff". 😉 Details are in...
--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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2011 at 7:51 pm

#1305227
RE: An Introduction to Database Design

In the presence of the element "Administratium", it's all for naught, anyway. 😉
--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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2011 at 7:36 pm

#1305222
RE: Problem: how to realize custom order

WayneS (3/25/2011)
Gianluca Sartori (3/25/2011)
Yes, now translate it into T-SQL, set-based if possible. 🙂 Ugh!
One made-to-order, set-based solution, utilizing the pseudo-cursor (aka Quirky Update):
(please READ AND UNDERSTAND the article mentioned below...
--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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2011 at 7:20 pm

#1305221
RE: inline table valued function performance problem

Hi Marko,
Thank you very much for taking the time to post the feedback you did. And, it was my pleasure 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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2011 at 7:13 pm

#1305220
RE: detecting similarity among tables attributes(columns)

jamalziena (3/29/2011)
i have table(t1) with 20 attributes i want to compare it with other 10 tables to detect [font="Arial Black"]similar attributes [/font]between the table(t1) and other tables...
--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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2011 at 5:17 pm

#1305207
RE: Greetings from a new (future) SQL DBA.

steven.hulse (3/29/2011)
Thanks for the warm welcome guys! Even though i'm a little aprehensive about taking on this challenge, I am looking forward to it. I strangely found when working with...
--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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2011 at 4:54 pm

#1305201
RE: Looping a select statement to return one table

And I see that Chrissy beat me to it while I was typing...
--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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2011 at 3:44 pm

#1305182
RE: Looping a select statement to return one table

pdonley (3/29/2011)
I'm not having any luck.;
Just a suggestion... If you want some really good help, study the article at the first link in my signature line below. Post simple...
--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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2011 at 3:43 pm

#1305181

Viewing 15 posts - 34,426 through 34,440 (of 59,099 total)