Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,286 through 18,300 (of 59,070 total)

RE: How minimice the transaction log file growth during maintenance plain

dunno_developer (2/25/2016)
Hi
Have you considered partitioning your large tables?
Partitioning will allow you to maintain your larger tables as you can target only the partitions which are require maintenance.. (depends what...
--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)

February 25, 2016 at 10:35 am

#1861160
RE: string question

astrid 69000 (2/25/2016)
thanks!!!! :kiss:
it worked
The question now is... do you understand it well enough to both maintain it and do it again for something else?
--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)

February 25, 2016 at 8:51 am

#1861111
RE: CPU Usage is so high

ganapathy.arvindan (2/25/2016)
Totally 8 CPU Cores in that first 4 CPU Cores uses more CPU > 50%..after applying trace and tuning advisor steps now it reduced to 35%..
please suggest me reduce...
--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)

February 25, 2016 at 8:45 am

#1861105
RE: User shouldn't be able to run but can in production

Grant Fritchey (2/25/2016)
Jeff Moden (2/25/2016)
Markus (2/25/2016)
Is it possible to run profiler and see what userid is connecting and running that query?
Agreed. Setting it up to find the name of...
--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)

February 25, 2016 at 8:39 am

#1861099
RE: A Good Use for Hadoop

Apparently, all that predictive analysis with a PB per day didn't do squat for Netflix. Their stock dropped from a high of ~131 on 4 Dec 2015 to ~83...
--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)

February 25, 2016 at 8:36 am

#1861096
RE: Optimize this Query

Apologies... David's post reminded me that I didn't actually answer the question as to how to make the queries in the original post faster.
For these...
select gi.*
from tblGeneral gi
join...
--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)

February 25, 2016 at 8:16 am

#1861081
RE: Scrubbing Data - Good idea or bad idea?

TeraByteMe (2/24/2016)
Thanks for all the advice. They all would work well if there was any form of procedure and accountability in the company I work with.
I started the job almost...
--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)

February 25, 2016 at 7:55 am

#1861072
RE: Optimize this Query

kenksoftware (2/24/2016)
I've inherited an ETL project in SSIS which gets the latest records from our legacy database and imports them into an updated database. We have been avoiding using stored...
--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)

February 25, 2016 at 7:23 am

#1861055
RE: Getting Started

My first speech was at Instructor Training for the Navy. There was no preparation involved. It was simply to get our feet wet and all we had 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)

February 25, 2016 at 7:19 am

#1861051
RE: User shouldn't be able to run but can in production

Markus (2/25/2016)
Is it possible to run profiler and see what userid is connecting and running that query?
Agreed. Setting it up to find the name of the proc in 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)

February 25, 2016 at 6:56 am

#1861040
RE: User shouldn't be able to run but can in production

Lowell (2/24/2016)
i use this to enumerate all the members that belong to groups that have been granted access from AD:
i've found that some groups cannot be enumerated int he cases...
--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)

February 24, 2016 at 8:41 pm

#1860958
RE: How minimice the transaction log file growth during maintenance plain

My suggestion would be to find out who's placed the limitations and see if they like high velocity pork chops. If they don't see the light, give the job...
--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)

February 24, 2016 at 8:29 pm

#1860957
RE: Generate restore script from disk for Ola Hallengren backups

Thanks for taking the time to "give back". Ola would probably love to hear about your improvements. You might want to stop by his site and drop 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)

February 24, 2016 at 8:22 pm

#1860955
RE: Getting crash dump and SQL restarting in every 30 minutes

meajaykr (2/24/2016)
We ran the checkDB on all the databases. There were 2 user databases which has index corruption.
We moved 2 databases 2 some other servers and issue is resolved.
But 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)

February 24, 2016 at 8:09 pm

#1860951
RE: Logic for order in calling procedire

mario17 (2/24/2016)
Tx,
They are not really mine, but yes - they are named sp_*, which is doesn't matter for my case I thought.
+ they have at the very top like below,...
--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)

February 24, 2016 at 8:00 pm

#1860949

Viewing 15 posts - 18,286 through 18,300 (of 59,070 total)