Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,446 through 35,460 (of 59,099 total)

RE: require additional memory?

ALZDBA (1/9/2011)
Thank you for correcting that George.
Index tuning wizard is the correct name.:blush:
It can be found in SQLserver Profiler toolbar option "tools".
Heh... call it what you want, I actually...
--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)

January 9, 2011 at 8:26 pm

#1271233
RE: Need help, to load dynamic columns

touchmeknot (1/8/2011)
I appreciate your help Jeff.
I am sorry, I realize that I have mentioned Excel (in my other posts) which I have posted after the first one.
I managed loading...
--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)

January 9, 2011 at 8:24 pm

#1271232
RE: How to split a single record in multiple records based on a datetime period?

Although you can certainly do some clever things with recursive CTE's, I generally try to avoid them because they're so very expensive for CPU and other resources compared to things...
--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)

January 9, 2011 at 5:08 pm

#1271224
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

Mike McIver (1/9/2011)
Really . . . another ridiculous article! I am responding to this reader's reply to illustrate the problem. Misinformation breeds misinformation . . . STR is...
--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)

January 9, 2011 at 3:46 pm

#1271219
RE: Cross join query help

joshtheflame (1/9/2011)
this is what i did. the WHERE condition was the problem which was filtering right after grouping so removed where thats it:)
DECLARE @startDate varchar(20)
DECLARE @endDate...
--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)

January 9, 2011 at 3:00 pm

#1271211
RE: Cross join query help

joshtheflame (1/8/2011)
ive solved my problem 🙂
Cool... What did you do to fix 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)

January 8, 2011 at 4:46 pm

#1271093
RE: Flat with multiple data sets

Ghanta (1/7/2011)
Hi Guys,
I am sure some of you might have dealt with the situation that I am in... wanted to check the efficient way to do this.... I have fixed...
--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)

January 8, 2011 at 10:56 am

#1271067
RE: Need help, to load dynamic columns

touchmeknot123 (1/7/2010)
Hi,
I have to load a csv file on monthly basis. The columns in the file are not fixed.
example : Id, 200911,200910 might be the columns in one file
...
--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)

January 8, 2011 at 10:43 am

#1271064
RE: Converting European Currency Format to United States

So long as every value will have 2 decimal places (regardless of what the radix format is like), this should do it... not sure how you'd use it in SSIS...
--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)

January 8, 2011 at 10:40 am

#1271063
RE: require additional memory?

ananda.murugesan (1/7/2011)
Thanks LutzM for reply...
Yes, this is SQL server 2000. I will find the script for missing index in sql 2000.
Could you please share me this missing index script...
--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)

January 8, 2011 at 10:20 am

#1271061
RE: Trigger regarding

Nils Gustav Stråbø (1/8/2011)
If the receiving service's queue is disabled (the service can't be disabled, only it's queue), the the messages will stay in sys.transmission_queue until the queue is enabled...
--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)

January 8, 2011 at 10:00 am

#1271059
RE: update

BenWard (1/6/2011)
heh heh heh
I like scalar functions! They're functional and scalar!
Seriously though most of the SQL work I do is based around writing reports on data that we...
--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)

January 7, 2011 at 10:13 pm

#1271027
RE: Trigger regarding

Nils Gustav Stråbø (1/6/2011)
@jeff. Starting in SQL Server 2005, database mail is using service broker. That means that the sp_send_dbmail does not actually send the email, it just sends a...
--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)

January 7, 2011 at 6:42 pm

#1271008
RE: To start sql output frm the middle of the page

toddasd (1/6/2011)
Jeff Moden (1/6/2011)
toddasd (1/6/2011)
declare @a varchar(100)
set @a = 'Number of files=4'
select substring(@a, 17, len(@a))
:blink:
To me, looks like he wanted the "4" from the string. So, you know, taking a...
--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)

January 7, 2011 at 6:38 pm

#1271007
RE: change the following query to storedprocedure

WayneS (1/6/2011)
Jeff Moden (1/6/2011)
... Credits to Navy beans ...
Huh?
Think "Dollars to Donuts". 😉
--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)

January 7, 2011 at 6:23 pm

#1271004

Viewing 15 posts - 35,446 through 35,460 (of 59,099 total)