Jeff Moden

Forum Replies Created

Viewing 15 posts - 28,096 through 28,110 (of 59,101 total)

RE: Reads too high on indexed-table update

SpringTownDBA (11/23/2012)
These are logical reads, not physical reads.
Every seek into a table gets counted as a logical read.
That doesn't explain why the number of reads jumps so high...
--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 24, 2012 at 1:17 pm

#1561994
RE: Removing replication

mahesh.dasoni (11/24/2012)
Steps required by which we can completely remove replication in sql server 2005.
Step 1. Press the {f1} key to activate Books Online.
Step 2. Search for "replication [SQL...
--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 24, 2012 at 12:41 pm

#1561990
RE: The new role of the DBA

DBAs will always be needed even in such an environment of double-checks by change-control. Who else but a DBA could figure out that such things as you mention actually...
--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 24, 2012 at 12:32 pm

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

opc.three (11/24/2012)
Jeff Moden (11/22/2012)
dave-L (11/22/2012)
Hi Jeff. That's my whole question really. Is there a good way to fix this and is it worth trying to fix.
True using a UDF 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)

November 24, 2012 at 11:08 am

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

Bhuvnesh (11/22/2012)
Jeff Moden (11/22/2012)
Either put the CI on the GUID with a decent FILL FACTOR to prevent rampant page splits during inserts
what would be that decent valure ?...
--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 24, 2012 at 10:28 am

#1561983
RE: Update statement question

CELKO (11/23/2012)
No, we don't need to unlearn anything. Like anything else, UPDATE works just fine if you use it correctly.
That is an awful argument and you know...
--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 23, 2012 at 8:36 pm

#1561951
RE: Format Phone Number function

Bharat Panthee (12/8/2010)
I think it is better to write CLR function for it,if you are using sql server 2005 or 2008
This is why I don't allow people to write CLRs...
--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 23, 2012 at 4:23 pm

#1561942
RE: Optimization of stored procedures

peterdru401 (11/21/2012)
I will suggest to use a third party tool it will monitor the performance of SQL Server, the future growth of your database size,
which in turn improve 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)

November 22, 2012 at 11:02 pm

#1561756
RE: Update statement question

CELKO (11/22/2012)
I'm doing a DB review and have always been taught to write updates with a JOIN like using this syntax.
UPDATE Target
SET col_list = S.col_list
FROM Table1 AS Target
...
--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 22, 2012 at 10:44 pm

#1561749
RE: Script to create realistic generic financial data

Gabe T. (11/22/2012)
@FundID = @FundID --Anchor: forces a clustered index update so the quirky update works in order.
That won't act as an anchor because you have a variable = variable....
--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 22, 2012 at 10:33 pm

#1561748
RE: Stored procedure that takes backup of your procedures on physical drive

Aadhar Joshi (11/22/2012)
I am getting error while executing this stored procedure
Please help.
Please provide the actual error you're getting.
--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 22, 2012 at 10:25 pm

#1561746
RE: read UNCOMMITTED run slower than read COMMITTED

matthew.peters (11/22/2012)
Hello
I have the following query which runs considerably slower when we change the isolation level to read uncomitted, I just wanted to understand why. I have attached the 2...
--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 22, 2012 at 10:22 pm

#1561744
RE: Is there a way to Identify if a database is no longer in use

p.s. In 2008 and above, you can setup an audit but I believe that will still record the database as being "accessed" even if you just expand the tables...
--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 22, 2012 at 9:59 pm

#1561743
RE: Is there a way to Identify if a database is no longer in use

Heh... you could always do the SOFH thing... set it to offline and wait for the phone to ring. I Dev ad Staging boxes which have about 10 times...
--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 22, 2012 at 9:53 pm

#1561742
RE: Deadlock that I cannot figure out.

They are simple, indeed and, by themselves, I don't see them causing the deadlock. Are they "wrapped" in other procedures that use explicit transactions?
Also, if the [ObjectID] ASC, [EventType]...
--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 22, 2012 at 7:59 pm

#1561736

Viewing 15 posts - 28,096 through 28,110 (of 59,101 total)