Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,751 through 12,765 (of 59,095 total)

RE: Database Restore Failing

goher2000 - Friday, March 9, 2018 1:31 PM
you can probably avoid additional resources used by power-shell by simply mapping the drive 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)

March 9, 2018 at 2:13 pm

#1982675
RE: Help with Dynamic SQL in Store Procedure

twin.devil - Friday, March 9, 2018 12:43 AM
Whole point of creating a dynamic query is to avoid this kind of scenario. So...
--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)

March 9, 2018 at 1:43 pm

#1982672
RE: Need a Report Developed

ak08820 - Friday, March 9, 2018 8:17 AM
I posted about the status of the job I needed so that others would not...
--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)

March 9, 2018 at 10:30 am

#1982631
RE: Need a Report Developed

ak08820 - Friday, March 9, 2018 4:23 AM
Hello All
I am working with someone on this and no longer seeking quotes.
Thanks
"Perfect". That means...
--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)

March 9, 2018 at 7:55 am

#1982610
RE: Fill in gaps between 2 dates

John Mitchell-245523 - Friday, March 9, 2018 2:56 AM
Jeff Moden - Thursday, March 8, 2018 9:57 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)

March 9, 2018 at 7:15 am

#1982607
RE: Fill in gaps between 2 dates

jcelko212 32090 - Thursday, March 8, 2018 7:18 AM
Jeff Moden - Wednesday, March 7, 2018 2:12 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)

March 8, 2018 at 9:57 pm

#1982575
RE: Moving or adding tempdb files best practice

bwelch42 - Wednesday, March 7, 2018 8:05 AM
On some database server VMs, I'm seeing regular messages about tempdb data files such 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)

March 8, 2018 at 11:38 am

#1982532
RE: What non-database skills should a DBA have?

nscd - Thursday, March 8, 2018 12:19 AM
Thanks for all the input everyone. What I've realized reading all this is that 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)

March 8, 2018 at 10:58 am

#1982518
RE: Index Framentation

Lj Burrows - Thursday, March 8, 2018 1:56 AM
here is How to Reduce Fragmentation: http://www.sqlserverlogexplorer.com/how-to-find-database-fragmentation/
--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)

March 7, 2018 at 2:00 pm

#1982298
RE: Generate UserName from Existing table

yogi123 - Wednesday, March 7, 2018 1:22 PM
Michael L John - Wednesday, March 7, 2018 1:15 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)

March 7, 2018 at 1:58 pm

#1982297
RE: Must-have hands-on reports for SQL Server DBA

Alejandro Santana - Tuesday, March 6, 2018 1:44 PM
Hello!
I'm fairly new to SQL Server and i have been wondering if you guys...
--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)

March 7, 2018 at 11:31 am

#1982274

Viewing 15 posts - 12,751 through 12,765 (of 59,095 total)