Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,261 through 19,275 (of 59,072 total)

RE: Learn to Use Filegroups

BJ Hermsen (5/12/2011)
One of the databases I support uses a large number of file groups to seperate different types of data. Base tables are seperated among many of them...
--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 4, 2015 at 6:42 am

#1837637
RE: calculate and display week between two dates

The "WEEK" date part is based on the "DATEFIRST" server setting. If you change servers (especially multi-country) or if someone gets some sort of date religion and changes 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)

November 4, 2015 at 6:30 am

#1837631
RE: Ad hoc Backup Policy - prior to applying small changes

This is where proper Point-in-time backups can help a lot.
That notwithstanding and depending on the change, I may backup separate tables using SELECT INTO to copy the data to 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 4, 2015 at 6:21 am

#1837626
RE: Inherited HUGE db with limited disk space

Don't shrink it. It'll just make matters worse... MUCH worse and you still have disk space.
What's your maintenance for indexes and do you have any HEAP tables that are...
--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 3, 2015 at 4:35 pm

#1837504
RE: shrink huge datafile

Was this on purge some form of audit 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)

November 3, 2015 at 4:26 pm

#1837502
RE: Are the posted questions getting worse?

Man o man... yet another self-proclaimed DBA bites the dust in the interview process as has another self-proclaimed "expert" Database Developer. It amazing how they don't know what 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)

November 3, 2015 at 3:59 pm

#1837496
RE: Question/Advice needed Sliding Window partitioning range right,what the effecient way to implement/are staging tables needed

ChrisM@Work (11/3/2015)
Resender (11/3/2015)
In the meantime 123883 tables (yes 30 new tables got added) the total recordcount is
89,372,968,620
ChrisM@Work (11/3/2015)and how is this lot typically interrogated?
I wish I knew but I'm frequently...
--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 3, 2015 at 11:18 am

#1837447
RE: Question/Advice needed Sliding Window partitioning range right,what the effecient way to implement/are staging tables needed

Resender (11/3/2015)
ChrisM@Work (11/3/2015)
Resender (11/3/2015)
Total number of machine tables (3/11/2015 13:44 CET) 123851
Those tables are the same
[MachineRegisterId] [int] NOT NULL,
[UtcTime] [datetime] NOT NULL,
[Value] [float] NOT NULL
With primary key on 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)

November 3, 2015 at 11:13 am

#1837445
RE: Question/Advice needed Sliding Window partitioning range right,what the effecient way to implement/are staging tables needed

Resender (11/3/2015)
OK, not so good news then,the total size of the database currently is 1.9TB
Hold the phone a minute... While it's true that partitioning is NOT a panacea of performance...
--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 3, 2015 at 11:09 am

#1837444
RE: What's taking up all my disc space

Jeff Moden (11/3/2015)
DamianC (11/3/2015)
Hi
I have an overnight job that performs a lot of tasks
At a point in time, I am getting a message from our network department to say 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)

November 3, 2015 at 10:16 am

#1837418
RE: What's taking up all my disc space

DamianC (11/3/2015)
Hi
I have an overnight job that performs a lot of tasks
At a point in time, I am getting a message from our network department to say that 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)

November 3, 2015 at 8:52 am

#1837391
RE: Selecting text between set characters

Hmmm... HappyGeek's method will certainly do one number per row very efficiently but I thought you said there could be 5 to 9 such numbers per row. Did 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)

November 2, 2015 at 11:35 pm

#1837264
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Steve Jones - SSC Editor (11/2/2015)
Or someone should write an article looking at performance comparisons.
Heh... hint taken. 😉
--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 2, 2015 at 11:32 pm

#1837263
RE: Selecting text between set characters

les.61 (11/2/2015)
I have a table of data with lines of various lengths. An example is
A Smith - Give #12345# Sydney City
B Jones and S Jones - Give #876543# Washington
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)

November 2, 2015 at 7:05 pm

#1837252
RE: scrub data in 5 minute intervals

sqlstar2011 (11/2/2015)
I have a situation where I have table with over a billion records and needs to be scrubbed. Table does have a field with date time timestamp. I have...
--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 2, 2015 at 6:32 pm

#1837246

Viewing 15 posts - 19,261 through 19,275 (of 59,072 total)