Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,746 through 8,760 (of 59,091 total)

Reply To: Always on and Ola Hallengren SQL Agent Jobs.

You should ask Ola. 😉 He wrote it.
--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)

August 31, 2019 at 3:23 am

#3675969
Reply To: PASS Summit

What is the "Buddy Program"? Sharing a hotel room?
--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)

August 31, 2019 at 3:22 am

#3675968
Reply To: SQL Query between 2 dates

dataprotec wrote:
Hello
I'm working on programm for presence control
e.g
ID -      CheckIn                       - CheckOut
1     29/08/2019 10:00  --   29/08/2019 14:00
2     29/08/2019 22:00 --   30/08/2019 06:00
3     30/08/2019 10:00   --  30/08/2019 14:00
If i do a query...
--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)

August 31, 2019 at 3:21 am

#3675967
Reply To: Memories of DR testing

Really good article that covered a whole lot. The high point is how managers want everything but don't want to pay anything. I also believe that capital expenditures shouldn't be...
--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)

August 31, 2019 at 3:16 am

#3675966
Reply To: Reset the total to zero when ItemCount is >= 6

jcelko212 32090 wrote:
Did you know that a table must have a key by definition? It is not an option!
Actually, it IS an option. HEAPs work just fine for things like Audit...
--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)

August 31, 2019 at 2:51 am

#3675963
Reply To: Reset the total to zero when ItemCount is >= 6

jcelko212 32090 wrote:
>> I want to have a sum of the item count reset to 0 when the sum >= 6. <<
Did you know that a table must have a key...
--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)

August 31, 2019 at 2:32 am

#3675962
Reply To: Error with IDENTITY property on primary key column

jcelko212 32090 wrote:
my guess is that your table should look something like this:
CREATE TABLE Personnel
(employee_id CHAR(5) NOT NULL PRIMARY KEY,
employee_type CHAR(1) NOT NULL
CHECK (employee_type IN (???),,
employee_name VARCHAR(30) NOT NULL);...
--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)

August 31, 2019 at 2:24 am

#3675957
Reply To: Error with IDENTITY property on primary key column

jcelko212 32090 wrote:
I hope you understand that the old Sybase IDENTITY table property (property -- it is not a column) can never by definition be a valid key. It is 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)

August 31, 2019 at 2:06 am

#3675953
Reply To: System tables, System base tables and base tables

Microsoft actually does make a distinction between "System Base Tables" and "System Tables". Please see the articles at the following links for more information...
https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/system-base-tables?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/system-tables-transact-sql?view=sql-server-2017
There are also "System Views"...
--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)

August 31, 2019 at 1:56 am

#3675952
Reply To: A DateRange Table Valued function

Aaron N. Cutshall wrote:
Jeff Moden wrote:
IMHO, the closest thing to a CROSS APPLY is a "Correlated Sub-Query" with an implicit join, which can return more than one row per input row if 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)

August 30, 2019 at 1:29 pm

#3675723
Reply To: update query help

It would appear that the OP has flown the coop instead of answering the question I posed.
--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)

August 30, 2019 at 4:19 am

#3675613
Reply To: A DateRange Table Valued function

IMHO, the closest thing to a CROSS APPLY is a "Correlated Sub-Query" with an implicit join, which can return more than one row per input row if you're not careful...
--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)

August 30, 2019 at 4:14 am

#3675611
Reply To: Should Salary Information Be Confidential?

Eric M Russell wrote:
When job hunting, I'm point blank with potential employers or recruiters about what my current salary is. The way I see it, if either party can't match the expectations...
--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)

August 29, 2019 at 1:44 pm

#3675432
Reply To: Should Salary Information Be Confidential?

x wrote:
There are awesome people on this site. There are also some not so awesome people on this site, and heck maybe I'm not one of the awesome people 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)

August 29, 2019 at 12:59 pm

#3675402
Reply To: Cumilative update

It will vary depending on what the CU is and does. If the documentation for the CU doesn't contain that information, then there's no way to predetermine it.
--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)

August 29, 2019 at 12:40 pm

#3675395

Viewing 15 posts - 8,746 through 8,760 (of 59,091 total)