Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,971 through 35,985 (of 59,099 total)

RE: Little Devices

Grant Fritchey (11/22/2010)
Jeff Moden (11/22/2010)
I just don't ever want to be that "productive". Down-time is very important to me.
What is this "down-time" of which you speak?
Heh... yeah... I know...
--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)

November 22, 2010 at 7:29 pm

#1254151
RE: Little Devices

I just don't ever want to be that "productive". Down-time is very important to me.
--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)

November 22, 2010 at 3:15 pm

#1254089
RE: tempdb

I guess my question would be, what are you doing where you'd ever need almost a T-Byte of TempDB? What's the total MDF/LDF size for that server?
--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)

November 22, 2010 at 3:14 pm

#1254088
RE: need help with loading a string

kevin4u06 (11/22/2010)
There is one more added complexity , in some recordds the state has for example
Arizona
New Jersy
instead of just their abbreviation
Build a table of long names and short names 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)

November 22, 2010 at 3:09 pm

#1254086
RE: How to repeat/or duplicate my results?

GSquared (11/22/2010)
churlbut (11/22/2010)
Here is one way of doing it:
DROP TABLE #Temp
DECLARE @X int
SET @X = 1
CREATE TABLE #Temp (Phone varchar(17) null)
WHILE @X < 101
BEGIN
INSERT INTO #Temp(Phone) select Phone from People...
--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)

November 22, 2010 at 2:00 pm

#1254038
RE: deleting huge records From Table

Sachin Nandanwar (11/22/2010)
Jeff Moden (11/22/2010)
I agree. Just to be clear for folks that may think of doing it, don't ever shift from FULL recovery to SIMPLE recovery for the...
--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)

November 22, 2010 at 7:57 am

#1253751
RE: Averaging data streaks

Sachin Nandanwar (11/22/2010)
keymoo (11/22/2010)
Thanks it doesn't give me the correct results for dates that are the same. Is there a tweak needed to do that?
Please post some sample data 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)

November 22, 2010 at 7:53 am

#1253746
RE: deleting huge records From Table

Eralper (11/22/2010)
Thanks Jeff,
I checked the BOL and I found :
The amount of logging for SELECT...INTO depends on the recovery model in effect for the database. Under the simple recovery model...
--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)

November 22, 2010 at 6:10 am

#1253686
RE: Dynamic query in a function

S_Kumar_S (11/22/2010)
I dont think you can call a proc from inside a function except extended procs.
So it concludes that there is no simple work around expect if I can find...
--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)

November 22, 2010 at 6:03 am

#1253680
RE: Dynamic query in a function

Heh... yes... ask an "SQL Server 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)

November 22, 2010 at 1:01 am

#1253603
RE: deleting huge records From Table

You can get around some of the logging issues by using a SELECT/INTO to copy only the rows you want to keep and then renaming the table(s). Read up...
--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)

November 22, 2010 at 12:49 am

#1253600
RE: two insert statments takes long time to process

Sachin Nandanwar (11/17/2010)
dlam 18073 (11/16/2010)
I dont get it. clientNumber in tblClientList is primary key.
can you tell me abit more in detail. thx!!
Then why are you checking whether the clientNumber exists?If...
--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)

November 22, 2010 at 12:43 am

#1253598
RE: Are the posted questions getting worse?

bitbucket-25253 (11/21/2010)
Thanks Jeff I needed a good laugh. Oh and let me buy you a drink at the Friday night dinner for speakers at SQL Sat#60
It will be my...
--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)

November 22, 2010 at 12:34 am

#1253596
RE: selecting 'next min() date' from a historic recordset

Also, take a look at the article at the first link in my signature below. It'll help you get coded answers on your next post.
--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)

November 21, 2010 at 7:05 pm

#1253562
RE: How to repeat/or duplicate my results?

clarks (11/19/2010)
Nevermind, I got it! I'm a little "Slow" on Friday's. Thanks for the help!:hehe:
That's cool. Would you mind posting your final code so others may learn how 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)

November 21, 2010 at 7:03 pm

#1253561

Viewing 15 posts - 35,971 through 35,985 (of 59,099 total)