Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,456 through 16,470 (of 59,067 total)

RE: Speeding Up Delete's on Large Databases

Suth (10/28/2016)
Hi,
I'm currently trying delete data from a large database with the below code... But its taking quite a long time to delete 1000...
--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)

October 29, 2016 at 6:55 am

#1909477
RE: Huge tempdb log file

At this point, it may just be easier and faster to make sure the initial settings for TempDB are correct and then bounce the SQL Server Service.
--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)

October 29, 2016 at 6:35 am

#1909476
RE: sql backup

barsuk (10/28/2016)
Local Backup of 750GB database (using LiteSpeed) takes about 30 mins
If, by "local backup", you mean putting the backup on the same box as the MDF/LDF files, that's pretty...
--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)

October 29, 2016 at 6:08 am

#1909472
RE: Big data: transfer x-number of rows per batch?

wtren (10/28/2016)
It is, but normally SAN shared simultaneously by multiple Servers, that makes things different.
So do a test. Do 3 or 4 file parallel transfers, loads, or backups 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)

October 28, 2016 at 4:17 pm

#1909448
RE: Can you become a BI professional without any Front End Development Skills?

Alan.B (9/28/2016)
T-SQL - that is a skill you need grow if you're going to be a BI Developer. Bad SQL (something I make a living cleaning up) ruins your BI...
--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)

October 28, 2016 at 4:03 pm

#1909446
RE: HELP! I've got to give a talk to our local .NET geek meet on SQL server

aaron.reese (10/28/2016)
... and then retro-fit the underlying data structure ...
I've not seen too many people that will actually do that. It's much easier just to do it right from...
--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)

October 28, 2016 at 12:40 pm

#1909421
RE: Big data: transfer x-number of rows per batch?

wtren (10/27/2016)
SAN normally provide cache to ease it, and SAN is always random io pattern.
Are you saying that a SAN won't stream to multiple contiguous sectors on disk? 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)

October 28, 2016 at 8:15 am

#1909367
RE: Tasks which only a sysadmin can perform

S_Kumar_S (10/28/2016)
Thanks for an elaborated answer Jeff. I surely will look into the points you mentioned.
You bet. Thank you for the feedback.
--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)

October 28, 2016 at 8:05 am

#1909362
RE: Bit of a rant - queries on space

Kazmerelda (10/28/2016)
Jeff Moden (10/27/2016)
Ed Wagner (10/27/2016)
Jeff Moden (10/26/2016)
Kazmerelda (10/25/2016)
My email to them has said I am not prepared to take off backups, and my worry is we won't have 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)

October 28, 2016 at 8:02 am

#1909360
RE: Shrinking the Log file...best practices?

Siberian Khatru (10/28/2016)
Thanks all for the excellent advice and pointers. I am slowly altering all these databases to be of the SIMPLE recovery model and shrinking the LOG files...
--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)

October 28, 2016 at 7:58 am

#1909359
RE: Check for duplicate and send email of duplicates to End User

SQL_Kills (10/27/2016)
I think I have seen it somewhere but I'm not sure how to use the PRINT to displace the sublimate values on the BODY of the email?
Yabingooglehoo helps here...
--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)

October 27, 2016 at 11:51 pm

#1909289
RE: Importing large text file to table

rash3554 (10/26/2016)
Hi there,
I was given a text file with 750 columns and 5,000,000,000 rows. Size of text file is about 5GB. Is it possible to put these...
--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)

October 27, 2016 at 7:34 pm

#1909280
RE: Query to Dynamically Sum Sales Amounts By Month, Quarter, or Year

ptownbro (10/27/2016)
Sorry. This solution would not work for me. I understand there are a lot of ways to setup your solution to make it easy to rollup calendar data. But...
--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)

October 27, 2016 at 5:27 pm

#1909269
RE: Check for duplicate and send email of duplicates to End User

SQL_Kills (10/27/2016)
Hi,
I have the below table
CREATE TABLE [dbo].[BookOrderTest](
[TitleID] [int] NULL,
[Title] [nvarchar](100) NULL,
[Quantity] [int] NULL
) ON [PRIMARY]
insert into bookordertest values (1,'The Catcher in the Rye',3)
insert into bookordertest values (1,'The Catcher...
--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)

October 27, 2016 at 5:04 pm

#1909265
RE: Need help in modifying powershell script

vsamantha35 (10/27/2016)
Hi Powershell Experts,
I have below PS script which will display the database file info like dbname, physicalfilename, size, free,used etc. It is working fine for 1 instance.
However,...
--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)

October 27, 2016 at 4:13 pm

#1909258

Viewing 15 posts - 16,456 through 16,470 (of 59,067 total)