Forum Replies Created
Viewing 15 posts - 10,306 through 10,320 (of 59,099 total)
-
RE: Error: Cannot insert duplicate key row in... a non-unique index?!
Eric M Russell - Tuesday, December 18, 2018 3:42 PMHere is a portion of the execution plan:
What does 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)December 18, 2018 at 7:17 pm
-
RE: TOP vs Max/Min: Is there a difference?
Sean Lange - Tuesday, December 18, 2018 10:20 AMneil-560592 - Tuesday, December 18, 2018 4:56 AM--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)December 18, 2018 at 1:12 pm
RE: Decode waits on Object resource
tttcoding - Tuesday, December 18, 2018 1:58 AMSue_H - Monday, December 17, 2018 7:10 AM--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)December 18, 2018 at 1:02 pm
RE: Find the root cause of SQL Server slowness and possibly killing blockers automatically
I setup a "Blocking ALERT" which runs a stored procedure to save the current active spids and the code they're currently executing into a table (so I have the proof...
--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)December 18, 2018 at 12:57 pm
RE: Looping Through Data
Also, can you post the data in the readily consumable format that I pointed out in one of my previous posts above? I really don't have the time to mess...
--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)December 18, 2018 at 12:42 pm
RE: Looping Through Data
irehman - Tuesday, December 18, 2018 10:45 AMYou're welcome but you've...
--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)December 18, 2018 at 12:40 pm
RE: Entity-Attribute-Value is evil ? how to avoid...
Eric M Russell - Tuesday, December 18, 2018 12:13 PMJeff Moden - Tuesday, December 18, 2018 11:49...--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)December 18, 2018 at 12:38 pm
RE: Error: Cannot insert duplicate key row in... a non-unique index?!
Check for other dependencies on the table. I'm thinking that someone may have snuck in an indexed view or synonym on you. I can't imagine why it would cause a...
--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)December 18, 2018 at 12:34 pm
RE: Validate date stored as a string as a complete, valid date
I'm not sure how you're populating your upstream table but, if you're using BCP or BULK INSERT, learn how to use the error parameters to simply sequester the rows with...
--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)December 18, 2018 at 12:26 pm
RE: Run procedure without cursor or loop
valeryk2000 - Saturday, November 17, 2018 11:03 AMThanks. Good to know. We are upgrading to SQL Server 2016. I thik IIf 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)December 18, 2018 at 12:19 pm
RE: Text data type
HappyGeek - Wednesday, April 25, 2018 12:28 PMThom A - Wednesday, April 25, 2018 9:05 AM--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)December 18, 2018 at 12:17 pm
RE: Calculate time difference between two related visitors without using cursor
CELKO - Monday, October 10, 2016 1:03 PMFrom what I've experienced, a table in some sql dialects can lack a 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)December 18, 2018 at 12:15 pm
RE: The best way to load big chunks of rolling data
ChrisM@Work - Friday, April 20, 2018 9:48 AMWe had, until recently, a weekly load of around 50 million rows into a table...--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)December 18, 2018 at 12:00 pm
RE: Entity-Attribute-Value is evil ? how to avoid...
Eric M Russell - Tuesday, December 18, 2018 10:04 AMI don't think we should shape and force a RDMS like SQL Server...--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)December 18, 2018 at 11:49 am
RE: Looking to downgrade our SQL Server editions from Enterprise to Standard Edition
asamykin - Tuesday, December 18, 2018 9:52 AMAnother option to do in-place downgrade without any new instances is to use registry keys--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)December 18, 2018 at 10:34 am
Viewing 15 posts - 10,306 through 10,320 (of 59,099 total)
