Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,141 through 37,155 (of 59,072 total)

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

GilaMonster (8/23/2010)
Jeff Moden (8/22/2010)
There's one I didn't know. Have a got a Paul or MS link for that?
Got a Paul link (or three).
http://sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Anatomy-of-a-record.aspx
http://sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Anatomy-of-a-page.aspx
http://sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-27-How-does-the-storage-engine-find-variable-length-columns.aspx
Everything in his category 'On disk structures'...
--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:54 am

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

You can't really use regular expressions in SQL Server unless you do an SQLCLR.
The real problem here is that even if you can get it to make human-like decisions, even...
--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:53 am

#1210380
RE: Linking to the Previous Row

niyinks (8/23/2010)
Hi
The table above identifies my problem, it reuses the end date and start date. Thus having multiple entries for a date instead of having a few entries only...
--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:47 am

#1210379
RE: Do you advise to apply Recomendations given by DTA?

GilaMonster (8/23/2010)
Jeff Moden (8/22/2010)
I'm pretty sure that statistics TIME and IO don't include SQLCLR and I believe they sometimes miss what's happening in UDF's that a query may contain.
Correct on...
--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:40 am

#1210376
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

Viewing 15 posts - 37,141 through 37,155 (of 59,072 total)