Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,471 through 16,485 (of 59,101 total)

RE: sql backup

barsuk (10/30/2016)
Copy part took about 15mins earlier today.
Network Backup takes about 22-24mins for 750GB Database using LiteSpeed Backup.
That's damned good!
--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:58 pm

#1909538
RE: Are the posted questions getting worse?

Wryan138 (10/30/2016)
Hi Jeff,
Nope I'm a real person. I joined up an I've been reading EVERYTHING on the forum for
quite a while. The one thing I have noticed 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 7:26 pm

#1909535
RE: Azure certification for SQL DBA

tauseef.jan (10/30/2016)
hi,
As a DBA I am involved with devising and implementing backup/restore plans, HA/DR solutions, migrating of servers, performance tuning etc.
I have to agree with Gail and, in that vein...
--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:23 pm

#1909534
RE: Azure certification for SQL DBA

tauseef.jan (10/30/2016)
hi,
maybe i did not make myself clear. I wanted to ask that is 70-533 (implementing and deploying azure ) the right career path to take
T
Understood and you made yourself...
--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 5:22 pm

#1909530
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

Viewing 15 posts - 16,471 through 16,485 (of 59,101 total)