Forum Replies Created
Viewing 15 posts - 12,691 through 12,705 (of 59,099 total)
-
RE: who is sysadmin
goher2000 - Friday, March 16, 2018 6:02 PMThanks guys for your input , lets not get confused by why I need itWithout...
--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)March 17, 2018 at 1:58 pm
-
RE: I struggle with where clause and dates hoping for some help
randyetheridge - Friday, March 16, 2018 4:11 PMpartitionkey is a field in tdataseg
picture below of table tdataseg
I was looking for...
--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)March 16, 2018 at 5:08 pm
-
RE: who is sysadmin
Sue_H - Friday, March 16, 2018 4:19 PMJeff Moden - Friday, March 16, 2018 3:26 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)March 16, 2018 at 5:06 pm
RE: Your Thoughts On In-line SQL
RenoChris - Friday, March 16, 2018 2:21 PMJeff Moden - Friday, March 16, 2018 1:56 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)March 16, 2018 at 4:52 pm
RE: I struggle with where clause and dates hoping for some help
randyetheridge - Friday, March 16, 2018 3:43 PMthis is my from where SQL statement
--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)March 16, 2018 at 4:07 pm
RE: OPENROWSET and "Could not find installable ISAM"
kevaburg - Friday, March 16, 2018 1:02 AMHi Folks,I have a problem with regards to querying an Excel Spreadsheet using not only...
--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)March 16, 2018 at 3:42 pm
RE: OPENROWSET and "Could not find installable ISAM"
sgmunson - Friday, March 16, 2018 6:34 AMIt's that kind of thing that usually forces me into SSIS. And at times, when...--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)March 16, 2018 at 3:33 pm
RE: who is sysadmin
goher2000 - Friday, March 16, 2018 2:44 PMYes I am manually running in SSMS, I am in windows group which has sysadmin,...--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)March 16, 2018 at 3:26 pm
RE: Your Thoughts On In-line SQL
bkubicek - Friday, March 16, 2018 2:00 PMJeff Moden - Friday, March 16, 2018 1:56 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)March 16, 2018 at 2:03 pm
RE: Tempdb full
ramyours2003 - Friday, March 16, 2018 3:04 AMI would like to know the transactions which caused the tempdb full on the last...--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)March 16, 2018 at 2:00 pm
RE: Your Thoughts On In-line SQL
RenoChris - Friday, March 16, 2018 1:12 PMGenerally I like stored procedures too for many of the reasons already mentioned. One real...--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)March 16, 2018 at 1:56 pm
RE: Your Thoughts On In-line SQL
bkubicek - Friday, March 16, 2018 1:16 PMRenoChris - Friday, March 16, 2018 1:12 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)March 16, 2018 at 1:24 pm
RE: Using Bulk Insert or OPENROWSET to Import a CSV File
Chris Harshman - Friday, March 16, 2018 11:58 AMOK, while I wasn't able to find a solution using BULK INSERT, OPENROWSET, or...--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)March 16, 2018 at 12:17 pm
RE: Using Bulk Insert or OPENROWSET to Import a CSV File
alex.sqldba - Friday, March 16, 2018 10:28 AMHi Jeff,
I was only joking about banning CSV's.In regard to the header guff that appears...
--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)March 16, 2018 at 12:15 pm
RE: Replacing hidden characters
Chris Hurlbut - Friday, March 16, 2018 6:52 AMJeff wrote:And please understand that I'm not slamming you. Please consider this 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)March 16, 2018 at 7:02 am
Viewing 15 posts - 12,691 through 12,705 (of 59,099 total)