Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,181 through 18,195 (of 59,069 total)

RE: Query/Performance Tuning Steps without help of profiler

Grant Fritchey (3/7/2016)
The main thing is that there are no additional trace events being added.
BWAAA-HAAAA-HAAA!!!! That means that it's finally stable! 😀
--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, 2016 at 12:20 pm

#1863536
RE: Query/Performance Tuning Steps without help of profiler

Grant Fritchey (3/7/2016)
You shouldn't be using Profiler anyway. Instead, use extended events.
Heh... I strongly agree... to disagree. 😛 Maybe it's just the bad taste in my mouth left...
--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, 2016 at 8:05 am

#1863476
RE: how to loop without endless joins

astrid 69000 (3/7/2016)
Hi,
Sorry it took me long to answer.
First of all, thanks to everyone who took the time to help.
I have read and part I did understand, part I didn't....
--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, 2016 at 7:55 am

#1863469
RE: how to loop without endless joins

Ed Wagner (3/7/2016)
He changed the data type to allow extra space for the concatenation to occur. Try changing both VARBINARY(1000) to a BINARY(4) and run it to see 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 7, 2016 at 7:49 am

#1863466
RE: error during shrink file after restore on test

tony28 (3/5/2016)
Hello,
I did backup and restored to test..
bak file has about 13GB.
database has allocated mdf file for 40GB and log file for 5GB... I wanted shrink this mdf, because there...
--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 6, 2016 at 7:24 pm

#1863388
RE: Partitioning with null column

RUNNERSQL (3/6/2016)
yes, we realized later that we did the partitiotion on nullable column.
Do we need to make it to notnull and redo the partitiotion ? OR any other options...
--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 6, 2016 at 6:15 pm

#1863386
RE: Partitioning with null column

RUNNERSQL (3/6/2016)
Hi,
we have partitioned a table based a column datatype 'null'.
we have partitions created on all non-clustered indexes.And we didn’t create the partition column in the primary...
--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 6, 2016 at 4:35 pm

#1863384
RE: Departments, Teams, Roles and Services

Hugo Kornelis (3/2/2016)
First, thanks for not including surrogate keys in your ERD. They are an implementation choice, so they should never ever be in any ERD.
That's one opinion. ...
--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 6, 2016 at 4:25 pm

#1863383
RE: Query/Performance Tuning Steps without help of profiler

Eirikur Eiriksson (3/6/2016)
ganapathy.arvindan (3/6/2016)
Please Help me Query/Performance Tuning Steps with out help of profiler
Quick suggestion, get Grant's book on execution plans[/url]
😎
+1 Million to that. Profiler can help but 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 6, 2016 at 4:12 pm

#1863382
RE: generate unique id for each row within a range

Sergiy (3/6/2016)
bismsit.29 (3/3/2016)
Hi Alan,
Thank you very much for replying back so early.
Its sort of a business requirement that's why i want to reuse them also this value can hold till...
--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 6, 2016 at 3:35 pm

#1863381
RE: generate unique id for each row within a range

@bismit29,
I still need answers to the questions in my last post so that I or anyone else can help you wrap this up.
--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 6, 2016 at 3:33 pm

#1863380
RE: Selecting data from GUI in msdb

Ed Wagner (3/4/2016)
This has nothing to do with the question that's already been answered.
Actually, I wonder if the question has been answered. 🙂
I wonder if it's a "security" feature kind...
--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 5, 2016 at 6:39 am

#1863321
RE: The Dangers of Algorithms

Here's the upcoming danger of "algorithms"...
http://www.imdb.com/title/tt0119177/plotsummary
Too far fetched for you? How about a dose of reality, then.
http://www.eyeondna.com/2007/05/19/want-a-job-submit-your-dna/
http://www.eyeondna.com/2009/10/29/getting-a-job-at-the-university-of-akron-could-require-a-dna-sample/
As idiotic as they normally are ...
http://www.eyeondna.com/2007/04/26/victory-for-genetic-information-nondiscrimination-act-gina/
Unfortunately, it's not airtight and genetic discrimination...
--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 4, 2016 at 4:20 pm

#1863296
RE: The Tally Table

Gary Varga (3/4/2016)
Steve Jones - SSC Editor (3/4/2016)
Gary Varga (3/4/2016)
I have still yet to come across a requirement that would benefit from the use of a tally table. I read...
--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 4, 2016 at 1:28 pm

#1863271
RE: How to show Quarters Dynamically in SQL

mandymvn (3/4/2016)
Hi Jeff,
used this in WHERE clause as:
where Qtr >=DATEADD(qq,DATEDIFF(qq,0,GETDATE())-3,0) AND Qtr < DATEADD(dd,DATEDIFF(dd,0,GETDATE())+1,0)
i tried to convert but still getting the error
and getting conversion error :Conversion failed when...
--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 4, 2016 at 1:20 pm

#1863270

Viewing 15 posts - 18,181 through 18,195 (of 59,069 total)