Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,056 through 11,070 (of 59,099 total)

RE: Connect QuickBooks to SQL Server through SSIS

jason.quackenbush - Wednesday, June 6, 2012 2:46 PM
I never said attempting to be misleading, I said flat out misleading. The fact it...
--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 5, 2018 at 8:19 am

#2008319
RE: Init-cap the characters in SQL server

This should be a function but the either the OP or the OP's DBA Team thinks they should be avoided because of some "Best Practice" someone found somewhere stating that...
--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 5, 2018 at 8:10 am

#2008317
RE: How to flip tables in sql server 2014

vikasjagadale8 - Friday, October 5, 2018 4:03 AM
Hello,
I have a requirement wherein there are 2 tables (Staging & Target) in the same...
--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 5, 2018 at 7:57 am

#2008314
RE: Max size file in BCP process

SATYA R - Friday, October 5, 2018 4:50 AM
HI All,
in file have around 100000 records but command was successful with 0 records....
--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 5, 2018 at 7:48 am

#2008308
RE: Max size file in BCP process

SATYA R - Thursday, October 4, 2018 7:47 AM
@sgmunson : Apologies for spell mistake.
Yes, I...
--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 4, 2018 at 10:29 pm

#2008249
RE: What Steps Woud You Take: Inserting 200,000 records

Unless the rows are insanely wide, a 200,000 row insert is pretty much a cake walk for your initial insert. And, it can be done using "Minimal Logging", which not...
--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 4, 2018 at 10:09 pm

#2008247
RE: finding previous 12 months data, not including current month

jeffshelix - Thursday, October 4, 2018 9:46 AM
on the 10th of each month i run a report for the 12 month period,...
--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 4, 2018 at 9:49 pm

#2008246
RE: Pulling Data from EAV table using recursion

We have no idea what you're table looks like, what indexes are available, nor any idea what the report is supposed to do/look like. A bit more of a description...
--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 4, 2018 at 9:43 pm

#2008245
RE: Inserting recrods fromt the same table with an incremental value on every insert

SQLTestUser - Wednesday, October 3, 2018 9:05 AM
When an insert happens i am trying to get the result as below, so i...
--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 4, 2018 at 9:38 pm

#2008244
RE: Index Seek is costing a lot in execution plan

dmbaker - Thursday, October 4, 2018 1:53 PM
Jeff Moden - Thursday, October 4, 2018 1:36 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 4, 2018 at 9:18 pm

#2008242
RE: How else can I view last queries run by anyone on an instance of SQL Server or a particular DB

VoldemarG - Tuesday, October 2, 2018 7:35 AM
Is there a way / TSQL to see last <N> queries run by anyone on...
--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 4, 2018 at 9:13 pm

#2008241
RE: Adding two fields together

michael.leach2015 - Thursday, October 4, 2018 7:27 PM
Thom A - Thursday, October 4, 2018 1:59 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 4, 2018 at 7:37 pm

#2008240
RE: Algorithm to combine 2 integer into one value and then disintegrate back into two

I guess I don't understand the desire to partition by two columns, never mind the PeriodYTD column. It would appear that the PERIOD column is based on month ending dates...
--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 4, 2018 at 7:03 pm

#2008238
RE: Are Indexes Actually Changes to the System?

patrickmcginnis59 10839 - Thursday, October 4, 2018 4:18 PM
REBUILDs remove free space below the Fill Factor and create free space above...
--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 4, 2018 at 4:42 pm

#2008232
RE: Are Indexes Actually Changes to the System?

It does exactly what it says so it's not a document error. It "compact{s}... based on the existing fill factor value". The documentation also clearly states that REORGANIZE will NOT...
--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 4, 2018 at 3:38 pm

#2008225

Viewing 15 posts - 11,056 through 11,070 (of 59,099 total)