Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,116 through 32,130 (of 59,099 total)

RE: Index scan vs. seek

That's kind of what I was getting at... you just took more words to say 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)

October 30, 2011 at 4:06 pm

#1400902
RE: Database email isn't sending email anymore.

First, my apologies. I said to remove the double quotes and I'm not sure what I was thinking because the double quotes you had are required.
Shifting to your latest...
--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)

October 30, 2011 at 4:03 pm

#1400901
RE: Index Rebuild - Job running over 16 hours.....

Thanks, Jackimo. My apologies because I should have asked this other question at the same time because it will make a difference in the solution...
Are you running Standard Edition...
--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)

October 30, 2011 at 3:43 pm

#1400899
RE: Extract multiple files from multiple directories with a data flow task

Stan Kulp-439977 (10/30/2011)
It is the connection manager used by the SQL statement in the script task that determines whether the SQL statement can be executed.
If your connection manager 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)

October 30, 2011 at 3:41 pm

#1400898
RE: Extract multiple files from multiple directories with a data flow task

1. What kind of privs does the SSIS job need to be able to run the VB.Net scripts for this job?
2. What kind of privs does someone need...
--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)

October 30, 2011 at 1:17 pm

#1400889
RE: Inserting records in a table fills up TempDB

ChrisM@Work (10/27/2011)
What does the following query return?
SELECT count(*)
FROM TABLE1 AS CC
INNER JOIN TABLE2 AS M ON CC.FORMATTED_PHONE_ADDRESS = M.EMAIL_ADDRESS
Vishal...
Answer this question first. This will likely identify the key...
--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)

October 30, 2011 at 12:54 pm

#1400886
RE: Index Rebuild - Job running over 16 hours.....

jackimo (10/28/2011)
The oldest data is rolled off nightly.
These are actually a fairly easy problems (rolloff of old data and index maintenance) to solve but I need to know something first....
--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)

October 30, 2011 at 12:47 pm

#1400883
RE: Index scan vs. seek

Lexa (10/28/2011)
GilaMonster (10/28/2011)
Can you post the index definition please?
Can you post the execution plan please?
CREATE UNIQUE NONCLUSTERED INDEX my_index ON table1
(
[f1] ASC,
[f2] ASC
)
INCLUDE ( [f3],
[f4]) WITH (PAD_INDEX = OFF,...
--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)

October 30, 2011 at 12:39 pm

#1400882
RE: Time Elapsed Testing

What's wrong with DATEADD(dd,3,GETDATE())???
--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)

October 30, 2011 at 12:33 pm

#1400881
RE: Strip HTML Tags

Laura_SqlNovice (10/28/2011)
Guys,
Guys I have a table with a column that has html text. The column with html text is pretty big datatye varchar(max)... I wanted to check if any of...
--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)

October 30, 2011 at 12:30 pm

#1400879
RE: Restricting IMPERSONATE permissions only to certain stored procedures

Banana-823045 (10/27/2011)
Am I still missing something?
Apparently not. I'm getting the same errors as you and haven't been able to suss it with something as simple EXECUTE AS OWNER. ...
--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)

October 30, 2011 at 11:29 am

#1400876
RE: Database email isn't sending email anymore.

~~Change all of the double quotes to single quotes to start with...~~
Scratch that... I was thinking of something else... :blush: the double quotes are required.
--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)

October 30, 2011 at 10:51 am

#1400874
RE: Get result based on competition like FIFO

You haven't described what goes into MatrixNo.
--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)

October 30, 2011 at 10:48 am

#1400873
RE: Not able to handle duplicates whild updation. Not as simple as you think..

You could use ROW_NUMBER() over the dupes to number them.
--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)

October 30, 2011 at 9:18 am

#1400868
RE: noob tsql confusion!

prvmine (10/29/2011)
look at this link - might not be exactly what you want, but a good place for yout to start
http://www.sqlservercentral.com/scripts/Data+Dictionary/72048/
by Abdullah.Khan
Gosh... I wouldn't use that script as an example....
--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)

October 30, 2011 at 9:11 am

#1400867

Viewing 15 posts - 32,116 through 32,130 (of 59,099 total)