Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,181 through 24,195 (of 59,102 total)

RE: Reset memory cache for query tuning?

SQLRNNR (3/4/2014)
Cost can help you determine if the query has been tuned.
In addition, you could use statistics time and statistics IO.
Examining the execution plan can really help to determine if...
--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 12, 2014 at 9:01 pm

#1696625
RE: Really need help with query taking longer after backup!

It could be that you're clearing the cache but not the execution plan. Try adding a CHECKPOINT and DBCC FREEPROCCACHE before the DBCC DROPCLEANBUFFERS and see what you get.
--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 12, 2014 at 8:56 pm

#1696624
RE: Assistance with Partition-level locking and X lock on UPDSTATS

Partitioning helps on something like this but not when you change 50% of the table, which is exactly what you're doing with the Client2 insert. Change that to 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 12, 2014 at 8:49 pm

#1696623
RE: Permissions

raghu.sudheer (3/12/2014)
Thanks for the reply. These are all DATABASE level and if create a new database i need to grant permissions to that DATABASE.
Is there any way that all...
--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 12, 2014 at 7:37 pm

#1696612
RE: How to archive emails from yahoo?

SQL Guy 1 (3/12/2014)
I need to archive all my emails from all folders from yahoo. Are there any tools, programs to do this? I need to save them in...
--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 12, 2014 at 7:32 pm

#1696610
RE: help with a instead of trigger

gfoulks (3/12/2014)
okay so the table in question has the following columns
DateTime
Acct_Number
SSN
Script_Code
Div_indicator
first_name
last_name
ani
terminate_area
transfer_area
Periodically we are getting records in this table where ani = 614xxxxxxx
We want to prevent all records with the ani...
--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 12, 2014 at 7:19 pm

#1696609
RE: Help with hierarchical structure without hierarchical relation field...

PiMané (3/12/2014)
Nevyn (3/12/2014)
That wasn't what I was suggesting.
What were you going to put in the calculated Parent ID column for Sean's solution? Surely you weren't going to refer...
--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 12, 2014 at 7:12 pm

#1696608
RE: Are the posted questions getting worse?

Luis Cazares (3/12/2014)
dwain.c (3/12/2014)
Luis Cazares (3/12/2014)
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.
Thanks in advance.
P.S. Please don't ask for DDL and sample data...
--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 12, 2014 at 6:43 pm

#1696603
RE: avoid self join

dwain.c (3/12/2014)
mxy (3/12/2014)
Thanks for you reply that works perfect!
in case if we have 10 payments (empsal, empsal1..empsal9) and dates paiddate1 through 10 what we need to do?
Did you try my...
--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 12, 2014 at 6:36 pm

#1696602
RE: I need to delete 20 million rows from a table...

GilaMonster (3/12/2014)
Jeff Moden (3/12/2014)
GilaMonster (3/12/2014)
MyDoggieJessie (3/12/2014)
TRUNCATE will be faster and be minimally logged.
Fully logged. It's efficiently logged, but it is fully logged, not minimally logged. Minimally logged has a specific...
--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 12, 2014 at 5:36 pm

#1696586
RE: A True SQL OS

jownby (3/12/2014)
DavidL (3/12/2014)
It would be an interesting scenario, sort like paying a premium to M$ to NOT have windows installed:-P
Is that like when Porsche wants to sell 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)

March 12, 2014 at 2:46 pm

#1696548
RE: I need to delete 20 million rows from a table...

Very cool. Thanks for the feedback. Just wanted to make sure.
--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 12, 2014 at 2:44 pm

#1696547
RE: I need to delete 20 million rows from a table...

Siberian Khatru (3/12/2014)
Shrinking my files down to a manageable level which should solve my disk space crunch a bit.
Shrinking your files will also make a narly trainwreck out of your...
--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 12, 2014 at 1:10 pm

#1696529
RE: I need to delete 20 million rows from a table...

GilaMonster (3/12/2014)
MyDoggieJessie (3/12/2014)
TRUNCATE will be faster and be minimally logged.
Fully logged. It's efficiently logged, but it is fully logged, not minimally logged. Minimally logged has a specific definition.
I do wish...
--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 12, 2014 at 1:08 pm

#1696528
RE: Are the posted questions getting worse?

Greg Edwards-268690 (3/11/2014)
And 5 or 6 lines of MDX likely solves the whole thing if you build a cube.
Or use PowerPivot in Excel to let the user play with 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 11, 2014 at 10:09 pm

#1696209

Viewing 15 posts - 24,181 through 24,195 (of 59,102 total)