Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,791 through 14,805 (of 59,101 total)

RE: Are the posted questions getting worse?

Brandie Tarvin - Monday, July 10, 2017 5:30 AM
GAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHHHHHHHHHH.
Let me ask you. If you had a preference, take some time at 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)

July 10, 2017 at 5:58 am

#1950145
RE: SUBSTRING and CHARINDEX query.... please help.

Ed Wagner - Saturday, July 8, 2017 10:51 PM
Jeff Moden - Saturday, July 8, 2017 7:34 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)

July 10, 2017 at 5:20 am

#1950138
RE: SUBSTRING and CHARINDEX query.... please help.

OMG... after working with SQL Server for decades, MS has finally done something about one of my decades-old wishes. They've made OPENROWSET handle "true CSV" (RFC 4180 compliant) files. ...
--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)

July 8, 2017 at 7:34 pm

#1950090
RE: Disk space report showing wrong results

vsamantha35 - Monday, July 3, 2017 12:12 PM
Thanks Jeff and Steve. Bang on! IT was security issue.
Thank you for the feedback. Glad...
--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)

July 8, 2017 at 7:14 pm

#1950089
RE: What's the best way to get a sample set of a big table without primary key?

halifaxdal - Tuesday, July 4, 2017 4:51 PM
Jeff Moden - Tuesday, July 4, 2017 10:14 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)

July 8, 2017 at 7:00 pm

#1950088
RE: Trigger for Auditing

Jeff Moden - Thursday, July 6, 2017 10:19 PM0oi]
Jeff Moden - Thursday, July 6, 2017 10:19 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)

July 8, 2017 at 6:54 pm

#1950087
RE: Index-Filegroup (how many Files)

Jeff Moden - Friday, July 7, 2017 9:30 AM
info 58414 - Thursday, July 6, 2017 1:41 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)

July 8, 2017 at 6:04 pm

#1950086
RE: Index-Filegroup (how many Files)

GilaMonster - Friday, July 7, 2017 10:13 AM
Ok Jeff, I'll interrupt my Friday evening... 🙂
There's two main reasons to split up 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)

July 8, 2017 at 6:03 pm

#1950085
RE: Frustrating Programming Policies

crow1969 - Friday, July 7, 2017 12:00 PM
Heh. Doing all the calculations on the front end reminds me of how many applications...
--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)

July 8, 2017 at 5:12 pm

#1950084
RE: Simple/Easy Way To Test Stored Procedures And Functions

vincentshanecurtis - Friday, July 7, 2017 3:38 PM
I've used MS Access Oracle and some others. I'm a former DoD employee and we...
--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)

July 8, 2017 at 5:01 pm

#1950083
RE: Need some pointers in the right direction Excel to SQL

Whiteshadow - Wednesday, July 5, 2017 7:06 AM
At the moment they are using Excel for preparing the CSV files that are used...
--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)

July 7, 2017 at 10:19 pm

#1950054
RE: Simple/Easy Way To Test Stored Procedures And Functions

vincentshanecurtis - Thursday, July 6, 2017 4:42 AM
I'm fairly skilled with SQL but fairly new to SQL Server...
What flavor of SQL 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)

July 7, 2017 at 9:46 am

#1949973
RE: Index-Filegroup (how many Files)

info 58414 - Thursday, July 6, 2017 1:41 AM
Hi,
I have created an index filegroup (NonClustered) on a separate device.
How many files...
--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)

July 7, 2017 at 9:30 am

#1949966
RE: Index-Filegroup (how many Files)

Kenny Jozi - Friday, July 7, 2017 6:37 AM
One file per file group provided you going to put the on separate disks...
--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)

July 7, 2017 at 9:26 am

#1949964
RE: Trigger for Auditing

TheSQLGuru - Wednesday, July 5, 2017 7:23 AM
Jeff Moden - Wednesday, July 5, 2017 6:46 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)

July 6, 2017 at 10:19 pm

#1949842

Viewing 15 posts - 14,791 through 14,805 (of 59,101 total)