Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,021 through 10,035 (of 59,093 total)

RE: Job fails but Job History shows success

triloba - Thursday, January 17, 2019 12:36 PM
We had an undetermined network issue last night. Multiple database backup jobs (full & Trans...
--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 17, 2019 at 10:21 pm

#2019327
RE: Sessions blocked in chain loop

askcoffman - Thursday, January 17, 2019 4:02 PM
askcoffman - Thursday, January 17, 2019 2:11 PM
--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 17, 2019 at 10:16 pm

#2019326
RE: Sessions blocked in chain loop

Sue_H - Thursday, January 17, 2019 3:20 PM
askcoffman - Thursday, January 17, 2019 2:11 PM
--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 17, 2019 at 10:08 pm

#2019325
RE: Number of employees active per date

astrid 69000 - Thursday, January 17, 2019 1:20 PM
Hi,
I have a very simple table

create table #employee
(
EmpNumber int,
HireDate datetime,
TerminationDate datetime
)
insert into...
--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 17, 2019 at 9:44 pm

#2019323
RE: Number of employees active per date

Duplicated post deleted.
--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 17, 2019 at 9:43 pm

#2019322
RE: Performance Issue with Simple Query /Big Tables

You're trying to return more than 56 million rows to the screen. The machine you're doing the query from has simply run out of memory.
Also, 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 17, 2019 at 9:01 pm

#2019319

RE: SQL Query Help - PIVOT or CROSS APPLY?

amy26 - Thursday, January 17, 2019 8:20 PM

Hi, I have a dataset that looks like this:

CREATE TABLE [dbo].[PivotData](
[PayPlan] [nvarchar](255) NULL,
[CategorySubGroupCode]...

--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 17, 2019 at 8:51 pm

#2019317

RE: Why do we use SQL limitations? Which constraints can we use while making a database in SQL?

Sue_H - Thursday, January 17, 2019 4:01 PM

drew.allen - Thursday, January 17, 2019 1:15 PM

--Jeff Moden

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 17, 2019 at 7:43 pm

#2019314

RE: T-SQL Multiple Rows into One Row

SQL Espo - Wednesday, January 16, 2019 11:16 AM

I have the following rows

UserShiftID

--Jeff Moden

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 16, 2019 at 7:25 pm

#2019175

RE: T-SQL Multiple Rows into One Row

drew.allen - Wednesday, January 16, 2019 1:17 PM

patrickmcginnis59 10839 - Wednesday, January 16, 2019 12:45 PM

--Jeff Moden

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 16, 2019 at 7:18 pm

#2019174

RE: Large Suspect Database

Luke L - Wednesday, January 16, 2019 2:49 PM

In the end as we were heading toward the end of the business day,...

--Jeff Moden

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 16, 2019 at 7:04 pm

#2019173

RE: Fun with Dates and Times

bdcoder - Wednesday, January 16, 2019 8:32 AM

I have been programming for over 40 years now and for the life of me...

--Jeff Moden

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 16, 2019 at 6:49 pm

#2019172

RE: Session stuck in killed\roll back

Feivel - Wednesday, January 16, 2019 12:15 PM

Jeff Moden - Wednesday, January 16, 2019 8:49 AM

--Jeff Moden

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 16, 2019 at 5:52 pm

#2019169

RE: Run New PowerShell Process As A Different User

Coozie - Wednesday, January 16, 2019 6:44 AM

Summary:
I'm trying to automate a process.
In the process I create sql credentials and a...

--Jeff Moden

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 16, 2019 at 5:49 pm

#2019168

RE: Session stuck in killed\roll back

This sound symptomatic of a problem we had last year. Simple SELECTs getting stuck and going into a KILLED/ROLLBACK that couldn't be killed. It crippled us a couple of times...

--Jeff Moden

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 16, 2019 at 8:49 am

#2019104

Viewing 15 posts - 10,021 through 10,035 (of 59,093 total)