Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,856 through 24,870 (of 59,102 total)

RE: Clustered Index Rebuild Space Requirements ?

ELLEN-610393 (1/6/2014)
In the case of a very large table, 1.4 TB, that is not partitioned, what is the least amount of space that will need to be available to build...
--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)

January 6, 2014 at 1:56 pm

#1677877
RE: Updating 2 databases at the exact same time

Yes... rename each table and build a synonym for each table using the original table name. Build an additional table for each table and populate it with the "current"...
--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)

January 6, 2014 at 1:00 pm

#1677866
RE: Exec Trigger On Import

jeandlauro (1/6/2014)
I just mean I thought it would be easier to link Microsoft data tools together.
I've been wondering the same thing for years (almost 2 decades, now). When I'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)

January 6, 2014 at 12:56 pm

#1677862
RE: optimal indexes for a table that is read frequently

Sridhar-137443 (1/6/2014)
Hi, we have a history table in our system that we insert records into it once every 2 weeks but we query the table almost every day. So, 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)

January 6, 2014 at 12:48 pm

#1677860
RE: Windowing Ranges

Hugo Kornelis (12/9/2013)
marcia.j.wilson (12/9/2013)
Any examples of how these would be used?
Running totals. Traditionally done with slow set-based code, with a (relatively!) fast cursor, or with some dangerous unsupported side effect...
--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)

January 6, 2014 at 12:11 pm

#1677854
RE: DATEDIFF Statement help!

ChrisM@Work (1/6/2014)
If you haven't got a ~~timestamp~~ date/time column in your table, how can you tell if something is more than 7 days old?
Does your table have an assocoation 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)

January 6, 2014 at 9:16 am

#1677795
RE: Compare XML in two tables

Better yet, stop storing denormalized data in the form of XML in your database (never mind storing it twice!). 😉
--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)

January 6, 2014 at 9:11 am

#1677793
RE: please help me

elham_azizi_62 (1/6/2014)
thanks for your reply.I create this sp with your query:
ALTER procedure [dbo].[icanSP_Convert_GetEntityDependencies]
@DocId INT,@Count int
as
begin
;WITH MyTable AS (
SELECT * FROM (select linknumber,savabegh from main2 where savabegh is not null and...
--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)

January 6, 2014 at 9:07 am

#1677791
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

First, thanks for the test. On the subject of defending MS for the slowness of FORMAT based on the fact that it's a generic function, I'm sure that 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)

January 6, 2014 at 1:18 am

#1677663
RE: Get Previous month data based on condition

born2achieve (1/5/2014)
Hi Geff,
First of all i don't have enough vocabulary to thank you because the way you answering to the forum questions are much professional and elaborated which will help...
--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)

January 5, 2014 at 8:22 pm

#1677636
RE: Get Previous month data based on condition

Ok, here we go. It always takes me a little longer than others because I like to explain things a bit.
First, I like Michael's code the best out what...
--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)

January 5, 2014 at 4:39 pm

#1677618
RE: Get Previous month data based on condition

born2achieve (1/5/2014)
you meant to say startdate is any date in july 2013 and enddate is any date in jusly 2014. Obviously the data has to fetched because all the 30...
--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)

January 5, 2014 at 2:47 pm

#1677614
RE: Get Previous month data based on condition

Almost forgot. What do you want to do about the Jul 2013 to Jul 2014 scenario that I previously stated?
--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)

January 5, 2014 at 1:02 pm

#1677609
RE: Get Previous month data based on condition

born2achieve (1/5/2014)
Hi Jeff,
Thanks for your precious time on this post and here is my exact business requirement,
From the sample i have provided, assume current date is January 5th which...
--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)

January 5, 2014 at 12:59 pm

#1677608
RE: Segregation of Accounting Duties Analysis DB Help

The Many-to-Many table doesn't mean that this isn't in 3rd Normal form.
For the "conflict" resolution that you seek, you're going to need to setup some sort of a "rules" 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)

January 5, 2014 at 12:14 pm

#1677604

Viewing 15 posts - 24,856 through 24,870 (of 59,102 total)