Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,921 through 19,935 (of 59,072 total)

RE: Old brain, new question

Please see the first link under "Helpful Links" in my signature line below for future posts.
Here's the readily consumable test data for this problem.
--===== Create the test tables and populate...
--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 8:37 pm

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

That answers my questions #2 and #5. Still looking for answers on #1, 3, and 4. Those may also make a difference.
--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 7:24 pm

#1818377
RE: Old brain, new question

The location of the new post is http://www.sqlservercentral.com/Forums/Topic1709703-338-1.aspx. Please respond there instead of on this post to help keep any answers together. Thanks, folks.
--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 7:02 pm

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

halifaxdal (8/7/2015)
I just got a table with 16736580 records. Index is created.
A test shows a query like
select * from table where charindex(column, keyword) > 1
costs 14 minutes to return result.
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)

August 8, 2015 at 11:40 am

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

Viewing 15 posts - 19,921 through 19,935 (of 59,072 total)