Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,766 through 45,780 (of 59,095 total)

RE: Share data (Parameters) between datasets in SSRS 2005

No need for a variable, at all...
SELECT SiteName
FROM db2.dbo.Customer c2
INNER JOIN db1.dbo.Site s1
ON c2.SiteName = s1.Debnr
WHERE s1.Name...
--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)

January 19, 2009 at 7:22 pm

#929448
RE: Looking for a godd SQL Server Specific Tutorial

All of that information is available in Books Online, as well.
--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)

January 19, 2009 at 7:15 pm

#929446
RE: BEGIN Commit trans

SET XACT_ABORT ON
--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)

January 19, 2009 at 7:14 pm

#929445
RE: Quick Question about Using Functions, creates 30k lines in profiler

I'll also add that unless your database has been set to be case sensitive, then you don't need the extra overhead of all the UPPER() functions...
--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)

January 19, 2009 at 7:10 pm

#929444
RE: View became incorrect when fields added to table

Not sure it's appropriate for all of this, but if you mearly add columns to a table and the view doesn't need to be changed because it doesn't use 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)

January 19, 2009 at 7:05 pm

#929442
RE: How to use Bulk insert with file format "" and with out in cvs file

Yes... create a format file. \" is the escape character for a single quote in the delimiter column. First character in the datafile must have a length of 1...
--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)

January 19, 2009 at 6:39 pm

#929437
RE: Truncate Referenced Table

Tim.Wilson-Brown (1/19/2009)
Is there any reason why you used NVARCHAR(128) rather than SYSNAME?
SYSNAME would make the script more portable between versions - and enforce restrictions on content.
I agree that SYSNAME would...
--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)

January 19, 2009 at 6:36 pm

#929436
RE: Release memory to OS

Karthikeyan.Ponniah (1/19/2009)
Hi my DB is 130GB and one of the tables is 40GB. I doesnt need this table for test environments; hence I truncated or even dropped the table. 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)

January 19, 2009 at 6:26 pm

#929435
RE: create view problem

Sorry... you can't have "control of flow" statements like "IF" in a view.
It could, however, be easily accomplished in a stored procedure and then you could use the result of...
--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)

January 19, 2009 at 6:20 pm

#929433
RE: Question whit bulk copy

I believe the file name needs to be in quotes, folks.
--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)

January 19, 2009 at 6:11 pm

#929431
RE: Disable and enable trigger

Yes... there is. Please see "Enable Trigger" and "Disable Trigger" in Books Online.
Also, I'd be very, very wary of doing such a thing. The tirgger(s) were put on...
--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)

January 19, 2009 at 6:09 pm

#929430
RE: Why do people need to do this?

john.arnott (1/19/2009)
I've had to present a "best guess" at matching events from two data sources. Each source provides a subject identifier that tells where a package came from, 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)

January 19, 2009 at 5:58 pm

#929429
RE: Why do people need to do this?

Jacob Luebbers (1/19/2009)
Hey Jeff,
Not sure if you're including "running sum" or similar problems in your question...? If so, a common reason for needing that in my experience...
--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)

January 19, 2009 at 5:52 pm

#929428
RE: Are the posted questions getting worse?

Jack Corbett (1/19/2009)
K. Brian Kelley (1/19/2009)
GilaMonster (1/19/2009)
Jack Corbett (1/19/2009)
That's probably my favorite feature of the google toolbar, spell checking just like in Word.
Firefox has that built in. Why do 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)

January 19, 2009 at 5:00 pm

#929423
RE: Are the posted questions getting worse?

GilaMonster (1/19/2009)
🙂 and I'm in the middle of writing a blog rant titled "Bad Advice". It's funny when lots of people write on similar topics at once.
Maybe not so funny......
--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)

January 19, 2009 at 4:58 pm

#929422

Viewing 15 posts - 45,766 through 45,780 (of 59,095 total)