Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,861 through 13,875 (of 59,095 total)

RE: Migrate SQL Server to new server

89netanel - Wednesday, November 1, 2017 4:07 AM
Hello All,
I would like to upgrade my SQL Server 2012 to SQL Server 2016.
I created...
--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 1, 2017 at 9:03 am

#1966208
RE: SQL versus program

dmbaker - Wednesday, November 1, 2017 6:41 AM
Jeff Moden - Tuesday, October 31, 2017 8:09 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)

November 1, 2017 at 7:45 am

#1966191
RE: transactions per second multiple databases

jasona.work - Wednesday, November 1, 2017 6:42 AM
sqlguy80 - Tuesday, October 31, 2017 2:41 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)

November 1, 2017 at 7:43 am

#1966189
RE: How Far are You Willing To Go To Get Something?

Heh... amazing. People keep coming out with articles about how far will you go to "learn something new". Your article struck a bit of a cord with me because people...
--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)

October 31, 2017 at 9:35 pm

#1966106
RE: Need to zip files and load into Source Modified Date , Date folder.

Heh... "Basics". "Script Tasks". "Etc" 😉
Speaking of "Basics", none of this is difficult using a couple of DOS commands and properly controlled use of xp_CmdShell (think "script task"...
--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)

October 31, 2017 at 9:16 pm

#1966105
RE: Big Data

I've found that a lot people want to get on the "Big Data" band wagon because there's some pretty good money to be had there but they try to 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)

October 31, 2017 at 9:08 pm

#1966104
RE: Changing NVARCHAR to VARCHAR...

Arsh - Tuesday, October 31, 2017 2:09 PM
Thanks Eirikur and ZZartin .. It's a 600 GB database growing rapidly . The biggest...
--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)

October 31, 2017 at 8:52 pm

#1966102
RE: transactions per second multiple databases

sqlguy80 - Tuesday, October 31, 2017 6:39 PM
Hi,
OK I used this query and then waitfor delay 00:01:00 and re run 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)

October 31, 2017 at 8:28 pm

#1966097
RE: PURGING DATA

unas_sasing - Tuesday, October 31, 2017 10:21 AM
Jeff Moden - Tuesday, October 31, 2017 8:24 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)

October 31, 2017 at 3:55 pm

#1966081
RE: StartDate and EndDate in same column

@joe,
While I agree that you can not depend on some "natural" order in a table, that has nothing to do with storing something in the table to be...
--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)

October 31, 2017 at 3:48 pm

#1966080
RE: latest timestamp multiple databases

patrickmcginnis59 10839 - Friday, October 20, 2017 1:05 PM
Jeff Moden - Tuesday, October 17, 2017 8:06 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)

October 31, 2017 at 9:44 am

#1966004
RE: Fun Data Arithmetic

GD_515 - Tuesday, October 31, 2017 9:20 AM
Jeff Moden - Tuesday, October 31, 2017 8:54 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)

October 31, 2017 at 9:39 am

#1966001
RE: How to find the first recurring character of a string.

David Burrows - Tuesday, October 31, 2017 9:16 AM

WITH cte AS (
SELECT t.N,SUBSTRING(@Str,N,1) AS [C],
ROW_NUMBER() OVER (PARTITION BY SUBSTRING(@Str,N,1) ORDER BY...
--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)

October 31, 2017 at 9:33 am

#1966000
RE: Minimal Logging

hello mahesh - Tuesday, October 31, 2017 8:34 AM
Jeff Moden - Tuesday, October 31, 2017 8:27 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)

October 31, 2017 at 9:02 am

#1965992
RE: Fun Data Arithmetic

GD_515 - Tuesday, October 31, 2017 2:10 AM
ildjarn.is.dead - Tuesday, October 31, 2017 1:12 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)

October 31, 2017 at 8:54 am

#1965990

Viewing 15 posts - 13,861 through 13,875 (of 59,095 total)