Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,711 through 43,725 (of 59,101 total)

RE: To write a query

That's a "running total" problem. Inline queries are ok for only the smallest of collections. See the following for why...
http://www.sqlservercentral.com/articles/T-SQL/61539/
If you have more than small collections of data...
--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)

May 23, 2009 at 1:22 pm

#999370
RE: Introduction to Bitmasking in SQL Server, Part 2

First, this series of articles is good and I won't take anything away from the author on it. Well done.
But, I agree with many of the others when it...
--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)

May 23, 2009 at 1:14 pm

#999367
RE: Introduction to Bitmasking in SQL Server, Part 2

Mitch Miller (5/21/2009)
Sorry LP -- I just had a nice big explanation with examples, and this damn website took it and tossed it. Now I'm pissed. I can't...
--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)

May 23, 2009 at 12:53 pm

#999366
RE: Query Elapsed Time

Florian Reischl (5/23/2009)
Jeff Moden (5/23/2009)
If I understand correctly, this is a stored proc that processes a single row? If it's used in conjunction with a GUI, that's probably ok....
--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)

May 23, 2009 at 12:42 pm

#999362
RE: Query Elapsed Time

RBarryYoung (5/23/2009)
Jeff: this is a typo, I think:
Jeff Moden (5/23/2009)
If so, then as Barry suggests, you have to measure it's performance over time and having the limit of 1/3^rd...
--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)

May 23, 2009 at 12:34 pm

#999357
RE: The Real SQL Server Experts

Despite their undoubted depth of their knowledge and frightening intelligence, those in charge of the T-SQL language at Microsoft often lack recent frontline experience. In this respect, they are less...
--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)

May 23, 2009 at 12:27 pm

#999354
RE: Google search

ningaraju.n (5/22/2009)
Thanx Friend
but i have 200 to 300 tables in my db... i have to apply search for all tables like i descriged above .... i think its not good...
--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)

May 23, 2009 at 12:19 pm

#999352
RE: PIVOT QUERY HELP NEEDED

martin.edward (5/23/2009)
I need to understand more about queries If am to move from the simple SELECT statements to t-sql dynamic queries. Where can I start ?
Start here for a stong...
--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)

May 23, 2009 at 11:31 am

#999351
RE: Are you a Military Vet?

bitbucket (5/23/2009)
RBarryYoung (5/22/2009)
bitbucket (5/22/2009)
For those old enough to remember Korean Peace Keeping otherwise known as the Korean War
!!!
bitbucket, You're 75???
Nope not 75 ... born April 1932 ... which...
--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)

May 23, 2009 at 11:23 am

#999350
RE: Are you a Military Vet?

Grant Fritchey (5/22/2009)
Yep, in the Navy on Subs. Hated it, but I'm glad I did it.
Yep... me too! Fast Attacks. Loved the Submarine Service and teaching electronics and...
--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)

May 23, 2009 at 11:20 am

#999349
RE: Query Help

allister.reid (5/23/2009)
However, this kind of output sounds like something for display (user interface or reporting) so why not just do it in the application?
I would be interested in what others...
--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)

May 23, 2009 at 11:15 am

#999348
RE: Query Elapsed Time

{approaching sensitive problem very carefully} If I understand correctly, this is a stored proc that processes a single row? If it's used in conjunction with a GUI, that's probably...
--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)

May 23, 2009 at 8:40 am

#999327
RE: Time Off

Here's to all the men and women in harm's way that can't take time off. Thank you American Soldier.
--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)

May 22, 2009 at 5:32 pm

#999257
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Ravi Naik (5/22/2009)
Great piece of code Jeff but i have tested it with 10000000 records and i am getting Arithmetic overflow error converting data type' :unsure:
I am working a Developer...
--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)

May 22, 2009 at 11:07 am

#999026
RE: What is the command using for Import and export data from database table using excel file

Why not just use "Get External Data" from Excel?
--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)

May 21, 2009 at 9:16 pm

#998666

Viewing 15 posts - 43,711 through 43,725 (of 59,101 total)