Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,241 through 18,255 (of 59,102 total)

RE: Trigger for Table Updates

TJT (3/3/2016)
Hi SSCoach, do you have an example of a holding table? Also do you have an example of retrieving data from the " inserted or deleted virtual tables"?
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)

March 3, 2016 at 6:09 pm

#1862968
RE: Only one expression can be specified in the select list when the subquery is not introduced...

...and thing like this...
WHERE (DATEDIFF(D, sod.ConfirmDate, GETDATE()) > 0)
... make it impossible to do index seeks and generally slow code way down because it has to calculate for every...
--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 6:01 pm

#1862966
RE: tempdb local drive ssd versus attached storage

tcronin 95651 (3/3/2016)
Started with 300 gig tempdb, may need to expand that.
I can't really tell because I know nothing about your databases but that seems a bit much. I've...
--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 5:52 pm

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

Viewing 15 posts - 18,241 through 18,255 (of 59,102 total)