Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,316 through 9,330 (of 59,091 total)

Reply To: NOT IN with OpenRowSet

TJ_T wrote:
I have no choice. I can't - not allowed to store in a table. I have to use a text file 🙁 I have been trying LTRIM and no...
--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)

May 12, 2019 at 2:03 am

#3640738
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
Considering the recent events on this site and the huge losses in functionality, you're preaching to the choir there. 😉 The impetus seems to have been...
--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)

May 12, 2019 at 1:11 am

#3640718
Reply To: NOT IN with OpenRowSet

TJ_T wrote:
Yes I thought of LTRIM - just wasn't sure how to do it with this query:
That was my main question and you've not answered it yet. Why 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)

May 12, 2019 at 12:51 am

#3640712
Reply To: backup failed

atulyan.aries wrote:
Hello Team, I'm getting the following error: BACKUP failed to complete the command BACKUP DATABASE db name. Check the backup application log for detailed messages. In our system...
--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)

May 11, 2019 at 11:16 pm

#3640688
Reply To: SAN backups vs SQL Server native

To personify what Sergiy stated, I worked for a company that insisted that they didn't need native backups because they were doing "San Snapshots" every 20 minutes. I insisted 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)

May 11, 2019 at 9:44 pm

#3640659
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
The lessons of loss just don't rub off until someone experiences the issue themselves. No idea how to teach this, other than to provide some examples and try 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)

May 11, 2019 at 9:10 pm

#3640647
Reply To: Are the posted questions getting worse?

Grant Fritchey wrote:
I'm doing a precon at Columbus. SPEND YOUR MONEY!!!!!

Heh... Grant is fantastic at teaching but sucks when it comes to self promotion or promotion for a cause. 😀 :D...
--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)

May 11, 2019 at 8:32 pm

#3640640
Reply To: Delete is very slow

Guras wrote:
Thank you I will try this.

You really need to answer the questions about how many indexes there are. You'll also need to identify how many foreign keys there 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)

May 11, 2019 at 8:02 pm

#3640633
Reply To: NOT IN with OpenRowSet

TJ_T wrote:
This almost works: WHERE ModelName0 NOT IN ( SELECT value FROM String_Split(@Job_numbers, ',') ) But when you run the query it builds a list, but after the first row...
--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)

May 11, 2019 at 7:56 pm

#3640626
Reply To: Are the posted questions getting worse?

frederico_fonseca wrote:
Grant Fritchey wrote:
Thom A wrote:
In other news, what do you do when 2 CLI languages for your OS's isn't enough: Introduce a third: https://devblogs.microsoft.com/commandline/introducing-windows-terminal/ I admit I haven't read too far...
--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)

May 11, 2019 at 3:42 pm

#3640496
Reply To: General SQL Development Question.

koti.raavi wrote:
Jeff - Destination is unknown, we just need to place file in network location in specific format requested by destination team.
There could be a serious advantage in doing this...
--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)

May 11, 2019 at 1:44 pm

#3640461
Reply To: Are the posted questions getting worse?

jasona.work wrote:
Jeff Moden wrote:
Just to be sure, are you talking about Columbus or Pittsburgh? I'm assuming "Columbus" because i don't believe Pittsburgh has announced yet.
Columbus, Pittsburgh would be 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)

May 10, 2019 at 11:07 pm

#3640199
Reply To: Monitor network traffic

Chitown wrote:
Is there a way to monitor network bandwidth on a SQL Server? My network admin is telling me that we r using over 1 terabyte of bandwidth per hour...
--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)

May 10, 2019 at 4:18 pm

#3639994
Reply To: User notices on SSMS

EamonSQL wrote:
Hi, I manage a server and would like to know is there a way of placing a small message that sits in view of all users connected to 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)

May 10, 2019 at 4:12 pm

#3639992
Reply To: Are the posted questions getting worse?

jasona.work wrote:
Well that's just DUCKY!
Is that a good thing, a bad thing, or are you just "quackin' up"? 😀

jasona.work wrote:
Signed up (hotel and everything!) for this SQL Saturday, 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)

May 10, 2019 at 1:14 pm

#3639849

Viewing 15 posts - 9,316 through 9,330 (of 59,091 total)