Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,741 through 40,755 (of 59,070 total)

RE: How to update a table using multiple joins

Vinay.Gambhir (12/9/2009)
Yes you are right
I was missing the AND in my join...
working fine now.
Thanks
Considering that you wrote the following...
table2.column2 = table2.column2
... I'd recommend you post your code and let's take...
--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)

December 9, 2009 at 8:54 pm

#1090329
RE: Tempdb pefformance problems

Dean Jones-454305 (12/8/2009)
I noticed that select * from #temptable takes around 2 seconds when there is only 1 thread running the query, but as soon as another thread starts, then...
--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)

December 9, 2009 at 8:52 pm

#1090328
RE: What's the best way to change the 'sa' password

As a sidebar, this is one of the reasons why the SA login must never be used, why each DBA should have their own login, and jobs are never associated...
--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)

December 9, 2009 at 8:44 pm

#1090326
RE: How to do a Grouped, Comma Separated List

Hi Fred,
I think you got F1 and F2 mixed up a little in your desired output, but no worries... this will do it...
--===== Create and populate a test 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)

December 9, 2009 at 8:00 pm

#1090322
RE: What do I do now? (have fun with this...)

4 weeks later, she comes up with the following:
Heh... or should I say "Ack!" 🙂 I'll probably catch hell from everyone on this forum for saying so, but...
--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)

December 9, 2009 at 7:30 pm

#1090318
RE: Urgent Help required

I agree... if something is actually "urgent", take a little of your own urgent time to make it possible to respond quickly to your post... read the article Lutz pointed...
--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)

December 9, 2009 at 7:10 pm

#1090312
RE: Query help - Pivot maybe?

qldrobbo (12/9/2009)
Hi,
Say I have two tables
Trades with column TradeId
MapTraders with columns TradeId, TraderId and Type
In the Trades table say I have 1 row with TradeId 1
In the MapTraders table I...
--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)

December 9, 2009 at 7:04 pm

#1090309
RE: It's about Perception

We need to make sure that our systems work with the user, that help the user and make their jobs easier.
Heh... I've been preaching that on this forum for years...
--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)

December 9, 2009 at 6:56 pm

#1090306
RE: Replace cursor with while loop / compare cursor with while loop / optimize cursor

Lynn Pettis (12/9/2009)
If Jeff suggested that you do this, I suggest you figure out how to write the query using a while loop. Give it a shot. 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)

December 9, 2009 at 6:23 pm

#1090298
RE: 32 bit or 64 bit

Lynn Pettis (12/9/2009)
Bru Medishetty (12/9/2009)
Lynn Pettis (12/9/2009)
Krasavita (12/9/2009)
This is what I get:
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c)...
--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)

December 9, 2009 at 6:04 pm

#1090297
RE: Can anyone verify this please??

After seeing that code, my immediate recommendtion would be to lookup INSERT/SELECT in Books Online (instead of INSERT/VALUES) so that when someone explains how to fix this, you'll actually understand....
--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)

December 9, 2009 at 6:02 pm

#1090295
RE: Are the posted questions getting worse?

CirquedeSQLeil (12/9/2009)
Steve Jones - Editor (12/9/2009)
I think crystal balls work better than ouji boards. Especially when you drop them on someone's foot to emphasize a point.
Dropping only provides limited emphasis...
--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)

December 9, 2009 at 5:45 pm

#1090290
RE: Are the posted questions getting worse?

Jack Corbett (12/9/2009)
Had a great time meeting Gus last night at our December OPASS meeting. He did a great job presenting on Auditing and Logging based on his articles...
--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)

December 9, 2009 at 5:42 pm

#1090289
RE: Are the posted questions getting worse?

Grant Fritchey (12/9/2009)
I always forget this one. How do you flip the "run faster" switch to the on position in SQL Server?
BWAA-HAAA!!! Whenever I get a "make SQL 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)

December 9, 2009 at 5:38 pm

#1090288
RE: Training for those new to SQL

Heh.. triply rude on halane's part then. I wonder if halane likes pork chops. 😉 Thanks Gift.
--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)

December 8, 2009 at 6:20 pm

#1089609

Viewing 15 posts - 40,741 through 40,755 (of 59,070 total)