Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,321 through 22,335 (of 59,098 total)

RE: Last 30 days aggregate query

Crud. I can't post the answer from where I'm at. I have a solution for you and will post it as soon as I get home.
--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 1, 2014 at 6:01 pm

#1761910
RE: How to free up the drive space in SQL that has data files

Jeff Moden (12/1/2014)
Perry Whittle (12/1/2014)
High end FC disks generally arent available in TB sizes and are usually in the order of $1000s each
Oh my! I guess I'm not sure...
--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 1, 2014 at 3:43 pm

#1761894
RE: Subquery problem

My question would be, see what happens when you have denormalized data in your tables? Table 2 should NOT have the Cat column in 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)

December 1, 2014 at 2:15 pm

#1761868
RE: Can I extract a data item from a field that contains many data items?

To be honest, having a "timeslot field" is a really bad idea. You should have a StartDT and an EndDT where you have both the date and time (hence,...
--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 1, 2014 at 1:42 pm

#1761862
RE: How to free up the drive space in SQL that has data files

Perry Whittle (12/1/2014)
High end FC disks generally arent available in TB sizes and are usually in the order of $1000s each
Oh my! I guess I'm not sure what type...
--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 1, 2014 at 8:30 am

#1761748
RE: How to free up the drive space in SQL that has data files

Perry Whittle (12/1/2014)
Jeff Moden (11/28/2014)
A 1 TB 15k-RPM drive costs less than $300 for a SAN drive.
High end FC disks are a lot pricier than $300!!
I'll try 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)

December 1, 2014 at 7:51 am

#1761724
RE: Creating a Query to show data side by side

aaron.reese (11/27/2014)
I am sure this is easier, and it works for sub-groupings like dept (or team, or office, or region)
declare @data table (ID int, FirstName varchar(20), Surname varchar(20), phone varchar(10),...
--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 1, 2014 at 7:49 am

#1761718
RE: When do non clustered index are updated

My pleasure. Thank you for the feedback.
--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 1, 2014 at 7:05 am

#1761702
RE: When do non clustered index are updated

Shadab Shah (11/30/2014)
I have written an update, if i see the execution plan of that update, it is showing the Non Clustered index are updated. I am not able 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)

November 30, 2014 at 11:34 pm

#1761601
RE: Electronic Archive with Insert into Parent Table

Are you allowed to use xp_CmdShell? That would probably make your life a bit easier here. And, no... I'm not suggesting that you enable a proxy for 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)

November 30, 2014 at 11:22 pm

#1761598
RE: Single Table Size is increasing....

P.S. That table has a fair number of columns that you might want to add indexes to. With that thought in mind, I strongly recommend that you do...
--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)

November 30, 2014 at 11:04 pm

#1761596
RE: Single Table Size is increasing....

If you check the results from the script I gave, there are 3,832,619 pages of LOB data present. If we multiply that times the page size of 8,192,...
--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)

November 30, 2014 at 10:57 pm

#1761595
RE: How to check which column is taking more space in a table?

Chowdary's (11/30/2014)
Hi Everyone..
One of the table is occupying more space.
how to check which column is taking more space in a table?
This is for the same problem that you're having...
--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)

November 30, 2014 at 10:24 pm

#1761593
RE: How to free up the drive space in SQL that has data files

WhiteLotus (11/30/2014)
Jeff Moden (11/28/2014)
A 1 TB 15k-RPM drive costs less than $300 for a SAN drive. For a local drive, you can get one for about $70. 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)

November 30, 2014 at 10:05 pm

#1761592
RE: Single Table Size is increasing....

Chowdary's (11/30/2014)
Hi everyone,
We are having the issue with DB size,
for every 3 months we are getting the same issue.
The thing is only one table getting increasing the size.
On 26th...
--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)

November 30, 2014 at 9:52 pm

#1761589

Viewing 15 posts - 22,321 through 22,335 (of 59,098 total)