Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,451 through 42,465 (of 59,067 total)

RE: Master list of tasks for a complete backup

Ummm... not 100% sure but it seems to me that we needed to change the IP address, as well. Maybe that's because we also copied the Windows Server, as...
--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 6, 2009 at 8:31 pm

#1035762
RE: SQL 2000 --> SQL 2008

I'd also recommend doing several tests on a separate box until you get it right. 😉 Once you get it right, schedule an outage so no one can change...
--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 6, 2009 at 8:23 pm

#1035760
RE: date time

Here's how but I need to know... why do you need to do this type of formatting in SQL?
SELECT STUFF(RIGHT(CONVERT(VARCHAR(50),GETDATE(),109),14),9,4,'')
--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 6, 2009 at 8:19 pm

#1035758
RE: Copying & Tracking Data

With the OUTPUT clause, Goldie...
-- goal is to copy over data for specified test
-- need to keep track of which sections map to each other
-- here's the insert
-- but how...
--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 6, 2009 at 8:02 pm

#1035755
RE: Determine Row Size on a Table

Heh... guess what happens when you do a search for the following in Books Online? 😉
[font="Arial Black"]Estimating the Size of a Table [/font]
--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 6, 2009 at 7:43 pm

#1035752
RE: Loyalty Cards

I like the way the "Speedway" service stations did it here in Michigan. You don't have to fill out a bloody thing. They give you a card 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)

August 6, 2009 at 7:36 pm

#1035750
RE: Loop to count

gaj104 (8/6/2009)
Hi,
Maybe I'm missing something here, but why bother with a script?
Simply use the unpivot function and then query as normal:
WITH P
AS (SELECT EMPLOYID,
...
--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 6, 2009 at 7:30 pm

#1035748
RE: Gain Space Using XML data type

Very interesting indeed! Thanks for the great write up, Paul. That certainly puts a different slant on "the rumor".
--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 6, 2009 at 7:08 pm

#1035740
RE: Update column with itself plus value of column in another table -- accumulating?

hugh.hemington (8/6/2009)
Could you recommend a good T-SQL primer?
I have "Wrox Press Beginning T-SQL with Microsoft SQL Server 2005 and 2008"
I looked up "QUOTENAME" in that book, but when the brief...
--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 6, 2009 at 6:06 pm

#1035738
RE: Update column with itself plus value of column in another table -- accumulating?

Don't use the While Loop examples, either. They're nothing but cursors without the word "cursor" in them. Cursors and While Loops are very bad ways to go compared...
--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 6, 2009 at 5:33 pm

#1035735
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/6/2009)
I will sneak a picture of Jeff at some point and post it up here. Don't worry, we'll track him down at some point.
Heh... no fair....
--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 6, 2009 at 3:08 pm

#1035691
RE: Disable and enabling index frequently

Thanks... at work, I'm still stuck in the world of 2k. Haven't really had a chance to dig into that stuff, yet. I appreciate the leg 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)

August 6, 2009 at 3:05 pm

#1035690
RE: Are the posted questions getting worse?

GSquared (8/6/2009)
jcrawf02 (8/6/2009)
That's how I picture Jeff too, a princess in a forest.
[hides]
I'm just hoping to make him shoot soda out of his nose when he reads my 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)

August 6, 2009 at 2:41 pm

#1035671
RE: Are the posted questions getting worse?

jcrawf02 (8/6/2009)
That's how I picture Jeff too, a princess in a forest.
[hides]
Heh... yeah... substitute toothfairy in a pink tutu. 😛
--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 6, 2009 at 2:41 pm

#1035670
RE: Are the posted questions getting worse?

Grant Fritchey (8/6/2009)
GilaMonster (8/6/2009)
Grant Fritchey (8/6/2009)
Jeff Moden (8/6/2009)
I've not confirmed my plane reservations but I'm 99.99% sure that I'm going to be in Lil' Rhody from 9/6 to 9/12. ...
--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 6, 2009 at 1:30 pm

#1035641

Viewing 15 posts - 42,451 through 42,465 (of 59,067 total)