Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,801 through 19,815 (of 59,098 total)

RE: Require Suggestion on third party tools both PAID & FREE

To be honest, your questions reflect a fairly large project. My recommendation is that you and your team get started on these things and if you run into 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)

August 24, 2015 at 11:31 am

#1822057
RE: udf with tally table runs slower than while loop

Josh Leane-155117 (8/24/2015)
Hi Chris, I tried your suggestions,
1) clustered index on tally table didn't make any difference, still 120 secs on test data
2) using LEN(@vstrText) < N made huge...
--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)

August 24, 2015 at 11:26 am

#1822054
RE: Mission Critical Deployments

Eric M Russell (8/24/2015)
It seems to me that, even in the event of a catastrophic computer system failure, an airplane should still be functional enough to make an emergency landing...
--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)

August 24, 2015 at 9:56 am

#1822020
RE: Are the posted questions getting worse?

Grant Fritchey (8/24/2015)
Threadizens, please don't skip posting your top scripts. I need help on this article.
I thought you just wanted commands. As for "top scripts", I'm not using anyone...
--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)

August 24, 2015 at 9:54 am

#1822019
RE: Maintenance Plan - Rebuild Indexes only run if required or open fires on schedule?

shamshad.ali (8/23/2015)
Normally we use rebuild, reorganize indexes when it is required, I used a SQL job using maintenance plan to run daily and rebuild, reorganize indexes and update statistics but...
--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)

August 23, 2015 at 11:46 pm

#1821880
RE: sp_cursorprepexec slows down and down through the night

Ok. Glad you sussed it. I hope it doesn't come back as a problem in the future because it sounds like (and I could be wrong) a temporary...
--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)

August 23, 2015 at 10:49 pm

#1821879
RE: SET TABLE VARIABLE FROM FUNCTION CALL

mar.ko (8/19/2015)
Thanks Gila and Scott.....good stuff.
Interestingly - by using a temp table instead of a declared table variable, the @@FETCH_STATUS initializes to -1 versus zero.
@@FETCH_STATUS??? Correct me if I'm...
--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)

August 23, 2015 at 5:14 pm

#1821874
RE: how to reclaim space

rightontarget (7/21/2015)
I am using SQLServer 2008R2, recovery mode = Simple.
In ssms I right-click on database, go to properties and it shows size = 380G (data file), but I know 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)

August 23, 2015 at 5:08 pm

#1821873
RE: Help - Global Call

ganesh_trichy (8/22/2015)
Hi,
I am a .net guy, don't have deep knowledge on DB side. I am trying to implement solution for below requirement.
The application is passing a user id and department...
--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)

August 23, 2015 at 4:41 pm

#1821872
RE: handling odd date format

So, Abhijit More. Did any of this work for you or not? This IS a two way street here. 😉
--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)

August 23, 2015 at 12:48 pm

#1821869
RE: Grouping islands of data

jessica.green2312 (8/21/2015)
It hardly takes any time at all. The craziness that runs immediately before takes just shy of 2 minutes and when I add this afterwards it was still finished...
--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)

August 23, 2015 at 12:46 pm

#1821868
RE: Why Use Version Control?

Version control for database is totally useless... right up until the time that you actually need it to undo a mistake without having to call for a backup tape to...
--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)

August 23, 2015 at 12:42 pm

#1821867
RE: sp_cursorprepexec slows down and down through the night

You talked about each cursor being prepared and executed. Have you verified that each one is being closed when completed?
Also, I'd like to recommend that you change these calls...
--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)

August 23, 2015 at 11:47 am

#1821865
RE: What are your five most common T-SQL commands

To be honest, there's only one thing that I type very much and that's BEGIN TRANSACTION. As a DBA, I have pretty much everything else automated. I've even...
--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)

August 22, 2015 at 10:19 pm

#1821851
RE: Fine tuning Queries

ScottPletcher (8/22/2015)
Jeff Moden (8/21/2015)
For too many reasons to explain here, SQL Server really, really likes NOT NULL, UNIQUE, ever increasing, narrow clustered indexes. A date time column can be...
--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)

August 22, 2015 at 12:08 pm

#1821842

Viewing 15 posts - 19,801 through 19,815 (of 59,098 total)