Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,486 through 16,500 (of 59,101 total)

RE: SQL help - how to write a query with reference to its own results

sanda.jan00 (10/29/2016)
Ed Wagner (10/29/2016)
sanda.jan00 (10/29/2016)
Hi,
could anybody help me please with this:
I would like to write a query which retrieves this information: id , days_a_mat (days after maturity) 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 29, 2016 at 1:53 pm

#1909496
RE: Huge tempdb log file

Ed Wagner (10/29/2016)
Something happened to blow out your tempdb. You may not know what it was yet, but you can be sure that it didn't just happen by itself....
--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 11:27 am

#1909490
RE: Stop query if it is taking too long

mah_j (10/29/2016)
I created both indexes,but when I run the query ,it uses non of them.
No matter which indexes you use, you have to do a check to make sure 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 29, 2016 at 11:23 am

#1909489
RE: Speeding Up Delete's on Large Databases

Ok... here we go. First, let's make the understanding that if you only want to keep 1 year of data, you should do deletes every day instead of having...
--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 11:14 am

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

Viewing 15 posts - 16,486 through 16,500 (of 59,101 total)