Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,121 through 42,135 (of 59,102 total)

RE: temp db size

Ugh! Sorry George... I'm not so hot at finding the cause of a memory leak. If you monitor the memory in the Windows side of the server, you...
--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)

September 3, 2009 at 5:49 pm

#1049154
RE: Putting all your data in one column of one table

What was the failed project supposed to accomplish?
--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)

September 3, 2009 at 5:39 pm

#1049151
RE: Remove leading zeros and add spaces at the end

chris.fauvel (9/3/2009)
if your skus are like
00supra12-23
0012-34
00001234
then casting to int will not work since 'supra' and '-' are not numeric.
I precisely need to do the same thing , remove the leading...
--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)

September 3, 2009 at 5:32 pm

#1049149
RE: Remove leading zeros and add spaces at the end

Garadin (9/3/2009)
Jeff anticipated this question 18 months ahead of time and it STILL didn't stop it :-D.
BWAA-HAAA!!!! Ironically, the same thing happens at work!
Man, thanks for both...
--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)

September 3, 2009 at 5:29 pm

#1049148
RE: Putting all your data in one column of one table

michael.welcome (9/3/2009)
Update:
The project was a huge failure as I expected.
Heh... "So say we all." Thanks for the feedback. Most don't remember.
Now that the patient has died, my question...
--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)

September 3, 2009 at 5:07 pm

#1049139
RE: temp db size

George Nak (9/3/2009)
The size of the log file has never exceeded the 500 MBs , for tempdb,.
Now for the job itself.
The thing is that when the job is running and...
--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)

September 3, 2009 at 4:58 pm

#1049132
RE: If you weren't a DBA what would you be doing?

John Rowan (9/3/2009)
I'd be a full time parent, no questions asked.
Heh... same as a DBA. 😛
--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)

September 3, 2009 at 3:00 pm

#1049099
RE: How To Get Table Row Counts Quickly And Painlessly

TheSQLGuru (9/3/2009)
>>I just didn't want people that were going to write a script in 2k for this to even think about using a (ugh!) cursor or While Loop to get...
--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)

September 3, 2009 at 8:11 am

#1048762
RE: temp db size

George Nak (9/3/2009)
The size of the db was limited to 8 GB with the log file to increase by 512 MB and the data file for 2048 MBs
Hi George,
To also...
--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)

September 3, 2009 at 6:36 am

#1048679
RE: How To Get Table Row Counts Quickly And Painlessly

Kendal,
Drat... I didn't say it in my first response (not enough coffee). Kudos on the article. It was well written and clear. And, you managed to get...
--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)

September 3, 2009 at 6:26 am

#1048675
RE: How To Get Table Row Counts Quickly And Painlessly

Paul,
Heh... oh no... I agree... sys.dm_db_partition_stats in 2k5 is the berries especially on mega-row tables. And, you beat me to it on the OBJECT_ID thingy to help eliminate...
--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)

September 3, 2009 at 6:23 am

#1048673
RE: CLR initialization permanently failed

Tim Peters (9/2/2009)
Hi All,
I'm having a problem with CLR failing on a server and with little CLR development experience I'm not sure where to look next. We have one 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)

September 2, 2009 at 8:03 pm

#1048513
RE: Long running query - out of ideas

tvanharp (9/2/2009)
Created a query that selects about 400,000 rows.
Initially query was setup to select a couple columns and completed in about 7 seconds. The query used a non-clustered seek....
--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)

September 2, 2009 at 7:58 pm

#1048512
RE: temp db size

George Nak (9/2/2009)
we have an sql cluster 2000 and i want to change the tempdb size to its original settings
For a lot of reasons, that's probably the worst thing you...
--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)

September 2, 2009 at 7:55 pm

#1048511
RE: If you weren't a DBA what would you be doing?

SQL Iron Chef (9/2/2009)
What would you guys be doing if you werent DBAs or if databases didn't exist?
In this economy? Probably looking for a job. 😉
--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)

September 2, 2009 at 7:49 pm

#1048508

Viewing 15 posts - 42,121 through 42,135 (of 59,102 total)