Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,951 through 19,965 (of 59,098 total)

RE: Fragmented Indexes

Lynn Pettis (8/7/2015)
delizat (8/7/2015)
Every situation is different, but this is the order of my backup jobs:
1. Reorganize/Rebuild index
2. Check integrity
3. Update Statistics
4. Backup database.
Please tell me you aren't updating statistics...
--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)

August 8, 2015 at 11:16 am

#1818356
RE: Compatibility Mode causes query not to finish

My first question would be, did you rebuild the indexes and the statistics? Also, have you installed the good version of service pack 1?
--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)

August 8, 2015 at 10:56 am

#1818352
RE: Would the Dedicated Admin Connection have helped here? No SYSADMIN members...

jasona.work (8/8/2015)
I guess that's what happens when a non-SQL person goes to install SQL.
You said a mouthful there. I just went through all of that. New Dev 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)

August 8, 2015 at 10:47 am

#1818349
RE: Restricting Sysadmins from adding new sysadmins

Matt Miller (#4) (8/8/2015)
Jeff Moden (8/7/2015)
I don't know enough about the Cyberark product to save my own life if it became necessary.
That notwithstanding, these types of products supposedly eliminate 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)

August 8, 2015 at 10:40 am

#1818348
RE: Recors in new line in Flat file Destination

happy55 (8/7/2015)
Hi ,
I have a requirement where I have to run a stored procedure and then create a flat file with each column having definite widths and each record in...
--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)

August 7, 2015 at 6:23 pm

#1818325
RE: What can I do to speed it up? Thanks.

Split the table horizontally and parallel process each part.
--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)

August 7, 2015 at 6:20 pm

#1818324
RE: Restricting Sysadmins from adding new sysadmins

I don't know enough about the Cyberark product to save my own life if it became necessary.
That notwithstanding, these types of products supposedly eliminate the need for any administrator logins...
--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)

August 7, 2015 at 2:59 pm

#1818296
RE: Are the posted questions getting worse?

SQLRNNR (8/7/2015)
jasona.work (8/7/2015)
Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we think this...
--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)

August 7, 2015 at 12:30 pm

#1818247
RE: Are the posted questions getting worse?

Ed Wagner (8/7/2015)
It would also use an awful lot of potential bacon by using the whole hog.
Sometimes you just have to go "whole hog" on certain problems. 😀
--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)

August 7, 2015 at 11:06 am

#1818221
RE: Text string parsing, to apply operators to datasets

sgmunson (8/7/2015)
kyagi.jo (8/7/2015)
I did think that would have been likely, does anyone know if there there are any resources on the internet that might give me a headstart on getting...
--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)

August 7, 2015 at 11:01 am

#1818218
RE: Are the posted questions getting worse?

Grant Fritchey (8/5/2015)
jasona.work (8/5/2015)
GilaMonster (8/5/2015)
jasona.work (8/5/2015)
GilaMonster (8/5/2015)
Snippets and a whole pile of script files saved in DropBox and on a creditcard-shaped flash drive (which I need to update).
And to get...
--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)

August 6, 2015 at 5:42 pm

#1818003
RE: Interview Questions Help

Kutang Pan (8/6/2015)
Thank you Lynn, appreciate the effort.
Jeff,
I did try to avoid it but for this particular product i couldnt find better way. For another one I've used merge replication...
--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)

August 6, 2015 at 4:10 pm

#1817989
RE: Amateur Data Analysis

I've found that many people already have a notion of what they want to find in the data rather than finding what the data is telling them. As Granny...
--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)

August 6, 2015 at 11:18 am

#1817935
RE: Interview Questions Help

Kutang Pan (8/6/2015)
When the software is being upgraded it automatuically backs up a database, It's just a full backup, so i thought at least knowing how to do a backup...
--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)

August 6, 2015 at 9:51 am

#1817912
RE: Interview Questions Help

Luis Cazares (8/6/2015)
I would try to go from the basics to the more advanced things to help to determine easier the knowledge and also to give an easy start for...
--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)

August 6, 2015 at 9:22 am

#1817900

Viewing 15 posts - 19,951 through 19,965 (of 59,098 total)