Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,481 through 18,495 (of 59,072 total)

RE: TECHNICAL QUESTION on TRUNCATING and DELETING

mw112009 (1/28/2016)
TECHNICAL QUESTION
TRUE/FALSE
1.) When a table is TRUNCATED the TR-LOG is updated.
2.) When a table is DROPPED the TR-LOG is updated.
I'd say #2 is TRUE but I am not sure...
--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)

January 28, 2016 at 6:24 pm

#1855115
RE: Find Valid Date from String

Steve Jones - SSC Editor (1/28/2016)
You might look at SQL# for regex functionality
http://www.sqlsharp.com/
If it can be done in T-SQL, it'll usually be faster than RegEx. We've proven that 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)

January 28, 2016 at 6:21 pm

#1855114
RE: SSIS Script Task and running a stored procedure

JustMarie (1/27/2016)
The desired outcome - open an existing connection manager, run a stored procedure, save the results to a variable, close the connection manager.
I need to send HTML formatted email...
--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)

January 28, 2016 at 4:01 pm

#1855104
RE: Create Text File from SELECT

Orlando Colamatteo (1/28/2016)
Jeff Moden (1/28/2016)
Orlando Colamatteo (1/27/2016)
What you have here is a multi-record format where the header line has a different column-format than the data lines. T-SQL solutions traditionally have...
--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)

January 28, 2016 at 3:53 pm

#1855103
RE: Crafting Your Resume

Gary Varga (1/28/2016)
TheFault (1/28/2016)
David.Poole (1/27/2016)
When I'm recruiting I scan for the skills I want, the context and then length of time in each position and any suspicious gaps.
quote]
Curious...
--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)

January 28, 2016 at 7:49 am

#1854958
RE: Best practice for temporary working tables.

Hugo Kornelis (1/27/2016)
Disclaimer first: I have never used Oracle. So take the below with a huge helping of salt, please.
However, I have heard many times that Oracle, unlike SQL Server,...
--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)

January 28, 2016 at 12:43 am

#1854875
RE: Create Text File from SELECT

Orlando Colamatteo (1/27/2016)
What you have here is a multi-record format where the header line has a different column-format than the data lines. T-SQL solutions traditionally have trouble with these 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)

January 28, 2016 at 12:25 am

#1854874
RE: Need Query to know the SQl server service status

johnwalker10 (1/27/2016)
Take a look at this article, hope this will help you out:
https://www.mssqltips.com/sqlservertip/2609/checking-sql-services-status--an-evolution-part-1/%5B/url%5D
Thanks for posting that article. Interesting thing in the discussions that occurred on that article... some...
--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)

January 28, 2016 at 12:14 am

#1854873
RE: Create Text File from SELECT

Orlando Colamatteo (1/27/2016)
Jeff Moden (1/26/2016)
We've actually dismantled all SSIS packages except 1 and we're working on that.
Funny you mention it. I finished migrating the last process that made use 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)

January 27, 2016 at 5:11 pm

#1854842
RE: Calendar Table Function

dietztm (1/27/2016)
Jeff - Sorry to hear you're having performance issues with your database.
Our problems are the opposite of yours. We have a lot of pressure for quick turnaround and a...
--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)

January 27, 2016 at 5:06 pm

#1854840
RE: Calendar Table Function

dietztm (1/26/2016)
Hi Jeff thanks for your response.
That recursive CTE I posted was only to generate some test data to demonstrate window functions for the LDOM and FDOM. I chose 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)

January 27, 2016 at 2:05 pm

#1854820
RE: Disk space

We put the following on their own drives whenever possible.
1. C: Operating System with good headroom.
2. D: Programs
3. E: Swap File is on a separate drive.
4. L: LDF...
--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)

January 27, 2016 at 10:49 am

#1854781
RE: Crafting Your Resume

Gary Varga (1/27/2016)
Jeff Moden (1/27/2016)
Steve Jones - SSC Editor (1/26/2016)
Gary Varga (1/26/2016)
Jeff Moden (1/25/2016)
Heh... according to the interviews I've been conducting for the last several years, people have spent way...
--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)

January 27, 2016 at 8:39 am

#1854741
RE: Multiple queries in the same stored procedure

ScottPletcher (1/27/2016)
Jeff Moden (1/26/2016)
Manic Star (1/26/2016)
So we had a development. An SQL MVP at days of .Net told our devs that their beloved UberQueries were ok since the QA cached...
--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)

January 27, 2016 at 8:02 am

#1854713
RE: Turn Out the Lights

djackson 22568 (1/27/2016)
Jeff Moden (1/27/2016)
Henry B. Stinson (1/27/2016)
This has gotten way off topic and has become a rant on something not even related to SQL Server.
Heh... they're just 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)

January 27, 2016 at 7:56 am

#1854709

Viewing 15 posts - 18,481 through 18,495 (of 59,072 total)