Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,441 through 16,455 (of 59,067 total)

RE: Azure certification for SQL DBA

tauseef.jan (10/30/2016)
Hello,
I know this is an off topic post, but please help me out.
I am a sql server dba with 10 years exp. I wanted to expand my skillset as...
--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)

October 30, 2016 at 4:42 pm

#1909528
RE: Are the posted questions getting worse?

Shifting gears back to the subject of SPAM on these forums...
It would appear that the only thing that the "user" known as "Wryan138" ever does is report spam. 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)

October 30, 2016 at 4:38 pm

#1909527
RE: Completing Fixed Sets With Another Table

sys.user (10/30/2016)
Jeff Moden (10/30/2016)
sys.user (10/30/2016)
Jeff Moden (10/30/2016)
What is your "week" based on", especially for the first and last week of the year where it's normally not a 7 day week?...
--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)

October 30, 2016 at 4:18 pm

#1909526
RE: Completing Fixed Sets With Another Table

Since you're working with ISO Weeks, the following won't only help you with this particular problem but could also provide some help for you in the future. Hopefully, 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)

October 30, 2016 at 4:06 pm

#1909525
RE: Completing Fixed Sets With Another Table

K. Working on a set-based method...
--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)

October 30, 2016 at 1:23 pm

#1909522
RE: Completing Fixed Sets With Another Table

sys.user (10/30/2016)
Jeff Moden (10/30/2016)
What is your "week" based on", especially for the first and last week of the year where it's normally not a 7 day week? Also, 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)

October 30, 2016 at 10:49 am

#1909519
RE: Completing Fixed Sets With Another Table

sys.user (10/30/2016)
Hi,
I'm having some trouble finding a solution to a problem, its been a few hours now and I think I just completely loose track of what I'm doing 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)

October 30, 2016 at 10:13 am

#1909517
RE: sql backup

In order to say the backup was "complete", you would also have to include the time it takes to move the file from the local disk to the final resting...
--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)

October 30, 2016 at 10:06 am

#1909516
RE: HELP! I've got to give a talk to our local .NET geek meet on SQL server

aaron.reese (10/30/2016)
Agreed. but when you are prototyping it is very likely that you don't have the full story from the business, especially where they need to persist changes in entities...
--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)

October 30, 2016 at 8:32 am

#1909513
RE: SQL help - how to write a query with reference to its own results

sanda.jan00 (10/29/2016)
This is my attempt but it doesn´t work :-/ :
SELECT PRO.id, PRO.days_a_mat AS days_current, sub1.tot_max_days , sub2.tot_date
FROM PRODUCTS as PRO,
(SELECT id, max(days_a_mat) as tot_max_days FROM products AS PRO2...
--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)

October 30, 2016 at 7:49 am

#1909512
RE: Stop query if it is taking too long

Sergiy (10/29/2016)
Eirikur Eiriksson (10/29/2016)
Jeff Moden (10/24/2016)
Eirikur Eiriksson (10/24/2016)
you will need this index on the dbo.Transaction
CREATE UNIQUE NONCLUSTERED INDEX [INDEX_NAME] ON [dbo].[Transaction]
(
[InvoiceUID] ASC,
[IsSuccess] ASC,
[TransKind] ASC,
[TransactionDate] ASC
)
INCLUDE ( [CardNumber],[ReferenceNumber],[SeqCounter],[UnqReferenceNumber]);
I came up...
--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)

October 29, 2016 at 9:43 pm

#1909504
RE: SQL help - how to write a query with reference to its own results

sanda.jan00 (10/29/2016)
Ed Wagner (10/29/2016)
sanda.jan00 (10/29/2016)
Hi,
could anybody help me please with this:
I would like to write a query which retrieves this information: id , days_a_mat (days after maturity) from...
--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)

October 29, 2016 at 1:53 pm

#1909496
RE: Huge tempdb log file

Ed Wagner (10/29/2016)
Something happened to blow out your tempdb. You may not know what it was yet, but you can be sure that it didn't just happen by itself....
--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)

October 29, 2016 at 11:27 am

#1909490
RE: Stop query if it is taking too long

mah_j (10/29/2016)
I created both indexes,but when I run the query ,it uses non of them.
No matter which indexes you use, you have to do a check to make sure that...
--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)

October 29, 2016 at 11:23 am

#1909489
RE: Speeding Up Delete's on Large Databases

Ok... here we go. First, let's make the understanding that if you only want to keep 1 year of data, you should do deletes every day instead of having...
--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)

October 29, 2016 at 11:14 am

#1909488

Viewing 15 posts - 16,441 through 16,455 (of 59,067 total)