Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,421 through 6,435 (of 59,089 total)

Reply To: I need all jobs, job steps and schedule for a particular database

coolchaitu wrote:
Can you please help me with the script. The script should take database name as an input parameter and should output all its related jobs, steps and schedules.
If you...
--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)

September 17, 2020 at 3:33 pm

#3789191
Reply To: Read Committed Snapshot Isolation and Blocking

kevaburg wrote:
Unfortunately this application doesn't work quite that simply. "Relativity" is an eDiscovery platform that allows users in the course of their work to add and remove fields that 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)

September 17, 2020 at 3:53 am

#3789036
Reply To: Wanting to learn

That's a great story, Grant, and I 100% agree that's was an appropriate use of PowerShell. The question is, would you have been comfortable in letting someone who didn't know...
--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)

September 16, 2020 at 8:27 pm

#3788985
Reply To: SQL 2014 Table Truncated Inadvertently

Grant Fritchey wrote:
Total agreement with everyone else that you should be spotting when new databases are created. However, it's entirely possible to create a backup script (or use Minion or Ola...
--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)

September 16, 2020 at 8:16 pm

#3788984
Reply To: SQL 2014 Table Truncated Inadvertently

First of all (and you probably all ready know this but I have to say it out loud), fix the main problem that started all of this... stop giving users...
--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)

September 15, 2020 at 10:10 pm

#3788699
Reply To: Oracle linked server mixing up result values

I'm thinking that the data has an embedded Cr, Lf, or Vertical Tab in it and OPENQUERY along with the given provider is treating what follows that as a separate...
--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)

September 15, 2020 at 10:01 pm

#3788698
Reply To: EF Code-First

wrote:
t is not the first time I am reading such a comment. I do not remember exactly where I saw it, possibly, om some local forums
You do realize that's...
--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)

September 15, 2020 at 9:53 pm

#3788696
Reply To: CONVERT COLUMN VALUES TO COMMA SEPARATED ONE ROW VALUE..

drew.allen wrote:
PS: You do realize that this thread is almost six years old.

An updated answer to an old question is still a good thing. Someone has already benefited from 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)

September 15, 2020 at 9:45 pm

#3788694
Reply To: CONVERT COLUMN VALUES TO COMMA SEPARATED ONE ROW VALUE..

You've posted in a 2005 forum. What version of SQL Server do you actually have?
--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)

September 15, 2020 at 7:55 pm

#3788669
Reply To: Wanting to learn

Grant and many others will seriously disagree with me but... My recommendation is that you don't spread your learning too thin. I've found that a whole lot of what people...
--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)

September 15, 2020 at 7:41 pm

#3788667
Reply To: The Challenges of Splitting a Table

I think the first step towards "vertical partitioning" is actually "proper normalization of a table".
I also think that people that have the following 3 columns (as identified in the Reddit...
--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)

September 15, 2020 at 4:18 pm

#3788599
Reply To: How do I utilise fewer cores?

Rhys wrote:
Hi - I would like to decrease the performance of SQL for certain users or specific queries.
The majority of users will be running very quick queries that last less...
--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)

September 15, 2020 at 3:53 pm

#3788587
Reply To: Writing a software development Proposal.

Brian hit a nail on the head that I totally forgot about and that's to be sure you include what he said about support, what's supported or not, and 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)

September 15, 2020 at 3:48 pm

#3788586
Reply To: Sql Queries

I could be wrong but most of the code looks like it takes in some form of CSV and splits it. Since you're using SQL Server 2019, lookup the STRING_SPLIT...
--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)

September 15, 2020 at 3:41 pm

#3788584
Reply To: restore from azure blob
Johan Bijnens wrote:
- Can you show the result of
```
Restore HeaderOnly from url= ... ?
```
  ?
- Keep in mind you...
--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)
September 15, 2020 at 3:32 pm

#3788577

Viewing 15 posts - 6,421 through 6,435 (of 59,089 total)