Jeff Moden

Forum Replies Created

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

Reply To: Solving Real Problems

From the article...
Extended Events, just for example, is wildly superior to Profiler/Trace.
Heh... NOT! 😀 But we'll save that discussion for another time.
I agree with a whole lot that you've...
--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 11:47 pm

#3789291
Reply To: when to use Python in SQL Server

My comment would be to not use Python to duplicate what can be done in SQL Server. Only use it if you have something that SQL Server can't do well...
--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 11:38 pm

#3789290
Reply To: Insert vs Update

Since the tables are being truncated and then repopulated by inserts, they'll be pretty well packed at the page level of nearly 100% page fullness before they get hit 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)

September 17, 2020 at 11:10 pm

#3789284
Reply To: My Weekly Full Transaction Log Backup and Shrink Keeps Killing my Log Shipping

mjvisintin wrote:
Okay,
Thanks,
I thought it was just growing because we are putting so much data in there and that involves a transaction.
So you are indicating that they would be committed 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)

September 17, 2020 at 5:23 pm

#3789220
Reply To: My Weekly Full Transaction Log Backup and Shrink Keeps Killing my Log Shipping

mjvisintin wrote:
My Weekly Full Transaction Log Backup and Shrink Keeps Killing my Log Shipping by throwing it out of synch.
No matter when I try to time it, it throws of...
--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 4:29 pm

#3789213
Reply To: SQL 2014 Table Truncated Inadvertently

I see nothing wrong with such a DDL trigger to detect when a new database was created... but I wouldn't rely on it to make sure backups are performed. 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)

September 17, 2020 at 4:24 pm

#3789212
Reply To: How to find size of each filegroup?

coolchaitu wrote:
How to find size of each filegroup?
At least try to help yourself...
https://www.google.com/search?q=How+to+find+size+of+each+filegroup%3F
--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 4:13 pm

#3789210
Reply To: Insert vs Update

Without seeing the actual execution plans of the parts that are taking the longest, we're all just "guess'n and suggest'n". You need to figure out what the "high points" 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)

September 17, 2020 at 4:08 pm

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

p.s. I also agree with Phil... if you have SSIS, SSAS, and other SQL "4 letter words" involved in jobs, this could end up being a fair bit more difficult...
--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:36 pm

#3789194
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

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