Jeff Moden

Forum Replies Created

Viewing 15 posts - 28,126 through 28,140 (of 59,101 total)

RE: Default fillfactor kept by SQL Server when it is rebuilding the indexes.

Gah... I have to add to that. When you first create an index and you don't specify a FILL FACTOR during creation, it will use the default that 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)

November 21, 2012 at 10:41 pm

#1561470
RE: Default fillfactor kept by SQL Server when it is rebuilding the indexes.

Shadab Shah (11/21/2012)
Hi,
When we want to do performance tuning we usually rebuild the indexes. When SQL Server is rebuilding this indexes it rebuilds it by keeping some value for fill...
--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)

November 21, 2012 at 10:38 pm

#1561466
RE: Create A stored proc template that checks if exists then Alter otherwise create

pamozer (11/21/2012)
I am trying to create a template for our developers for stored procedures. I want the logic to be the following:
If Exists(Select * from sys.objects where name='sproc')
Alter Procedure...
--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)

November 21, 2012 at 10:15 pm

#1561463
RE: List of SP

rocky_498 (11/21/2012)
I am trying to run below query
select
DB_NAME(database_id) as "database_name"
, OBJECT_NAME(object_id, database_id) as "procedure_name"
, last_execution_time
from
sys.dm_exec_procedure_stats
WHERE DB_NAME(database_id) = 'MYDB'
ORDER BY last_execution_time DESC
Question = Which time i am receving...
--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)

November 21, 2012 at 9:21 pm

#1561460
RE: need help with a query

dwain.c (11/21/2012)
Jeff Moden (11/21/2012)
Oh man.... I can't remember if it was Lowell or Magoo or ??? but we've been through this problem before (couple of years ago?) and somebody posted...
--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)

November 21, 2012 at 9:08 pm

#1561457
RE: Datawarehouse - My PO keeps asking for more tempdb

Brian-444611 (11/15/2012)
you kinda sound like my DBEs 🙂
but no seriously this advanced search thing has an endless number of parameters and generates 100+ line queries that are just ugly. ...
--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)

November 21, 2012 at 8:50 pm

#1561453
RE: Two Rows Returned as One for Reporting

dwain.c (11/21/2012)
Call me weird or whatever but I don't think this is particularly messy at all using a simple cross tab query.
First, Michael's set up data with a couple 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)

November 21, 2012 at 8:19 pm

#1561450
RE: need help with a query

Oh man.... I can't remember if it was Lowell or Magoo or ??? but we've been through this problem before (couple of years ago?) and somebody posted some ingenious code...
--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)

November 21, 2012 at 8:00 pm

#1561449
RE: Split a String

AndrewSQLDBA (11/21/2012)
Thanks Everyone
I had to take a little from each query to get what I needed, in a timely manner. I had over 500 million rows to update. But it...
--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)

November 21, 2012 at 7:54 pm

#1561448
RE: switching address with Subtring & len funtion

Eugene Elutin (11/21/2012)
Mark-101232 (11/21/2012)
...
Another tweak helps a bit (maybe... assuming I've got this right)
Change
,1, '.' + LEFT(a.email, CHARINDEX('.', a.email)-1) + '@')
to
,0, '.' + LEFT(a.email, CHARINDEX('.', a.email)-1))
Nope, it doesn't do...
--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)

November 21, 2012 at 7:46 pm

#1561446
RE: switching address with Subtring & len funtion

On the subject of collations, the use of a binary based collation can work performance miracles on certain types of code. Yeah... it clutters up the code a bit...
--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)

November 21, 2012 at 7:38 pm

#1561444
RE: Ignore fields with Commas

I'm no SSIS Ninja by any means but I believe there's a check-box associated with the task that will allow you to identify text-qualified columns with a double quote so...
--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)

November 21, 2012 at 7:16 pm

#1561443
RE: Lots of Key Lookups vs. UniqueIdentifier Clustered Index

dave-L (11/21/2012)
Jeff, there are zillions of lines of app code that have queries joining on and referencing the UUID.
So why are you talking about building a function? The Key...
--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)

November 21, 2012 at 7:09 pm

#1561442
RE: transpose rows into columns

John Esraelo-498130 (11/21/2012)
would pivot be able to do the following?
_JobNum_JobName _DivName _PMNames_HrsUsed_DollUsed_JobCost
12680Mission BeachKing County Johnnie ...
--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)

November 21, 2012 at 4:28 pm

#1561429
RE: rebuild index worsens query performance

jgenovese (11/21/2012)
I dont have time to fabricate sample data
I will see what my boss says about this and get back to you after Thanksgiving break
On this one, I agree.... 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)

November 21, 2012 at 4:24 pm

#1561428

Viewing 15 posts - 28,126 through 28,140 (of 59,101 total)