Forum Replies Created
Viewing 15 posts - 24,556 through 24,570 (of 59,102 total)
-
RE: Thoughts about Table Partitioning...
About the only way that I can think of to increase the performance of inserts when an IDENTITY column is the clustered index (and with the understanding that I haven't...
--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) -
RE: Comparing string with date
Lempster (1/31/2014)
Jeff Moden (1/31/2014)
The truth be told, they're both not that great because of the mixed character data in denormalized columns instead of using the correct DATETIME datatype.Yep, and 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) -
RE: Thoughts about Table Partitioning...
JohnFTamburo (1/30/2014)
Hi. A few more details...1. Both tables are clustered on a BIGINT identity. This identity would be the value upon which I would partition. Each node 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) -
RE: create a table with two primary keys.
Ryan George (1/31/2014)
So what do you think? We are not here to provide answers for interview questions so you can get a job that you are not qualified for.
Dear Mr....
--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) -
RE: Comparing string with date
Lempster (1/30/2014)
Hmm, just to come back on this. I tested both solutions after running DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE each time (I'm using a test instance obviously!) and i got...--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) -
RE: Today's Random Word!
Luis Cazares (1/30/2014)
Jeff Moden (1/30/2014)
"JOCC BOOSTR" (pronounced "jock booster")Definition:
Justification Of Crap Code Based Only On Small Table Requirements
🙂
Everywhere
BWAAA-HAAAA!!!! Perfect picture for the phrase. 😛
--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) -
RE: Today's Random Word!
Ed Wagner (1/30/2014)
Luis Cazares (1/30/2014)
Jeff Moden (1/30/2014)
"JOCC BOOSTR" (pronounced "jock booster")Definition:
Justification Of Crap Code Based Only On Small Table Requirements
🙂
Everywhere
Pervasive
Infectious
--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) -
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)
WayneS (1/30/2014)
Additionally, someone else may be doing the work "when it counts", and they just might copy/re-use the poorer quality code that you've written because it does do the job....--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) -
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)
staudacher (1/30/2014)
Nice Example to find out that Date can have Time includedThat's one of the things that many people miss or, in the face of a column that's supposed "guaranteed"...
--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) -
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)
marcia.j.wilson (1/30/2014)
I agree with the comments about this being excellent. I work with a lot of effective-dated information and have been using similar logic for over 20 years (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) -
RE: create a table with two primary keys.
Ryan George (1/30/2014)
it is really interesting to hear. In a table, two prmary keys.but this is a question which i got for an interview
i had options too. :doze:
as per 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) -
RE: Old SQL Code and Compatibility
ChrisM@home (1/30/2014)
homebrew01 (1/30/2014)
We haven't written any code like that in a while. It is easy to search for '*=' and find the left joins. Not so easy to find...--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) -
RE: Which one of these three (2) WHERE clauses is BEST for PERFORMANCE?
VoldemarG (1/30/2014)
Sorry I missed the % in LIKEs. Of course I meant wildcards..If that's true, then the best solution (Option 3) cannot be accomplished.
--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) -
RE: Thoughts about Table Partitioning...
To answer your original questions, if you maintain a clustered index on an IDENTITY column, then whether the table is partitioned or not, the data will always be placed at...
--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) -
RE: Thoughts about Table Partitioning...
There are a HUGE number of caveats to partitioning especially Partitioned Tables (as opposed to partitioned views which have their own set of caveats and work arounds. One of...
--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 - 24,556 through 24,570 (of 59,102 total)