Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,091 through 42,105 (of 59,067 total)

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
RE: Update a column of a table row by row in a Stored Procedure ? How To Do ?

sascha (9/2/2009)
Yes Jeff and GSquared, your right its not the smartest solution, to missuse the SQLSever as a "word processor" .
But this time I want to deliver fully formated...
--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 3:18 pm

#1048460
RE: Find data that has not changed for 5 days

riga1966 (9/2/2009)
I have a requirement from a User
to build a report that shows data that did not change for 5 days.
In other words they want to capture "stale data".
Please see...
--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 1:28 pm

#1048404
RE: Update a column of a table row by row in a Stored Procedure ? How To Do ?

Heh... ok... everyone always leaves the hard questions up to me so I'll break the ice on the hard question... 😉
Why are we using SQL Server like a word processor...
--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 1:25 pm

#1048400
RE: Removing Carriage Returns

Carolyn Richardson (9/2/2009)
I use a function and just add in the ASCII character of the item I wish to replace:-
/*-- =============================================
-- Author:Carolyn Richardson
-- Create date: 16th February 2009
-- Description:Clears selected...
--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 11:49 am

#1048321
RE: Removing Carriage Returns

vicky (9/2/2009)
The replace doesn't work directly to the column, with the substring the sentence works
Create Table #tablename(columnname text)
Insert Into #tablename
Select 'Please post
the contents '
Select * From #tablename
Update #tablename 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)

September 2, 2009 at 11:47 am

#1048318

Viewing 15 posts - 42,091 through 42,105 (of 59,067 total)