Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,501 through 1,515 (of 59,067 total)

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
Reply To: Lookup table without modifying database

Jason A. Long wrote:
That’s the thing about tempdb, it’s true to it’s name. Nothing you put there is truly permanent. By using normal create commands in tempdb you don’t have to worry...
--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:41 am

#4181829
Reply To: Lookup table without modifying database

I would say... don't make it a permanent table in TempDB. It may be justification for them to commit homicide and hide the body.
--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 29, 2023 at 12:50 am

#4181319
Reply To: Lookup table without modifying database

If you use INSERT/SELECT FROM (VALUES)x(somecol1, somecoletc...), there appears to be no limit. I've done 50,000 rows as a one-off.
You could make a temporary Linked Server to your machine. 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)

April 28, 2023 at 4:17 pm

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

below86 wrote:
I'd love to come see that Jeff, but with other commitments I will not be able to attend. I hope that there will be a recording that we might...
--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 28, 2023 at 3:59 pm

#4181128
Reply To: Updating a sql 2019 database from a sql 2000 database

jassem40 wrote:
Good morning
I have a local sql server 2000 database with an old application, and I would like to make a copy of this database on sql server 2019 which...
--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 28, 2023 at 12:36 pm

#4181050

Viewing 15 posts - 1,501 through 1,515 (of 59,067 total)