Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,901 through 15,915 (of 59,098 total)

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
RE: Powershell Script for regular DBA activities

Such utilities can be easily used by the developers in the team without making them approach to DBA for such tasks on various development or testing environments.
Who fixes...
--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:36 pm

#1922781
RE: Upgrade Architecture Mismatch

mceventphoto - Saturday, January 14, 2017 7:28 PM
I am trying to upgrade SQL Server 2012 Developers Edition (32 Bit) to SQL Server 2012 Standard...
--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:02 pm

#1922780
RE: DBAs Need to Learn to Develop

TomThomson - Saturday, January 14, 2017 6:58 PM
Jeff Moden - Tuesday, December 13, 2016 7:53 AM
On...
--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 9:47 pm

#1922779
RE: Sum of Rows per a unique id

The comments in the code below explain how this can be done. Also, see the first link under "Helpful Links" in my signature line for how to post to get...
--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 9:06 pm

#1922778
RE: Writing the Correct Query is Important

Considering recent events, I think it terribly ironic that you published this particular article at this particular time.
--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 8:23 pm

#1922777
RE: are there dark themes available?

BWAAA-HAAAA!!!! Insane for having a white background? I depend on the White background to provide enough light so that I can find my pizza at night! 😉
You CAN...
--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 6:28 pm

#1922770
RE: Table Space Related Question

KGJ-Dev - Friday, January 13, 2017 1:11 PM
00000
Hi Jeff,
Thank you for your time on this post and could you please elaborate your...
--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 3:02 pm

#1922761
RE: Table Space Related Question

KGJ-Dev - Friday, January 13, 2017 10:37 AM
Hi,
I have a table with 100 * 1000 rows now and this will grow by 10k...
--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 1:24 pm

#1922757
RE: what user membership to assign?

A better thing to do, in many cases, is to use Windows Active Directory Groups. Then, you only need to assign the group privs once in SQL Server since 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)

January 14, 2017 at 1:21 pm

#1922756
RE: Table Space Related Question

Grant Fritchey - Saturday, January 14, 2017 9:19 AM
KGJ-Dev - Friday, January 13, 2017 8:28 PM
--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 1:04 pm

#1922754

Viewing 15 posts - 15,901 through 15,915 (of 59,098 total)