Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,516 through 1,530 (of 59,082 total)

Reply To: Script to import BACPAC file?

Grant Fritchey wrote:
Through SQL? No. It's a command line driven process. Powershell is how I would do it. Check out DBATools.
As a bit of a sidebar, it's a real shame...
--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 5, 2023 at 2:22 pm

#4184791
Reply To:

Grant Fritchey wrote:
Were both these generated by ChatGPT?
Heh... and so it begins. 🙁
Grant Fritchey wrote:
Oh, and the ChatGPT answer suggests using Profiler. That's flat out wrong, assuming SQL Server 2012 or greater....
--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 5, 2023 at 1:23 pm

#4184761
Reply To: generate script for table contents

cphite wrote:
The second server in this case is on an environment that is essentially an exact snapshot of our production environment, which is taken over the weekend.
I'm totally confused...
--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 5, 2023 at 1:17 pm

#4184760
Reply To: How To Enumerate Hierarchical Info on SP calls

YSLGuru wrote:
You must have VIEW DEFINITION permission and I bet I don't. I'm testing this on our cloud based DB from our app provider using my surface laptop and we...
--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 5, 2023 at 1:13 pm

#4184759
Reply To: How To Enumerate Hierarchical Info on SP calls

The old article you found in a previous response to your question used sysdepends, which would sometimes miss things depending on the order of creation. Take a look at 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)

May 5, 2023 at 3:49 am

#4184515
Reply To: Index Creation for large table failed.
1. I forgot about table partitioning. That answers my question there.
2. If the database is in the FULL Recovery Model, I recommend temporarily shifting to the BULK LOGGED Recovery Model...
--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 5, 2023 at 3:38 am

#4184513
Reply To: Index Creation for large table failed.
JasonO wrote:
I'm trying to create a clustered index on a very large heap table. Below is the script i'm using to perform the creation job.
```
CREATE CLUSTERED INDEX...
```
--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 5, 2023 at 1:53 am

#4184471
Reply To: generate script for table contents

I just use BCP OUT using the Native format and then either BCP or BULK INSERT to import it on the target. Obviously, there needs to be a folder somewhere...
--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 4, 2023 at 11:49 pm

#4184445
Reply To: unable to connect to SQL2005 Cluster via instance name with Microsoft Intune pc

Johan Bijnens wrote:
indeed.
Been there, did that.
You can bring a horse to the water, but you cannot make it drink.
You can if you hold its head underwater and hook a shop-vac 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)

May 2, 2023 at 2:35 pm

#4182956
Reply To: How to record the command or stored produre called by linked server

As a bit of a sidebar and without knowing the particulars, it's pretty much a worse practice to make calls within a stored procedure to an actual IP address. If...
--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 2, 2023 at 2:26 pm

#4182944
Reply To: Article review timeline

Awesome. Looking forward to 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)

May 1, 2023 at 7:00 pm

#4182500
Reply To: Ohio North SQL Saturday - Akron Ohio - 20 May 2023

Thanks, Michael.
--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 1, 2023 at 6:59 pm

#4182499
Reply To: Ohio North SQL Saturday - Akron Ohio - 20 May 2023

Michael L John wrote:
I submitted a few sessions, got accepted, and realized that I had a conflict that weekend!!!!!!!!!!!!!!
You've let Paul P. know, correct?
--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 1, 2023 at 2:41 am

#4182159
Reply To: Convert Dates for XML

I know what you were looking for but there's actually no correct answer because of the VARCHAR(20) thing. The correct format of the correct answer is 23 characters long 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 1, 2023 at 1:34 am

#4182140
Reply To: Export SQL Data Classification Recommendations

To be honest, though, the tool seems to be based only on column names. It doesn't actually look for columns that, for example, look for 9 digit number or strings...
--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)

April 30, 2023 at 3:58 am

#4181830

Viewing 15 posts - 1,516 through 1,530 (of 59,082 total)