Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,211 through 18,225 (of 59,069 total)

RE: Project ideas for DBA to advance in powershell

Lowell (3/3/2016)
i did a big Powershell documentation initiative.
this script from awhile ago started it:
Powershell script to script out jobs, databases, users, linked servers, logins, roles, alerts, etc from a list...
--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 3, 2016 at 2:19 pm

#1862931
RE: refresh only some tables in a database

tony28 (3/3/2016)
If this is only test server, the data transfer and how much time doesnt matter...
I have to strongly disagree with that. Some poor bugger in a pinch will...
--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 3, 2016 at 2:14 pm

#1862928
RE: Many conditions - best practice

chuck.forbes (3/3/2016)
I'm not familiar with the iTVF's, so I'm following my original thread, and the guru's can correct me ...
Inside your function, you can just write T-SQL code, as 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 3, 2016 at 10:28 am

#1862840
RE: refresh only some tables in a database

tony28 (3/3/2016)
My opinion is still use linked server, but if you dont want to use, I found next solution...
http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D in this article is "Create Some Data"
So create new table or...
--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 3, 2016 at 7:17 am

#1862735
RE: Selecting data from GUI in msdb

Grant Fritchey (3/3/2016)
Jeff Moden (3/2/2016)
sickb00000y (3/2/2016)
The option to do this via SSMS 2014 is disabled on system tables in system databases on any SQL Server (2005+ has been tested). User...
--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 3, 2016 at 7:12 am

#1862733
RE: Rollback if ETL fails

moid.hassan (3/2/2016)
Thanks a lot for your response. I will first try with setting the Transaction Option as required.
Heh... WHY? Are you looking forward to an all-night rollback? 😉
--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 2, 2016 at 10:16 pm

#1862631
RE: How to create a Stored Procedure from this Code

oneteabag (3/2/2016)
...but the challenge is every section is pretty much relying on the output from the previous section.
So why not use the single proc with the 4,000 lines of...
--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 2, 2016 at 10:12 pm

#1862630
RE: refresh only some tables in a database

For each table to be loaded...
1. Rename the table with an "_A" suffix.
2. Make an identical table with an "_B" suffix.
3. Make a synonym with the same name as 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 2, 2016 at 10:03 pm

#1862629
RE: I want to automate my database compression , can anyone provide me the T sql code...

prem.m38 (2/16/2016)
I have few databases in my environment which is 2 TB and 1 TB data and we have partitioned the few tables for better performance and implemented page compression...
--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 2, 2016 at 9:01 pm

#1862626
RE: Project ideas for DBA to advance in powershell

Steve Jones - SSC Editor (3/2/2016)
Certainly some of thsoe can be done with T-SQL, but they fit better, and I'd argue most file operations are better handled in PoSh. Better...
--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 2, 2016 at 7:50 pm

#1862622
RE: Selecting data from GUI in msdb

sickb00000y (3/2/2016)
The option to do this via SSMS 2014 is disabled on system tables in system databases on any SQL Server (2005+ has been tested). User tables in system databases...
--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 2, 2016 at 7:46 pm

#1862621
RE: Many conditions - best practice

SmackMule (3/2/2016)
Separate rows is fine. I'm not trying to make this overly complicated. Perhaps I'm asking a silly question, and I apologize if so. Below is what I'm talking about....
--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 2, 2016 at 7:42 pm

#1862620
RE: Many conditions - best practice

SmackMule (3/2/2016)
OK. I understand the function aspect, but back to my original question, within said function, do I just have a bunch of simple, separate statements, each with their own...
--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 2, 2016 at 7:05 pm

#1862617
RE: Many conditions - best practice

chuck.forbes (3/2/2016)
I would just write a function which returns the string you're interested in:
SELECT serial_number,
fn_error_code(serial_number) as err
FROM t
WHERE fn_error_code(serial_number) 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)

March 2, 2016 at 5:44 pm

#1862613
RE: Project ideas for DBA to advance in powershell

Steve Jones - SSC Editor (3/2/2016)
Find all backup files for a db
delete old backup files (delete .baks older than the last 2)
copy backup files to new folder, based on criteria.
Which...
--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 2, 2016 at 3:19 pm

#1862591

Viewing 15 posts - 18,211 through 18,225 (of 59,069 total)