Jeff Moden

Forum Replies Created

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

RE: Inserts slow down as table grows(partitioned table).

mtaylor7210 63514 - Monday, January 16, 2017 4:51 AM
I have a table that is partitioned by month, I'm loading the table from another...
--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 16, 2017 at 4:55 pm

#1923073
RE: DECLARE multiple vars with default value

t.franz - Monday, January 16, 2017 1:12 AM
t.franz - Sunday, January 15, 2017 8:06 AM
Comments posted...
--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 16, 2017 at 4:47 pm

#1923072
RE: Tuning big table

nadersam - Monday, January 16, 2017 3:19 AM
DesNorton - Monday, January 16, 2017 3:11 AM
--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 16, 2017 at 4:45 pm

#1923071
RE: A Possible Alternative to SQL UNPIVOT

paul_milligan01 - Sunday, January 15, 2017 10:12 PM
Comments posted to this topic are about the item A Possible Alternative to SQL UNPIVOT
I'm...
--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 16, 2017 at 4:16 pm

#1923064
RE: Killing Statistics Jobs

Stewart "Arturius" Campbell - Monday, January 16, 2017 12:10 AM
Interesting question, thanks Steve
I agree with Jeff on this one - this is one...
--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 16, 2017 at 10:47 am

#1923030
RE: Data Archive

VastSQL - Sunday, January 15, 2017 11:28 PM
Lowell - Sunday, January 15, 2017 5:44 AM
After 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)

January 16, 2017 at 10:30 am

#1923024
RE: SSC Forum Updates

Another problem discovered. There is no way that I've made 2687 posts in the last 30 days that the "Top Members (Last 30 days)" sub window on the home page says...
--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 16, 2017 at 10:23 am

#1923023
RE: what user membership to assign?

Senchi - Saturday, January 14, 2017 11:36 PM
actually, it seems a better option to make all new users database owners and only if...
--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 15, 2017 at 1:18 pm

#1922815
RE: FTP Task

If the FTP server is in the same domain as the archive server that the department share lives on, then a DOS (ROBOCOPY likely the best) or PowerShell command would...
--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 15, 2017 at 11:12 am

#1922810
RE: Data Archive

And, rebuilding the indexes will NOT reclaim the space reserved for the database. Of course, you should always have a bit of headroom in your database so that you don'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)

January 15, 2017 at 11:09 am

#1922809
RE: DECLARE multiple vars with default value

Just so people don't get confused, the question was about what happens when you try to make a cascading assignment using DECLARE. The same does NOT hold true for making...
--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 15, 2017 at 11:01 am

#1922808
RE: Function - Word count in a sentence

ErcÃ¼ment EÅŸkar - Friday, November 11, 2016 12:43 AM
Thank you for script.But it's need to SqlServer 2012 because of lag function.why not just...
--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 15, 2017 at 10:41 am

#1922806
RE: Bring data from one server to another server

SQL-Learner - Thursday, January 12, 2017 7:15 PM
Hi,
I have a few tables in one server which contains huge amount of data lets say...
--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 14, 2017 at 11:14 pm

#1922786
RE: SSC Forum Updates

DamianC - Friday, January 13, 2017 8:26 AM
How do you format code now?
I used to just use copy and paste between code markers
Code markers...
--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 14, 2017 at 11:01 pm

#1922785
RE: DBAs Need to Learn to Develop

I know this post is 3 years old but I get a real laugh out of the title every time I run across it as I mutter "So do developers"....
--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 14, 2017 at 10:42 pm

#1922783

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