Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,476 through 26,490 (of 59,099 total)

RE: SQL Low performance only in afternoons

Just to add to what Laurie posted...
The dbo.sysjobhistory system table in MSDB does keep track of duration and both the job and the level. It certainly won't give 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)

July 5, 2013 at 4:32 pm

#1630197
RE: How to Add a Date randomly

niladri.primalink (7/4/2013)
However your input has helped me to solve it.
Two way street here... please post the code you ended up with so someone else can learn from it. Thanks.
--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)

July 5, 2013 at 1:29 pm

#1630183
RE: How to Add a Date randomly

dwain.c (7/4/2013)
What in Buddha's name is a "lac day?"
"lac" is 100,000 in the OP's language.
--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)

July 5, 2013 at 1:26 pm

#1630181
RE: Query plan changes over time, query performance severely impacted

richard.austin (7/4/2013)
Hi all,
I have a query that takes 2 seconds to compile and run (first time round) when the server is restarted. When the server has been up and running...
--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)

July 4, 2013 at 5:26 pm

#1629913
RE: Can a strawberry query be done better?

And now we know why test data is essential for such "general" questions. 😛
Just to add my 2 cents, you can combine the Year and Month comparison by doing 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)

July 4, 2013 at 5:21 pm

#1629911
RE: General View Performance Question

I don't have your tables or data so I can't really tell what's going on especially since I can't gen the actual execution plan. I did do a simple...
--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)

July 4, 2013 at 4:48 pm

#1629907
RE: Can a strawberry query be done better?

Banana-823045 (7/4/2013)
Coming from MySQL background, one query design I learned early on was 'strawberry query', which got its odd name from the MySQL newsgroup. It is a very useful pattern...
--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)

July 4, 2013 at 3:30 pm

#1629897
RE: General View Performance Question

Davebhoy (7/4/2013)
Hi there
I'm a novice a at SQL so hopefully this is an easy answer for someone.
I have a basic view which queries two tables in separate databases with one...
--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)

July 4, 2013 at 11:44 am

#1629876
RE: split a string

To add to what Steven has already posted, there's really no need to redevelop the wheel. Buy a "CASS Certification" program that will do this for you. It'll...
--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)

July 4, 2013 at 11:23 am

#1629873
RE: TEMP DB ISSUE

sqlpanther (7/3/2013)
It consumes around 60gb and thing is we do not have any transactions which are 60gb my analysys says out tempdb is not flushing the commited transaction but recovery...
--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)

July 4, 2013 at 11:10 am

#1629871
RE: How to Add a Date randomly

niladri.primalink (7/4/2013)
Hi All,
In a table (sale.person) I have more than 9 lacs row. I have only three columns. I need to add a column by Orderdate (which I have done...
--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)

July 4, 2013 at 10:55 am

#1629869
RE: Turn rows into columns

bleroy (7/4/2013)
I would still love to have a method using SELECT only (i.e. not a SP) that would work regardless of the number of rows (i.e. with this solution, I...
--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)

July 4, 2013 at 10:29 am

#1629861
RE: CONVERT COLUMN VALUES TO COMMA SEPARATED ONE ROW VALUE..

Mnishar (7/4/2013)
Hi you can achieve this by XML
Check this out
http://www.sqlblogspot.com/2013/04/convert-rows-into-comma-separated.html
Hi Nnishar,
Consider using GROUP BY instead of DISTINCT. Here's your code with the WHERE clause removed to try...
--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)

July 4, 2013 at 10:03 am

#1629860
RE: 2 way sync in SQL server 2005

Here's another decent one.
http://msdn.microsoft.com/en-us/library/ff649591.aspx
--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)

July 3, 2013 at 6:20 pm

#1629710
RE: 2 way sync in SQL server 2005

The following MS link should help start you on your way.
http://technet.microsoft.com/en-us/library/ms151196.aspx
--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)

July 3, 2013 at 6:15 pm

#1629709

Viewing 15 posts - 26,476 through 26,490 (of 59,099 total)