Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,106 through 6,120 (of 59,072 total)

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
Reply To: SQL Full text query too slow

ruifrazao wrote:
Jeff Moden wrote:
Why does your code setup full text catalogues on EVERY VARCHAR column in the table? Is that really necessary? Depending on the schema of your table, that could...
--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 5, 2020 at 1:54 pm

#3804579
Reply To: High buffer size for a table could mean either it has incorrect indexes or ?

To complete the sentence you started in the title... "Crap Code" consisting of a lot or just a few common problems, insufficient indexes, improper joins, incorrect criteria, poor table/database design...
--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 5, 2020 at 8:04 am

#3804522
Reply To: merge data

I know this sounds a bit "smarty pantsed" but, in order to not have PK conflicts, you have to stop sending or pulling... PK conflicts.
In other words, you need 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)

November 4, 2020 at 11:39 pm

#3804444
Reply To: SQL Full text query too slow
For some reason (perhaps someone clicked on report instead of reply by accident), my previous post was reported as spam, so trying again...
I have a couple of questions...
1. Why does...
--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 4, 2020 at 11:20 pm

#3804440
Reply To: SQL Full text query too slow

I guess my question would be... why are you creating a full text catalog for EVERY VARCHAR in the table?
I'll also ask why you're using code that has been deprecated...
--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 4, 2020 at 5:34 pm

#3804319
Reply To: Large objects data type issues

bobrooney.81 wrote:
Hi Jeff,
I still didn't understand in what type of pages will the LOB data get stored ? apart from 8k data page are there any other type of pages...
--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 4, 2020 at 2:39 pm

#3804244
Reply To: I/O Statistics by file per database?

Why not just use sp_WhoIsActive for that stuff? It's free.
Like I said before, knowing which files are the most active won't tell you a thing about what your problems 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)

November 3, 2020 at 9:14 pm

#3804032

Viewing 15 posts - 6,106 through 6,120 (of 59,072 total)