Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,291 through 40,305 (of 59,102 total)

RE: Changing a FLOAT column to VARCHAR

lmu92 (1/15/2010)
Since FLOAT is an approximate-number data type, the character length may vary, therewith exceeding the VARCHAR(10) limit.
You need to get the value converted to a "known length".
Either one...
--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, 2010 at 7:03 pm

#1104522
RE: Sub-queries vs correlated sub-queries

CirquedeSQLeil (1/15/2010)
This article may be of use. That, and this article[/url]. Gail delves into comparing the differences of an inner join v. in and in v. exists. ...
--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, 2010 at 7:00 pm

#1104521
RE: Sub-queries vs correlated sub-queries

Despite what the interviewers want to hear, the correct answer IS "It Depends" because it does. Let's see what I mean...
First, a little test data... a million rows 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, 2010 at 6:45 pm

#1104516
RE: calling a temp table from within a sproc

bitbucket-25253 (1/15/2010)
Now if you desire to have your first batch of T-SQL function, that is create a temp table, in one connection and query it from another connection, create 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 15, 2010 at 5:23 pm

#1104503
RE: Subroutines in TSQL

Ray K (1/15/2010)
Jeff Moden (1/14/2010)
But it sounds like a cursor (GAH!) could serve as a "subroutine".
I'll bet it was really painful for you to type this! 😀
Heh... yeah... hand still...
--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, 2010 at 12:14 pm

#1104399
RE: Scripting Options

:blush: Thanks, J-F. Both for the help and the nice compliment.
--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, 2010 at 12:09 pm

#1104395
RE: Scripting Options

Dunno... I've never seen this particular problem before. Doesn't seem to be an "instance" setting, either.
Thanks for the help... guess I'll have to throw a rock at the boys...
--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, 2010 at 9:39 am

#1104301
RE: Scripting Options

Heh... thanks for confirming that I haven't lost my mind (at least not all of it). That [Scripting] node doesn't exist in the [Tools][Options] dropdown for me. 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, 2010 at 9:24 am

#1104284
RE: Today's Random Word!

CirquedeSQLeil (1/13/2010)
PC (politically correct - load of crap)
Heh... is that what they mean when they say "Get a loc on 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 14, 2010 at 11:48 pm

#1104065
RE: data file for tempdb very huge

The_SQL_DBA (1/12/2010)
Click here[/url] and here for articles on how to manage tempdb growth.
Also, if your tempdb has grown to that big a size, then something must have run that needs...
--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 14, 2010 at 11:12 pm

#1104061
RE: The Price of SQL Server

Heh... if they keep deprecating stuff, then zero.
Seriously... SQL Server comes with a whole battery of features that (I believe) are optional and extra compared to some other products. ...
--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 14, 2010 at 11:05 pm

#1104059
RE: Initial databases size and database autogrowth

snu155 (1/14/2010)
I would set it to a % of the size of the database. But it depends on your environment.
I'd strongly recommend against that because when the DB 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 14, 2010 at 9:25 pm

#1104050
RE: Enforcing T-SQL Coding Standards

Heh... there's a real easy way to enforce coding standards...
Step 1: Lockdown the server so that only authorized reviewers/DBA's can promote code.
Step 2: Publish the standards with the...
--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 14, 2010 at 9:15 pm

#1104049
RE: CAN ANY ONE WRITE QUERY FOR BELOW DESCRIPTION!

ansu_411,
If you'd like better help quicker with tested code in the future (although Lowell did a fine job), please read the following article...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
--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 14, 2010 at 9:08 pm

#1104047
RE: Haiti

My hat is off to those that want to go and help. However, unless you are well equipped to provide your own water, food, and medical care, don't go...
--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 14, 2010 at 9:04 pm

#1104046

Viewing 15 posts - 40,291 through 40,305 (of 59,102 total)