Jeff Moden

Forum Replies Created

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

RE: The Single Pane of Glass

It certainly doesn't apply to everyone but I've found a lot of people that have such proverbial "Single Pane of Glass" tools either don't know how to use 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)

October 5, 2018 at 8:50 am

#2008326
RE: Are the posted questions getting worse?

TomThomson - Thursday, October 4, 2018 3:27 PM
I find it very depressing - people should not be stuck into jobs like...
--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:45 am

#2008323
RE: Are the posted questions getting worse?

TomThomson - Friday, October 5, 2018 8:13 AM
Eirikur Eiriksson - Wednesday, September 26, 2018 7:48 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 5, 2018 at 8:40 am

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

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