Jeff Moden

Forum Replies Created

Viewing 15 posts - 991 through 1,005 (of 59,082 total)

Reply To: Extract file in zip format

André Silveira wrote:
So, I tried converting to "nvarchar(max)" and "varbinary(max)," but without success. Therefore, I had to resort to a more radical approach, which involved extracting data from the client's portal....
--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 31, 2023 at 7:36 pm

#4318495
Reply To: How do I add files to the server?

mjdemaris wrote:
So Jeff,
this sounds like a dumb question, but how do I insert a blob (image/pdf/doc) into the table via the SSMS? Do I need a CAST statement or an...
--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 31, 2023 at 6:42 pm

#4318460
Reply To: stats get updated even when query is trivial
Using the following code (your code with some stats measurements added), I'm not seeing any updates to the stats on the 600 row run.
```
--SELECT 500 + (0.20...
```
--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 31, 2023 at 4:19 am

#4317997
Reply To: SQL Service is not starting after upgrade...

us26 wrote:
This fixed the issue: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/install/windows/sql-server-upgrade-failed-error-15151 Thanks. I wonder would it be possible to use SQL Profiler (or XE) to find out this kind of issues? To detect the batch...
--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 29, 2023 at 6:14 pm

#4317126
Reply To: SQL Service is not starting after upgrade...

If doing what the error text you posted (checking the logs) brings no joy, I can think of no other recovery than to do restores from the backups of the...
--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 28, 2023 at 6:49 pm

#4316700
Reply To: Can trigger execution be excluded only for a particular login?

I believe the latter that you mention is the only way.
I also want to warn than none of what has done (according to what you've described) will hold up in...
--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 28, 2023 at 6:41 pm

#4316698
Reply To: Query related issue

Grant Fritchey wrote:
I'd need to see the execution plans to understand what's going on. Further, two different databases means, possibly, two different sets of data, two different sets of statistics, two...
--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 28, 2023 at 6:33 pm

#4316697
Reply To: Query related issue

Jeffrey Williams wrote:
Compatibility mode?
Sidebar: stop using DB..Table - specify the schema instead of expecting SQL Server to find the correct schema for the table. That is dependent on the default schema...
--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 28, 2023 at 3:08 am

#4316367
Reply To: How do I add files to the server?

Just a post to expose page 2 because of the forum fault in that area.

--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 27, 2023 at 9:10 pm

#4316216
Reply To: How do I add files to the server?

Mr. Brian Gale wrote:
While I agree with Jeff in the sense that "if the system is designed in one way, why change it to work a different way", I think I 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)

October 27, 2023 at 9:09 pm

#4316215
Reply To: How do I add files to the server?

To add another 2 cents, I totally agree with David Wiseman. Storing the full path instead of just a file name can be a horrible idea for the very reasons...
--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 27, 2023 at 8:48 pm

#4316214
Reply To: What happens when an online index rebuild (not resumable) is cancelled?

The only time that I've used ONLINE Index Rebuild was during testing on some test tables. I've never tested for a "cancel" of an ONLINE Rebuild like you folks accidentally...
--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 27, 2023 at 2:31 am

#4315703
Reply To: The Column Synonym

Jeffrey Williams wrote:
Jeff Moden wrote:
Jeffrey Williams wrote:
Imagine a view is created - that references a computed column which only exists to give the column a different name - and aliases the computed column...
--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 26, 2023 at 9:40 pm

#4315566
Reply To: How do I add files to the server?

I'll likely be alone on my take on this but "It Depends" on a whole lot of things.
When I first started at a company that I do work for, they...
--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 26, 2023 at 9:12 pm

#4315552
Reply To: Is SQL Search 3 still supported?

Heh... not bad for something that used to be natively available on the f4 key until they came out with SQL Server 2005. 🙁 What a bummer that was (and...
--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 26, 2023 at 7:43 pm

#4315507

Viewing 15 posts - 991 through 1,005 (of 59,082 total)