Forum Replies Created
Viewing 15 posts - 2,821 through 2,835 (of 59,098 total)
-
Reply To: Performance degradation - Help troubleshooting
Jeffrey Williams wrote:ramana3327 wrote:Yes, # 8 is what I am seeing from SQL.
Does changing Maxdop & cost of threshold will effect other queries performance? These setting changes require SQL server restart?
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) -
Reply To: Unable to add NOT NULL constraint (Msg 102, Level 15, State 1)
Johan Bijnens wrote:Jeff Moden wrote:Or, setup a Default and use the WITH VALUES option,
The end result is the same though. There cannot be any NULLs in a NOT NULL column.
Why did 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) -
Reply To: Backup directly to cloud storage for 1.5 tb database
I don't work with Azure and did some brief work with AWS. I've found it to be easier on the server to backup to on-site storage and then copy 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) -
Reply To: Performance degradation - Help troubleshooting
p.s. And don't stop trying to find out what the code is that's causing the blocking because, when these nifty hardware tricks don't work, you have to remember... "Performance 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) -
Reply To: Performance degradation - Help troubleshooting
ramana3327 wrote:The Parallelism settings for the server is below
Processors: 8
Cost threshold for Parallelism: 25 Locks: 0 Max Degree of Parallelism:0 Query Wait:-1
For the processors, is that "Physical Core" or "Logical...
--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) -
Reply To: Are You a Traffic Cop?
This all reminds me of one of my favorite T-Shirts and it's not limited to Developers, DBAs, Project Managers, or Managers...
Remember, 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) -
Reply To: Unable to add NOT NULL constraint (Msg 102, Level 15, State 1)
Or, setup a Default and use the WITH VALUES option,
The end result is the same though. There cannot be any NULLs in a NOT NULL column.
--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) -
Reply To: How do I query to exclude the "first position of a 3 digit number"
ScottPletcher wrote:I'd strongly urge you to avoid a tinyint. Mainly because the room number is "904", not just 4 (and not 94). If you think about it, "room 4" 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) -
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:Jeff Moden wrote:@Eirikur...
I guess that I'd hunt down the people that designed that "edge case" and introduce them to pork chop dinners in a major way.
Heh... reminds me of 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) -
Reply To: MDF size increasing without table size increase
p,s, Also, are you using sp_SpaceUsed with the "updateusage" option enabled? If not, you need to start.
--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) -
Reply To: MDF size increasing without table size increase
ps. wrote:MarkP wrote:That's strange, it should run in less than a second.
Do you have a DBA to refer this to or are you the DBA for this?
I'm the DBA. We...
--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) -
Reply To: SQL Server Agent running an SSIS package, and is unable to detect a file path!
John Esraelo-498130 wrote:Thank you for the reply, Phil!
It was a minor adjustment on the networking folks, and it is fixed now.
thx
Two way street here... what was that "minor adjustment"?
--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) -
Reply To: Performance degradation - Help troubleshooting
Ok, so now find the code that's doing the blocking. One way to do that is to look sp_WhoIsActive by Adam Machanic or Brent Ozar's sp_BlitzCache, read the instructions, download...
--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) -
Reply To: ACCELERATED_DATABASE_RECOVERY and increase in database size
Johan Bijnens wrote:Make sure you're keeping up with these cumulative updates ! They fix a lot, but you'll have to test !
It's almost humorous as to the amount of irony 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) -
Reply To: Are the posted questions getting worse?
@Eirikur...
I guess that I'd hunt down the people that designed that "edge case" and introduce them to pork chop dinners in a major way.
Heh... reminds me of the battles 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)
Viewing 15 posts - 2,821 through 2,835 (of 59,098 total)