Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,616 through 27,630 (of 59,101 total)

RE: pass variables between SQL Server tasks in a JOB

Thanks for the feedback. But, remember, this was supposed to be done in a job with multiple steps without the use of SSIS. The global variables there do...
--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 28, 2013 at 4:20 pm

#1581842
RE: Antipathy for Entity Attribute Value data models

BillyJack (1/23/2013)
long_shanks64 (1/23/2013)
What percentage of a typical organisations attributes are not known at initial design time? Typically less than 5% - in which case why compromise a physical design for...
--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 28, 2013 at 4:15 pm

#1581839
RE: Create string using input values

Sql Student-446896 (1/25/2013)
Hi,
I have a beginning Year and a End year and i have to compute/create a string based on the given years.
Example:
Input: BegYr = 2013 and EndYr = 2015
Output:...
--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 28, 2013 at 12:18 am

#1581424
RE: Create string using input values

C'mon, folks! Just look at the mess of code that a While loop makes for this! No one should be writing a While Loop for this!
--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 28, 2013 at 12:16 am

#1581423
RE: Computed column with/with out PERSISTED

My personal opinion is that if you're not going to persist a calculated column, write a derived table or view, instead. That way, no one can screw up 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)

January 28, 2013 at 12:07 am

#1581421
RE: plz i need help!!!!

No need for CASE here at all.
SELECT Name,
Total = ISNULL(Salary,0) + ISNULL(Bonuses,0)
FROM dbo.YourTable
;
If you insist on ANSI/ISO code,...
--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 27, 2013 at 11:55 pm

#1581419
RE: Stored procedure explanation

It would appear that a table variable is being populated based on a While Loop. The While Loop is based on the comma separated values that come in 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 27, 2013 at 11:46 pm

#1581418
RE: SQL SERVER CPU Usage 100 % even at no traffic time

Sure... open task manager and see what's using all of that CPU. If it IS actually SQL Server, then you probably have a "busted spid" trying to do a...
--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 26, 2013 at 9:12 pm

#1581353
RE: Running a batch job in a sql stored proc

andy.westgate (1/25/2013)
We have someone who executes a batch job the result of which is some data is moved from txt files into sql tables based on a couple of bits...
--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 26, 2013 at 9:06 pm

#1581352
RE: getting total disk space

mani@123 (1/22/2013)
SERVER2008:
declare @svrName varchar(255)
declare @sql varchar(400)
--by default it will take the current server name, we can the set the server name as well
set @svrName = @@SERVERNAME
[font="Arial Black"]set @sql = 'powershell.exe...
--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 26, 2013 at 8:12 pm

#1581349
RE: Not Pulling the Plug Out

Phil Factor (1/26/2013)
I have to agree that anything to do with SQL Server is entirely unsafe in the hands of the VS team, considering that the culture there is so...
--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 26, 2013 at 8:04 pm

#1581348
RE: Not Pulling the Plug Out

Jim P. (1/26/2013)
It is the incompetent DBA that...
Let's put some quality back in the title of "DBA". Whether they have the actual title or not, there are actually no...
--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 26, 2013 at 8:01 pm

#1581347
RE: Import Excel using OPENROWSET only works for SA

Long time no see, ST.
Who is the actual database owned by? If it's (hopefully) someone with "SA" privs, try adding WITH EXECUTE AS OWNER to the stored procedure...
--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 26, 2013 at 7:49 pm

#1581346
RE: How to copy the ER diagram from SQL server 2008

arthi.anan (1/21/2013)
I generated the ER diagrams but the tables are listed individually [font="Arial Black"]without any connectivity among them[/font].
Do you have any Foreign Keys between the tables? If not, you're...
--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 26, 2013 at 7:38 pm

#1581344
RE: where did 3 m seconds go?

ekant_alone (1/25/2013)
i have attached an image with this thread. my application is using jdbc drives. same operation in oracle is taking 3 secs but in SQL server it is taking...
--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 26, 2013 at 7:11 pm

#1581343

Viewing 15 posts - 27,616 through 27,630 (of 59,101 total)