Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,891 through 52,905 (of 59,072 total)

RE: Exporting to a fixed length FF with varying record lengths

Right idea but no need for the loop...
SELECT CAST(varchara AS CHAR(10))
+ CAST(varcharb AS CHAR(255))
+ CAST(varcharc AS CHAR(50))
...
--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 15, 2008 at 4:58 pm

#768408
RE: New Company, new DBA Tools budget, can you recommend any?

GSquared (1/15/2008)
A bat with a nail? How primitive! I want a taser, preferably with a laser-sight on it (even if it doesn't work at a distance)! I...
--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 15, 2008 at 4:45 pm

#768404
RE: Query for work shift differential

Wouldn't this be easier?
SELECT CASE
WHEN @Nbr > 0 THEN @Nbr
...
--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 15, 2008 at 4:41 pm

#768403
RE: Updating values in one table from another table

Govind (1/15/2008)
Thanks Charlie! Yes, ofcourse this works.. But, here am looking to move the things fast.. There are 56 columns each in both the tables and I need to update...
--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 15, 2008 at 4:34 pm

#768399
RE: Updating values in one table from another table

Spot on, Matt.
I'll also add that SQL Server seems to have "tipping points" depending on the size of the table being updated, etc. What I mean by that 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 15, 2008 at 4:24 pm

#768397
RE: returning data for a given month

GSquared (1/15/2008)
Jeff Moden (1/14/2008)
Heh... Keep in mind that the BETWEEN examples are rarely correct because they don't allow all times of the day to be included or they mistakenly...
--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 15, 2008 at 4:18 pm

#768393
RE: Autogrow Timeout Expired

Heh... the DBA should know enough to keep from having to set auto-grow to 1.5GB 😉 DBA should setup an alert of sorts when the size of the database...
--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 15, 2008 at 6:07 am

#768074
RE: Listing db names from SQL script

sp_helpdb is not what I need although I wish that I could read the code for it!!
That part is the easy part... execute the following code with the results 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)

January 15, 2008 at 6:03 am

#768073
RE: Query for work shift differential

Adam Haines (1/10/2008)
I Found this workaround on this site. With this you can return a postive number of zero from a function.
DECLARE @NBR INT
SET @NBR = -123456789
SELECT round(@NBR,-1-floor(log10(abs(@NBR))))
more info:
http://www.sqlservercentral.com/articles/Advanced+Querying/afixfunctionintsql/2487/
Adam......
--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 15, 2008 at 5:52 am

#768071
RE: How to Analyze the already developed database? (i.e. Transaction Handling, profiling)

You can also mail me on the below email address.
jshah333@gmail.com
A bit selfish, there... no one but you would learn, then. 😉
My first reaction is "stupid people" really did it to...
--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 15, 2008 at 5:40 am

#768062
RE: Autogrow Timeout Expired

If I could make a suggestion... I think auto-grow is a bit overrated... sure, in 2k5, they made it almost instantaneous... but auto-growth frequently means that the DBA hasn't planned...
--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 15, 2008 at 5:27 am

#768056
RE: Tracking Illicit Users

Clever... effective... and vengeful... all in the same action... I LIKE 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 15, 2008 at 5:15 am

#768054
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Hi Mark,
Thanks for the feedback.
On the posting of XML you mentioned... The best thing to do would be to simply attach the XML as a 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 15, 2008 at 5:11 am

#768053
RE: How to find a table existed or not?

Jeff Moden (1/14/2008)
Yes... use "Dynamic SQL" to accomplish this...
Ack... not enough coffee... sorry.
Gail's (GilaMonster) post is correct for this...
--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 15, 2008 at 5:09 am

#768052
RE: returning data for a given month

Chirag (1/15/2008)
between '2008/01/01 12:00:00:000 AM' and '2008/01/01 11:59:59:997 PM' if u want all records between the 2 dates.
Just a suggestion...
The optimizer is going to evaluate the BETWEEN code 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)

January 15, 2008 at 5:03 am

#768050

Viewing 15 posts - 52,891 through 52,905 (of 59,072 total)