Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,346 through 18,360 (of 59,070 total)

RE: Transaction Log Getting Full

jacqueline.trent (2/19/2016)
Is it in Simple recovery mode or Full recovery mode or bulk logged recovery mode?
And ... do you know how to check this?
That and a whole lot...
--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)

February 19, 2016 at 6:06 pm

#1859941
RE: How to extract overlapping date ranges from a table of date ranges

ben.brugman (2/19/2016)
Jeff Moden (2/18/2016)
ben.brugman (2/18/2016)
This is a very sensible remark, but why not use 9000-01-01. This contains more 'zero's' so to me it is more logical :-).
Only because 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)

February 19, 2016 at 12:05 pm

#1859918
RE: Are the posted questions getting worse?

SQLRNNR (2/19/2016)
BL0B_EATER (2/19/2016)
GilaMonster (2/19/2016)
Google down? 😉
First search results: http://www.investopedia.com/terms/s/stump-the-chump.asp
Yup I should know better! anyways yeah that would make for an awkward interview.
Yeah. They are trying to prove to somebody that...
--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)

February 19, 2016 at 11:57 am

#1859916
RE: How to query a Denormalised table

sushantkatte (2/17/2016)
hi @
Jeff Moden. this is not a homework question. This questions were asked to me in an interview. i have created the table definition from the question itself. so...
--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)

February 19, 2016 at 11:07 am

#1859905
RE: Using Parameters in a Query is Killing Performance

Hugo Kornelis (2/19/2016)
ScottPletcher (2/19/2016)
You should cluster this table on upsrt_dttm instead.
How can you possibly determine that this should be a good clustering key based on seeing only one single query...
--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)

February 19, 2016 at 10:22 am

#1859891
RE: Count number of visits each day

mansur.azam (2/19/2016)
Thanks. This works!
Not sure what you're referring to. I'm thinking that it's Orlando's code that worked (seems like it should just from reading 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)

February 19, 2016 at 8:39 am

#1859841
RE: Using Parameters in a Query is Killing Performance

The only two indexes that I see that come close to supporting the particular query you posted (provided that I've interpreted the differences between your original post and your CREATE...
--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)

February 19, 2016 at 8:34 am

#1859839
RE: Using Parameters in a Query is Killing Performance

Never mind. This is taking too long. (and sorry, posted this before I saw your post with the table info so my column names match your original post instead...
--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)

February 19, 2016 at 8:21 am

#1859830
RE: Using Parameters in a Query is Killing Performance

Loner (2/19/2016)
I just look at the table, it has 12 FK and 1 PK and 11 non unique non cluster index.
I don't need the FK's. Just the CREATE 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)

February 19, 2016 at 8:01 am

#1859820
RE: How to query a Denormalised table

Ed Wagner (2/18/2016)
I think Hugo hit the nail on the head. I can't believe those questions were even in an interview. There are a number of good stairway...
--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)

February 18, 2016 at 10:07 pm

#1859727
RE: Using Parameters in a Query is Killing Performance

Loner (2/18/2016)
The table has 2357880092 number of records.
I still need the CREATE TABLE statement and the indexes for the table so that I can build a large test table 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)

February 18, 2016 at 8:35 pm

#1859722
RE: Query to count concurrent users every hour

Gstar1224 (2/18/2016)
...calculate the number of concurrent users every hour...
What does that actually mean? Do you mean, for example, if someone were logged in from 1:30AM until 4:30AM, they...
--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)

February 18, 2016 at 8:32 pm

#1859721
RE: Are the posted questions getting worse?

No need to pile on (in fact, please don't) but the post below reminds me of the interviews that I've conducted over the last decade. The problem is, it's...
--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)

February 18, 2016 at 1:37 pm

#1859687
RE: How to extract overlapping date ranges from a table of date ranges

ben.brugman (2/18/2016)
This is a very sensible remark, but why not use 9000-01-01. This contains more 'zero's' so to me it is more logical :-).
Only because SQL Server implicitly converts 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)

February 18, 2016 at 1:23 pm

#1859681
RE: Using Parameters in a Query is Killing Performance

Loner (2/18/2016)
We purchase the software for our company and we cannot just update the database and create index.
I'll ask again...
Jeff Moden (2/17/2016)
Loner (2/17/2016)
Ok, I give up, someone please help! 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)

February 18, 2016 at 9:03 am

#1859610

Viewing 15 posts - 18,346 through 18,360 (of 59,070 total)