Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,881 through 23,895 (of 59,099 total)

RE: Can some pull off this query for me..

Here's one way. The expected indexes are essential.
DECLARE @Emp TABLE
(
Empid INT PRIMARY KEY CLUSTERED,
EmpName VARCHAR(10)
)
DECLARE @Proj TABLE
(
ProjID INT PRIMARY KEY CLUSTERED,
ProjName VARCHAR(10)
)
DECLARE @EmpProj TABLE
(
EmpID INT,
ProjID INT,
PRIMARY KEY CLUSTERED (EmpID,...
--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)

April 11, 2014 at 11:54 pm

#1705511
RE: Convert the stored procedure to "Standard SQL Select"

Nope... it's absolutely solid "advice" in its purest form. You just don't see it, yet. You're worried about solving the problem all at once and can't see 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)

April 11, 2014 at 8:21 pm

#1705505
RE: How Long Before You Upgrade?

The title of the article is "How Long Before You Upgrade"? I think a better question/title might be "How long before you change to a newer version"? While...
--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)

April 11, 2014 at 7:52 pm

#1705502
RE: Convert the stored procedure to "Standard SQL Select"

halifaxdal (4/11/2014)
This is driving people crazy!
There is another sp to be converted and this sp contains loop and lots of calculation. The original sp is working fine and logic is...
--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)

April 11, 2014 at 7:38 pm

#1705501
RE: tst

SQLRNNR (4/11/2014)
Not sure if this is just a test post or if you needed help with the data you posted. Could you clarify please?
It's posted to the "Test forum"...
--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)

April 11, 2014 at 7:33 pm

#1705499
RE: Educational Institution for IT learing

Port1433 (4/11/2014)
Does anyone know where is the best place for taking courses in IT to break into the field for those who arts students. I would like to take SQL...
--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)

April 11, 2014 at 7:25 pm

#1705497
RE: Table Partitioning

todd 87764 (4/10/2014)
Ok the problem has nothing to do with partitioning. I still don't know what the problem is but at least I know partitioning isn't the cause.
If 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)

April 11, 2014 at 7:23 pm

#1705495
RE: how to find the difference between two date time fields in minutes and hours

Becareful using DATEDIFF for the calculation of durations. The difference between 11:59PM and 12:00AM according to DATEDIFF is an hour because DATEDIFF doesn't calculate durations... it simply calculates 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)

April 11, 2014 at 6:44 pm

#1705494
RE: How to create a temp table in a procedure rather than usinh INTO #temptable

Gerald.Britton 28181 (4/11/2014)
One advantage is that Select...Into can lock the database until the insertion is completed.
Across linked servers, yes, and it does put certain shared locks on TempDB that make...
--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)

April 11, 2014 at 6:34 pm

#1705492
RE: Sending data from MS SQL Server do PostgreSQL server using CLR triggers

Gosh... don't do this with a trigger. If the destination can't be reached for some reason, your source system is dead. Also, the scope of the INSERTED 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)

April 11, 2014 at 12:42 pm

#1705451
RE: can you turn off the "feature" that puts the [ and ] around the objects that are dragged or "scripted to" a query window?

No... no setting in SSMS anyway. If I'm doing a lot of such work, I write a macro in word to do it. Copy and paste is pretty...
--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)

April 11, 2014 at 12:36 pm

#1705449
RE: tst

It would be nice if you limited your forum posting tests to just one post that says "Just testing, please ignore". Thanks.
--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)

April 11, 2014 at 12:32 pm

#1705448
RE: How to create a temp table in a procedure rather than usinh INTO #temptable

asita (4/10/2014)
Could somebody please help me, any ideas please...
First, there's no way that I know of to do this and any even educated guess at calculated column widths could easily...
--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)

April 11, 2014 at 8:11 am

#1705312
RE: Why would you create a foreign key and then disable it?

souLTower (4/11/2014)
I have an application that has been around for a long time. Most of the FKs are disabled. referential integrity is being handled through triggers. Why...
--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)

April 11, 2014 at 7:07 am

#1705257
RE: SQL Server 2014 Developer Edition - availability for download ?

Koen Verbeeck (4/2/2014)
Jeff Moden (4/2/2014)
Heh... waiting for SP1. 😉
Good grief, there may be 25 CUs released before they even think about an SP 😉
Heh... gotta give 'em time to get...
--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)

April 10, 2014 at 7:27 pm

#1705091

Viewing 15 posts - 23,881 through 23,895 (of 59,099 total)