Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,121 through 6,135 (of 59,089 total)

Reply To: Building Bad Software Faster

The ability to deploy faster has done nothing for the quality of code, IMHO. I know you didn't say that in your good article but seem to be leaning 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)

November 9, 2020 at 5:23 am

#3805823
Reply To: How to use" insert bulk " to insert data for a table

You're welcome and thank you for the feedback.
--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)

November 9, 2020 at 5:06 am

#3805822
Reply To: Mass Value changed on Value after float point When convert from float to varcha?

My first question would be, why are you using FLOAT to begin with?
--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)

November 9, 2020 at 12:51 am

#3805781
Reply To: Wildcard % % Performance

alic wrote:
This will use an index seek but the problem is for it to work I need to use substring or a left to get the rest of the start...
--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)

November 8, 2020 at 10:39 pm

#3805756
Reply To: Looking for ideal solution for nightly replication of database for reporting

I can't speak for others but I find that anything that relies on log files for replication is a huge PITA, especially when it comes time to doing index maintenance.
--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)

November 8, 2020 at 8:19 pm

#3805744
Reply To: SQL Full text query too slow

ruifrazao wrote:
If I concatenate the varchar columns into a single column, I will (almost) duplicate the table size. That don’t look so good either and I don't like this idea...
--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)

November 8, 2020 at 4:07 pm

#3805707
Reply To: Looking for ideal solution for nightly replication of database for reporting

homebrew01 wrote:
4T in a few seconds !?!?
Yes. No typo's there.
--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)

November 8, 2020 at 3:28 pm

#3805696
Reply To: Reporting Services Unable to Export to PDF, EXCEL, WORD, POWERPOINT in Clients

I don't know what's causing the problem (although it may be "just" a missing driver on the app/client side) but my first thought is to get that firewall back up...
--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)

November 7, 2020 at 3:29 am

#3805144
Reply To: Looking for ideal solution for nightly replication of database for reporting

If the boxes use the same SAN, check with the SAN folks or vendor. There is such a thing as "SAN Snapshots". My first exposure to it was way back...
--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)

November 7, 2020 at 3:22 am

#3805143
Reply To: comma issues in sql statement

As a bit of a sidebar, your WHERE clauses for the start (>=) and end dates (<) are CORRECT. Your calculation for end date is not. You could miss some...
--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)

November 7, 2020 at 3:09 am

#3805142
Reply To: UNION ALL Question

I have no reasonable explanation without being able to see an "actual execution plan". I also understand that circumstances won't allow you to post one for this problem.
However, a possible...
--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)

November 7, 2020 at 2:51 am

#3805140
Reply To: How to use" insert bulk " to insert data for a table

892717952 wrote:
I used SQL profile to trace SQL Statement and found user use insert bulk to insert data for a table, but the sql statment is too long (over 4000)...
--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)

November 6, 2020 at 8:58 pm

#3805077
Reply To: Question about Data Warehouse

RoxyLightning wrote:
Grant, Thank You for your thoughtful reply. This will help me formulate better questions on my next post. My goal is to find better solutions and learn new techniques...
--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)

November 6, 2020 at 7:15 pm

#3805062
Reply To: SQL Full text query too slow

To be honest, I've never seen anyone use it in the manner you've just described and that was a misunderstanding on my part because I've only used it for columns...
--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)

November 6, 2020 at 3:52 pm

#3805020
Reply To: SQL Full text query too slow

To be honest, the column names are a bit cryptic but making some guesses about the column names, I'd say that the DES_OBSR_ENTD is likely the only column that would...
--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)

November 6, 2020 at 2:27 pm

#3804993

Viewing 15 posts - 6,121 through 6,135 (of 59,089 total)