Jeff Moden

Forum Replies Created

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

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

bkubicek - Wednesday, November 1, 2017 6:24 AM
That is an interesting thought. So exactly what sort of old stuff are you talking...
--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 6:51 pm

#1966331
RE: Are the posted questions getting worse?

Michael L John - Wednesday, November 1, 2017 2:43 PM
Can someone possibly be this thick?
https://www.sqlservercentral.com/Forums/1905649/HA-and-DR-Solution
Yes... and it's not that rare. ...
--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 3:15 pm

#1966325
RE: using DOS START command inside of xp_cmdshell

KTD - Wednesday, November 1, 2017 1:32 PM
Can I answer a question 11 years later?
Its a very picky thing but 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 1, 2017 at 2:52 pm

#1966321
RE: CASE Statement

Lynn Pettis - Wednesday, November 1, 2017 1:38 PM
If you are using SQL Server 2012, why aren't you using the TIME data...
--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 2:45 pm

#1966319
RE: Huge number of inserts vs number of reads

henrrypires - Wednesday, November 1, 2017 2:07 PM
it's 3 different XML files. I wrote a software that does some calculations and insert/update...
--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 2:39 pm

#1966316
RE: HA and DR Solution

ffarouqi - Wednesday, November 1, 2017 11:12 AM
Based on the discussions that we had internally we initially decided to move 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)

November 1, 2017 at 1:08 pm

#1966281
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

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