Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,171 through 37,185 (of 59,098 total)

RE: Data Type and Length

paul.knibbs (8/11/2010)
David Data (8/10/2010)
It would be nice to have a datatype like .NET's string which can carry strings of (almost) any length without worrying about what its contents' maximum length...
--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)

August 23, 2010 at 5:14 am

#1210364
RE: Data Type and Length

Hugo Kornelis (8/9/2010)
Good question! When I first saw it, I thought there would be a very high percentage of correct answers since the confusing default lengths for character strings have...
--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)

August 23, 2010 at 5:09 am

#1210362
RE: Disk configuration for TempDB

vidhya sagar (8/22/2010)
It's always not necessary to create tempdb files based on your processor count. You can check the info given by Paul Randal
If you have an high speed...
--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)

August 23, 2010 at 4:59 am

#1210359
RE: Cumulative Updates & Hotfixes

cilla25 (8/22/2010)
Sorry, I wasn't clear. I have lower environments to do testing on, and hanging back to see how others go does sound like a good idea.
I am more wondering,...
--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)

August 23, 2010 at 4:53 am

#1210355
RE: How to read first line of each text file in a folder and validate

steve-893342 (8/20/2010)
This approach will need to be refined to suit your requirements but it gives you the gist of a possible solution.
You can identify the files you 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)

August 22, 2010 at 8:53 pm

#1210209
RE: SQL for normalizing repeating groups in a text file

You could also use UNPIVOT once you have the data in a staging 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)

August 22, 2010 at 8:38 pm

#1210206
RE: Cumulative Updates & Hotfixes

I don't install CU's or Hot Fixes unless they have something very specific that I need. Don't forget that CU's aren't tested to the same extent as SP's.
Also, 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)

August 22, 2010 at 8:36 pm

#1210205
RE: Last Day of Month subscription for Shared SSRS schedule

SqlServerLover (8/22/2010)
I did not mean to run manually.
Set up shared schedule to run at 12 am on the 1st of the month.
That's what I'm talking about. What happens...
--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)

August 22, 2010 at 8:18 pm

#1210201
RE: When creating new table does column order matter if different data types?

GilaMonster (8/22/2010)
sql_er (8/21/2010)
Last week a co-worker mentioned that it is best to place fixed length data types first, followed by variable length columns
No, not at all. Order of columns 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)

August 22, 2010 at 8:13 pm

#1210198
RE: Search part of string within part of string

Don't all these groups have some sort of registered group number that would be mostly immutable? If not, then I suggest you make one because there's no way 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)

August 22, 2010 at 8:07 pm

#1210196
RE: XP_cmdshell DIR

SwePeso (8/22/2010)
Perhaps the file size is more than 2GB?
Anyways, have you tried using SQLCLR for this?
Yep... that could certainly be it. There are other things we can do. ...
--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)

August 22, 2010 at 8:01 pm

#1210195
RE: tsql retrieve records on date

Ah... apologies. I see that Remi already posted such a comment. I've really got to learn to read a whole thread before posting.
--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)

August 22, 2010 at 7:49 pm

#1210194
RE: tsql retrieve records on date

Kingston Dhasian (8/22/2010)
One more solution to your problem
SELECT * FROM holidays WHERE DATEDIFF( DAY, freedate, GETDATE() ) = 0
The below mentioned article might be helpful to you
http://www.sqlservercentral.com/articles/T-SQL/65806/
Ummm... no. Sorry,...
--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)

August 22, 2010 at 7:48 pm

#1210193
RE: array & multilist

harshinderkaur (8/22/2010)
the syntax for using array & multilist as given in d dbms book korth does NOT 🙁 work in mysql or in msql 2000. anyone has any idea how...
--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)

August 22, 2010 at 7:41 pm

#1210192
RE: Disk configuration for TempDB

If TempDB is "used heavily" as you say, then a spindle per CPU would be really good but... the big thing is to get that log file off those disks...
--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)

August 22, 2010 at 7:38 pm

#1210191

Viewing 15 posts - 37,171 through 37,185 (of 59,098 total)