Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,681 through 40,695 (of 59,070 total)

RE: Evaluating the Domain of a Binary Value

SELECT CDE
FROM dbo.DOM_EVAL
GROUP BY CDE
HAVING COUNT(*) = SUM(CAST(E_Flg AS TINYINT))
--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)

December 13, 2009 at 9:51 am

#1091679
RE: Temp DB Transaction log

We need to shrink the log file manually everyday
I agree with George. Stop doing that. The log file will just grow again and you'll end up in nothing...
--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)

December 13, 2009 at 9:45 am

#1091677
RE: File Exists using network path

In other words, the account that SQL Server logs in with must have the necessary privs to actually "see" the paths that you're trying to explore using sp_FileExists.
--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)

December 13, 2009 at 9:35 am

#1091676
RE: how to split a delimeted field value into rows

Paul-755326 (12/13/2009)
RBarryYoung (12/13/2009)
Ouch! You can do much better than a WHILE loop. I strongly advise to read the article that bitbucket pointed out to you (http://www.sqlservercentral.com/articles/T-SQL/63003/) which as...
--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)

December 13, 2009 at 9:30 am

#1091674
RE: Get Out of Your Comfort Zone!

Gary Istvan Varga (12/11/2009)
Jeff Moden (12/9/2009)
Heh... "Think outside the box". Good article, Andy. I have a framed sign on my desk that I actually commissioned an artist friend...
--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)

December 12, 2009 at 11:28 pm

#1091611
RE: Help on vet database design

Option 2 without most of the stuff you mentioned.
--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)

December 12, 2009 at 10:27 pm

#1091610
RE: Inventory Management System

Heh... look in Books Online and the AdventureWorks database that comes free with SQL Server. 😉
--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)

December 12, 2009 at 10:19 pm

#1091609
RE: Are the posted questions getting worse?

Steve Jones - Editor (12/12/2009)
And here I think Barry would like this car
Man, I used to love "Spanky and his gang".
--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)

December 12, 2009 at 10:12 pm

#1091608
RE: Query

care.shiv (12/11/2009)
select 10 from emp;
Is it correct query?
If it is correct what will be the result of this query .............
specify reason also
Why don't you just try it instead 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)

December 12, 2009 at 2:39 pm

#1091591
RE: how to split a delimeted field value into rows

Paul-755326 (12/12/2009)
thank you for the information - very interesting. I solved my problem by using the following TSQL as source data in my DTS...
DECLARE @Str varchar(8000)
SELECT @Str=kPEAccountCode from dbo.dbProfile
Select *...
--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)

December 12, 2009 at 2:24 pm

#1091588
RE: Today's Random Word!

Chris Quinn-821458 (12/11/2009)
Arquebus
Heh... I prefer a portable pork chop launcher. 😀
--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)

December 12, 2009 at 1:21 pm

#1091581
RE: The Sixty-Second Guide to becoming a SQL Server DBA

RACOONRACER (12/11/2009)
I just read the article and am now a full fleldge SQL Server DBA. YooHoo!! I feel my wallet fattening now.
Well, at least you have the first prerequisite for...
--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)

December 11, 2009 at 8:23 am

#1091217
RE: Cannot bulk import CSV file with double quotes

Thanks for the feedback. I'd still be interested in knowing how long it took to import the 250k rows data into a staging table using the OpenRowSet technique 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)

December 11, 2009 at 8:21 am

#1091215
RE: What do I do now? (have fun with this...)

I agree that a lot of things can be done very quickly in T-SQL... just not with cursors. 😉
--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)

December 10, 2009 at 8:57 pm

#1090972
RE: spliting the data using replace function

Save the output of your query into a table with the extra columns you need. Then, use my query to UPDATE the table.
--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)

December 10, 2009 at 8:55 pm

#1090971

Viewing 15 posts - 40,681 through 40,695 (of 59,070 total)