Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,791 through 17,805 (of 59,069 total)

RE: Statistics on every column?

Thanks for the answers, folks. Everything is pretty much as I thought but had to make sure. Lot's o' experienced folks out there and I've not run into...
--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)

April 25, 2016 at 12:39 pm

#1874341
RE: A nice whistle and flute

Gary Varga (4/25/2016)
The solution you come across may be the result of a lot of effort and application of knowledge and experience in the face of a formidable situation.
It's been...
--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)

April 25, 2016 at 11:13 am

#1874319
RE: The Hidden Trigger

Gary Varga (4/25/2016)
Jeff Moden (4/21/2016)
Gary Varga (4/21/2016)
I have just been called out on the way I was looking at someone who attempted to tell me what a trigger was "...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)

April 25, 2016 at 11:06 am

#1874317
RE: Query tuning advice required please

mike.dinnis (4/25/2016)
Jacob Wilkins (4/25/2016)
You'll either need to look at simplifying the query (maybe explicitly querying the underlying tables from the view that you need instead of forcing the optimizer 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)

April 25, 2016 at 8:59 am

#1874265
RE: A nice whistle and flute

Good advice, Phil. It's not just for consultants, though. DBAs and Developers need to apply such thoughtfulness, as well.
--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)

April 25, 2016 at 8:45 am

#1874258
RE: Verify SQL Backups With SQL Powershell

I'm sometimes torn between centralized and distributed systems. While I love the convenience of centralized monitoring systems, if something goes haywire with them, then you're monitoring nothing or 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)

April 25, 2016 at 7:19 am

#1874221
RE: SCD 2 End data and CurrentRowFlag

SolveSQL (4/22/2016)
I have a theoretical question.
When working with the Dimension table, if i have EffectiveDate and EndDate is there also a reason to have a CurrentRowFlag Column?
Looking for some...
--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)

April 24, 2016 at 7:18 pm

#1874146
RE: cannot attach the output of the job step

inHouseDBA (4/24/2016)
Hello folks,
I am looking for ideas or if anyone experienced the same before.
I have 1 step SQL Server 2012 job.
So it executes the Stored Proc with some convoluted logic...
--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)

April 24, 2016 at 7:09 pm

#1874145
RE: Are the posted questions getting worse?

TomThomson (4/22/2016)
Phil Parkin (4/22/2016)
Eirikur Eiriksson (4/22/2016)
Brandie Tarvin (4/22/2016)
In this case I did add my two cents because I've seen that damn failure before and it took me days to figure...
--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)

April 24, 2016 at 10:51 am

#1874136
RE: Need to rebuild Index on 1.4 TB table (Replication is setup on that database) and also on 900 GB table(mirroring is setup on database

kiran.patel07 (4/21/2016)
we did not rebuild index from last 2 Years on those huge tables and it causes performance issue now.
Probably not. It's likely that the performance is getting slower...
--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)

April 22, 2016 at 6:00 pm

#1874076
RE: Default Value RAND issue

Welsh Corgi (4/22/2016)
MadAdmin (4/22/2016)
guessing that it should be (rand())
Will check ina bit.
Thanks it worked.
Does this look right?
ALTER TABLE tblCall
ADD CONSTRAINT DF_ReinspectTag
DEFAULT (rand()) FOR ReinspectTag
It works but no... 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)

April 22, 2016 at 5:43 pm

#1874075
RE: SSIS Packages Job fails no information in Job History

Welsh Corgi (4/22/2016)
Lowell (4/22/2016)
check to see how long your history retention is; it could easily have been written, but aged out by the time you look at it.
if it is...
--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)

April 22, 2016 at 5:08 pm

#1874073
RE: Are the posted questions getting worse?

ChrisM@Work (4/22/2016)
Phil Parkin (4/22/2016)
BLOB_EATER (4/22/2016)
He lost me on freezer performance...
The walking freezer is what I want to see.
Manchester. That's where my ex wife lives.
BWAAA-HAAAA!!! (oops... sorry. Did that come...
--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)

April 22, 2016 at 8:16 am

#1873915
RE: Reaping the benefits of the Window functions in T-SQL

lucyliu0301 (4/22/2016)
Good article, well, lengthy. There are better areas to demonstrate the benefit of window functions than parsing strings. For example, when you need to compare rows based on some...
--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)

April 22, 2016 at 8:12 am

#1873913
RE: Creating an Index Strategy

Grant Fritchey (4/14/2016)
I know you're not drinking the bong water. Not at all. However, I have seen scans hurt performance when the indexes were fragmented. Rebuilding helped, and not because...
--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)

April 21, 2016 at 6:54 pm

#1873814

Viewing 15 posts - 17,791 through 17,805 (of 59,069 total)