Jeff Moden

Forum Replies Created

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

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
RE: How to convert Large text file to Excel

It seems simple enough. Load the file into one huge table that also has an identity column. Take subsets of a million rows at a time and export them to...
--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 5, 2017 at 7:29 am

#1949470
RE: How to find Week start date and Week end date

karthik M - Tuesday, March 3, 2009 3:37 AM
Hi All,Thanks for all your inputs!:)I found the solution.Declare @InputDate Datetimeselect @InputDate = '02/mar/2009'select...
--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 5, 2017 at 6:55 am

#1949456
RE: A Database Design Test

For most interviews I've conducted, we never get to design questions because they don't even know how to get the bloody current date and 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)

July 5, 2017 at 6:51 am

#1949455
RE: Trigger for Auditing

Talib123 - Wednesday, July 5, 2017 4:41 AM
Probably been asked before but if I want to create a trigger for DML auditing...
--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 5, 2017 at 6:46 am

#1949450

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