Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,716 through 47,730 (of 59,095 total)

RE: Fill factors, index fragmentation and indexing strategy

Sorry... the day's coffee is wearing off. 🙂 I didn't read all of your last...
You're correct. Since the rows are going to be added on a onesy basis,...
--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)

October 15, 2008 at 9:58 pm

#885623
RE: Fill factors, index fragmentation and indexing strategy

Matt Miller (10/15/2008)
Jeff Moden (10/15/2008)
In that case, I'd use a FILL Factor of 100 for that tiny bit more speed on any SELECTS you may do on the table.
True -...
--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)

October 15, 2008 at 9:48 pm

#885619
RE: Random number generator

rbarryyoung (10/15/2008)
So that's in-between LGD and Cryptographic? And I don't see any varbinary(MAX) or sql_variant data-types. 😀
Heh... no... It's somewhere in between a pork chop and a chicken...
--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)

October 15, 2008 at 9:46 pm

#885617
RE: Fill factors, index fragmentation and indexing strategy

In that case, I'd use a FILL Factor of 100 for that tiny bit more speed on any SELECTS you may do on 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)

October 15, 2008 at 7:20 pm

#885600
RE: Finding records based on a value from consecutive date records

Garadin (10/15/2008)
This solution is a variation of Jeff Moden's Running Total Technique, which can be found here:
http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
Thanks for the "pass back", Seth. After Matt's index suggestion, looks like you've...
--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)

October 15, 2008 at 7:15 pm

#885599
RE: difference

David O (10/15/2008)
Once you get your formatting issues fixed the function is datediff. Check out Books on line for the details of the function.
Actually, once converted, you can just...
--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)

October 15, 2008 at 7:02 pm

#885598
RE: Monitoring processes

According to the following...
http://msdn.microsoft.com/en-us/library/aa258866(SQL.80).aspx
... the Test returned is of the data type TEXT which can contain up to 2 billion characters. But, the largest "column width" you can set...
--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)

October 15, 2008 at 6:58 pm

#885597
RE: Help needed filling in values based on previous row

Marianne,
Actually, I'd be very interested in the performance of the queries. Could you tell us how many rows ended up in the table and how many of them had...
--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)

October 15, 2008 at 6:49 pm

#885594
RE: Need help using Cross Apply together with Group By

eric (10/15/2008)
Nevermind.....I found my mistake....after 3 hours. I tried to delete the post but it's not working !
Would you mind telling us what your mistake was? Might save...
--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)

October 15, 2008 at 6:16 pm

#885591
RE: Random number generator

sudrav (10/15/2008)
Ok.Guys I need your help. I have a table of about 60000 records. I want to add a column say random number and store it in the table
1. ...
--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)

October 15, 2008 at 6:15 pm

#885590
RE: SQL library - best practices

The way you deal with different coding styles is by insisting that there only be one coding style. Publish and enforce a set of standards including such arcane 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)

October 15, 2008 at 6:08 pm

#885588
RE: how to eliminate double quotes for column headers in flatfiledestination

I guess I don't understand... what's wrong with having the double quotes in the column headers? That's how a true CSV file should be formed.
--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)

October 15, 2008 at 6:02 pm

#885587
RE: CPU 100% and critical

we had a similar problem just last week. Couldn't explain it and still can't. All I know is that we stopped SQL Server Agent and restarted 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)

October 15, 2008 at 5:59 pm

#885586
RE: Import CSV data into a table in SQL Server 2005 CE

GAURAVKAUSHIK26 (10/14/2008)
Thanks for response. Can you please provide me any code or syntax that imports csv/txt file into SQL CE without SSIS/DTS.
Sure... if the file has no company private or...
--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)

October 15, 2008 at 11:44 am

#885386
RE: Functio to get Amount in words.

Yep... I agree, Kevin... especially if you have a function like "ToWords". That and RegEx Replace seem to be pretty good.
--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)

October 15, 2008 at 8:14 am

#885237

Viewing 15 posts - 47,716 through 47,730 (of 59,095 total)