Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,391 through 3,405 (of 59,086 total)

Reply To: Building a front end for a database

verdas wrote:
Hello everyone!
I'm a beginner with databases and I'm getting started with building a front end for my database so that end users can add/edit data. I've been trying 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)

June 5, 2022 at 5:37 am

#4044489
Reply To: Iterate and reorganize subset of database tables

ktflash wrote:
Or how does the REBUILD over there interact with action thats happening on the server? from what ive been told its a very active table even at night when...
--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)

June 5, 2022 at 5:30 am

#4044488
Reply To: Fully Qualifying Server

I'd also suggest using OPENQUERY instead of just EXECUTE. Or, like you said, EXECUTE AT.
--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)

June 5, 2022 at 5:16 am

#4044483
Reply To: how to get csv files from zip file

There's gotta be a way to read the manifest of files from a zip file in SSMS. Almost everything else has that capability.
--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)

June 5, 2022 at 5:08 am

#4044482
Reply To: Alter Huge Table

And, NO... don't create the Non-Clustered Indexes before hand. I've never seen it work like MS says it "could" work. Having Non-Clustered indexes will make it so that the transfer...
--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)

June 5, 2022 at 5:05 am

#4044481
Reply To: Alter Huge Table

BAM wrote:
Hello Johan,
Thanks for your help.
I tried again to create a new column with VARCHAR(max) and to copy the data from the old column to the new column via 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)

June 5, 2022 at 5:01 am

#4044468
Reply To: Alter Huge Table

frederico_fonseca wrote:
homebrew01 wrote:
If the database is FULL recovery, would it help to run t-log backups frequently during the process, to prevent a huge t-log ?
if insert is done in one...
--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)

June 5, 2022 at 4:52 am

#4044462
Reply To: Can an Index improve tempdb high usage ?

Lou wrote:
Hi All,
Imagine a scenario where a datawarehouse database is working and, at the same time, limited disk space in our tempdb system database.
When any process runs that loads data...
--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)

June 5, 2022 at 4:40 am

#4044461
Reply To: Database Log File

AER wrote:
To Homebrew01:
I thought so too. And it does. But it releases the used space during restore. I need the mimic of the original database. You would think that restore...
--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)

June 5, 2022 at 4:16 am

#4044458
Reply To: when save float numbers it converted to IE so how to solve this issue ?

Look up the DECIMAL DATATYPE IN SQL SERVER on your favorite search engine so that you'll understand that all you need to do is change the "scale" and maybe 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)

June 5, 2022 at 4:07 am

#4044457
Reply To: Max data based on month

LearnSQL wrote:
Thanks Phils! But i really forgot to add an important point here what if the same emp for month 1 and month 3. Here 210 in M1 and M3.
--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)

June 2, 2022 at 8:38 pm

#4043443
Reply To: autokill for SSMS

abdalah.mehdoini wrote:
Hello I am looking for a way to do an autokill for all requests launched from sql server management studio and which exceeds one hour thanks for your help
thanks
That'll...
--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)

June 2, 2022 at 4:08 pm

#4043300
Reply To: SSRS Matrix Month function error

sudhakar wrote:
Hi,
Can someone please suggest, how this can be done?
I have a data region and date and Quantity. I want to display column(Region) and rows(Months) values as Quantity.
But when i...
--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)

June 1, 2022 at 8:43 pm

#4042842
Reply To: Parse txt file

ZZartin wrote:
Bruin wrote:
I was able to fix the source that creates the jobs.txt and remove the space at the beginning of some of the records. Now The Code supplied by...
--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)

June 1, 2022 at 7:36 pm

#4042809
Reply To: Parse txt file

Jeff Moden wrote:
~~Do all of the files have a similar issue? Perhaps you need to tweak the code to handle the anomalies. Frederico offered a hint about that above.~~
And, no... they're...
--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 31, 2022 at 10:08 pm

#4042326

Viewing 15 posts - 3,391 through 3,405 (of 59,086 total)